Unable To Transfer Data From HPCM Detailed Profitability To Essbase Cubes.
(Doc ID 1632777.1)
Last updated on JANUARY 11, 2020
Applies to:Hyperion Profitability and Cost Management - Version 220.127.116.11.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 "
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document