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 DECEMBER 04, 2018

Applies to:

Hyperion Essbase - Version 11.1.2.4.000 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.

Symptoms

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

at

oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitCon nectionCache.java:417)

 

 

Changes

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

 

Cause

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
Symptoms
Changes
Cause
Solution

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