Unable To Transfer Data From HPCM Detailed Profitability To Essbase Cubes.
Last updated on JULY 28, 2016
Applies to:Hyperion Profitability and Cost Management - Version 22.214.171.124.000 and later
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"" 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:
"Cannot read SQL driver name for [PROFITABILITY_DS] from [/apps/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/.odbc.ini]"
"Cannot read SQL driver name for [PROFITABILITY_DS] from [ODBC.INI]
Data Load Transaction Aborted With Error "
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