FDM Adapter For Essbase Connection Fails In 11.1.2.1 When Oracle Client First in PATH Variable (Doc ID 1372529.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.1.000 and later
Information in this document applies to any platform.
*6.18.15*

Symptoms

When attempting to connect to Essbase using FDM 11.1.2.1 the essbase connection fails and returns the error code 1030823.  This error code indicates a Path issue with the ability to use the API.

Changes

 a) Installed EPM System 11.1.2.1 Essbase and FDM
b) Installed the Oracle Client 32 bit including the Oracle Database Utilities, Oracle Provider for OLEDB and Oracle Objects for OLE
c) Installed the Oracle Client 64 bit including the Oracle Database Utilities, Oracle Provider for OLEDB and Oracle Objects for OLE
d) Updated the PATH Variable to have the 32 and 64 bit Oracle Client directories first in the list followed by the Required Essbase Path variables for FDM to function
e) Rebooted the machine. Following the reboot logged into FDM and tested the Essbase Integration. Integration failed with code 1030823

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