ODI Error "Invalid parameter binding(s)" When Extracting Hyperion Financial Management (HFM) Members

(Doc ID 758996.1)

Last updated on AUGUST 01, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms