My Oracle Support Banner

Fusion Apps (FA)/Essbase: FA 18.10 : GL Cube Creation Failing, FA_BATCH Not Working With 7.1.4 ODBC Driver (Doc ID 2480085.1)

Last updated on AUGUST 03, 2022

Applies to:

Hyperion Essbase - Version and later
Information in this document applies to any platform.
These steps are applicable from FA REL13 and above. When trying these steps on other environments like EPM for FA REL13 below versions, paths have to updated accordingly.


Cube creation from FA is failing with the following errors:

ess job log has the following error:

buildCurrencyDimension(): Exception :: Cannot incremental build. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server. See log for more information printErrorFile()::Exception FileNotFoundException::/tmp/CurrencyDimBuild.err


Essbase Applicaion log has following error:

[Mon Aug 13 08:26:22 2018]Local/INFLedger/db/FUSION_APPS_GL_ESSBASE_APPID/140348085643008/Info(1021013) ODBC Layer Error: [08001] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.]

[Mon Aug 13 08:26:22 2018]Local/INFLedger/db/FUSION_APPS_GL_ESSBASE_APPID/140348085643008/Info(1021014) ODBC Layer Error: Native Error code [4294967292]

[Mon Aug 13 08:26:22 2018]Local/INFLedger/db/FUSION_APPS_GL_ESSBASE_APPID/140348085643008/Error(1021001) Failed to Establish Connection With SQL Database Server. See log for more information

[Mon Aug 13 08:26:22 2018]Local/INFLedger/db/FUSION_APPS_GL_ESSBASE_APPID/140348085643008/Error(1090013) Cannot Open Data Source


Essbase Agent log has following error:

java.sql.SQLException: Invalid or Stale Connection found in the Connection Cache






FA_BATCH in tnsnames.ora is configured with (SERVER = DEDICATED) which caused the issue. 



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.