ODI Error "Invalid parameter binding(s)" When Extracting Hyperion Financial Management (HFM) Members
(Doc ID 758996.1)
Last updated on NOVEMBER 09, 2023
Applies to:
Oracle Data Integrator - Version 10.1.3.4.0 and laterHyperion Financial Management - Version 9.3.1.0.00 and later
Information in this document applies to any platform.
Symptoms
The following error occurs at Extract HFM Members step when running an Integration Interface that extracts data from a Hyperion Financial Management Model Datastore Account to a Microsoft SQL Server table using LKM Hyperion Financial Management Member to SQL:
org.apache.bsf.BSFException: exception from Jython: Traceback (innermost last):
File "<string>", line 1, in ?
com.hyperion.odi.common.ODIHAppException: [Microsoft][SQLServer 2000 Driver for JDBC] Invalid parameter binding(s).
at com.hyperion.odi.hfm.ODIHFMMemberListExtracter.execute(ODIHFMMemberListExtracter.java:81)
...
Caused by: com.microsoft.jdbc.base.BaseBatchUpdateException: MicrosoftSQLServer 2000 Driver for JDBCInvalid parameter binding(s)....
at com.microsoft.jdbc.base.BasePreparedStatement.executeBatchEmulation(Unknown Source)
at com.microsoft.jdbc.base.
If the target is an Oracle table, the error is:
org.apache.bsf.BSFException: exception from Jython: Traceback (innermost last):
File "<string>", line 1, in ?
com.hyperion.odi.common.ODIHAppException: Missing IN or OUT parameter at index:: 1
at com.hyperion.odi.hfm.ODIHFMMemberListExtracter.execute(ODIHFMMemberListExtracter.java:81)
at com.hyperion.odi.hfm.ODIHFMAppStatement.executeExtract(ODIHFMAppStatement.java:119)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |