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:

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

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