Unable To Transfer Data From HPCM Detailed Profitability To Essbase Cubes. (Doc ID 1632777.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Profitability and Cost Management - Version 11.1.2.3.000 and later
All Platforms
8.10.15

Symptoms

When trying to transfer data from a detailed HPCM application to either "Source Stage Database", "Destination Stage Database" or "Contribution Stage Database" (Essbase database) The taskflow"DPTransferData" fails.

The hpcm.log shows error:
"Error copying data.[[Failed to load data to Essbase

Caused by: com.essbase.api.base.EssException: Cannot begin data load. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server.  See log for more information"

In the Essbase application log you can see:

ON unix:
"Cannot read SQL driver name for [PROFITABILITY_DS] from [/apps/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/.odbc.ini]"

On Windows:
"Cannot read SQL driver name for [PROFITABILITY_DS] from [ODBC.INI]
.....
Data Load Transaction Aborted With Error [1021001]"

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