Loading Open Interface table using BefImport script fails
Hi there, I'm using FDMEE on version 11.1.2.3.700.09 and struggling to get this script to work and load the open interface table with data from the GL.
Here is the script:
import java.sql as sql
batchName = "Batch_" + str(fdmContext["LOCATION"])
insertStmt = """INSERT INTO AIF_OPEN_INTERFACE
( BATCH_NAME
,YEAR
,PERIOD
,SCENARIO
,ENTITY
,AMOUNT
,ICP PARTNER
,CUSTOM1
,CUSTOM3
,VALUE
)
SELECT ?, year, period, scenario, entity, amount ,icp partner, custom1, custom3, value) FROM [VSGLWSQL1].[CUSTOMERDBNAME].[DBO].[rHFMFinancialData]
params = [batchName, "2016","Jan"]
fdmAPI.executeDML(insertStmt, params, False)
fdmAPI.commitTransaction()
and here is the error:
2016-08-15 12:45:11,673 INFO [AIF]: Executing the following script: \\srv-glas507\FDMData/data/scripts/event/BefImport.py