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:

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

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