FDMEE Error while exporting data to HFM

Oct 10, 2018 9:20AM

Hi,

While loading data into HFM through FDMEE we are getting below error

Error in Comm.executeJythonScript

Traceback (most recent call last):

File "<string>", line 563, in executeJythonScript

File "E:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_EXPORT.py", line 835, in <module>

result = export(fdmAPI,fdmContext)

File "E:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_EXPORT.py", line 636, in export

strLine += rsExport.getString("UD" + str((x + 2))) + DELIM

SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver]Invalid column name: UD7

Import and Validation were successful, while exporting we are getting above error. Import type is flat file

Please let me know the cause of this error and how to mitigate this.

Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)