My Oracle Support Banner

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 later
Hyperion 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.