FDMEE Export to HFM Fails with error: "Error in CommData.exportDataTraceback ... in executeVBScript RuntimeError: -4" (Doc ID 1613234.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.3.000 and later
Information in this document applies to any platform.

Symptoms

When attempting to export data from Financial Data Quality Management Enterprise Edition (FDMEE) to Hyperion Financial Management (HFM)  the export step of the workflow is failing with error:

Error in CommData.exportDataTraceback ... in executeVBScript RuntimeError: -4

The Windows Application Event Logs contains the following errors:

System.Runtime.InteropServices.COMException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
at erpiHFMAdapter.dbClass.ConnectDB()

or

System.Runtime.InteropServices.COMException (0x80004005): [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
at erpiHFMAdapter.dbClass.ConnectDB()

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