My Oracle Support Banner

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 and later
All Platforms


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]"


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.