Error: Cannot get the olap server name for planning application XXXXX (Doc ID 2293325.1)

Last updated on AUGUST 03, 2017

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.100 and later
Information in this document applies to any platform.

Symptoms

During Data Load Process, FDMEE unable to communicate with Essbase.

++ Issue mainly we can see when Essbase cluster configured as  Active Passive setup.

++ Able to browse Planning/Essbase applications from Calculation Manager UI.

++ Data Export from FDMEE to Planning resulting in the following error in ErpIntegrator0.log

[2017-04-27T12:40:25.489+04:00] [ErpIntegrator0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 30] [userId: ] [ecid: 00ifBU1xzz1Fw00Fzzw0w00001I40003lD,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.util.RegistryUtil] [SRC_METHOD: getEssbaseRegisteredServers] Essbase URL:http://hyperionprodint.etisalat.com:19000/aps/Essbase?clusterName=EssbaseClusterProd
[2017-04-27T12:40:25.520+04:00] [ErpIntegrator0] [ERROR] [EPMFDM-140145] [oracle.apps.erpi.model] [tid: 30] [userId: ] [ecid: 00ifBU1xzz1Fw00Fzzw0w00001I40003lD,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.util.RegistryUtil] [SRC_METHOD: getEssbaseServerName] Application XXXXX could not be found on Essbase server
[2017-04-27T12:40:25.520+04:00] [ErpIntegrator0] [ERROR] [] [oracle.apps.erpi.model] [tid: 30] [userId: ] [ecid: 00ifBU1xzz1Fw00Fzzw0w00001I40003lD,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.EssbaseService] [SRC_METHOD: extractData] Cannot get the olap server name for planning application XXXXX[[
java.lang.Exception: Cannot get the olap server name for planning application XXXXX
at com.hyperion.aif.hpl.data.DataExporter.initializeOlapConnection(DataExporter.java:367)
at com.hyperion.aif.hpl.data.DataExporter.exportData(

++ Error in FDMEE Process log

2017-06-16 17:07:05,615 DEBUG [AIF]: app id:33, app name:XXXXX, app type:HPL, currency flag:false, dataLoadMethod:CLASSIC_VIA_EPMI, exportMode:STORE_DATA, mDataFlowMode:OP_TO_OP
2017-06-16 17:07:05,615 INFO [AIF]: LOAD_METHOD:ESSSQL, BATCH_SIZE:10000, PREFIX_DIM_DUPLICATE_MEM:true, PURGE_DATA_FILE:false, CREATE_DRILL_REGION:false
2017-06-16 17:07:05,615 DEBUG [AIF]: GlobalUserForAppAccess from Profile: null
2017-06-16 17:07:05,615 INFO [AIF]: Cloud Mode: NONE, Resolved user name for application access: USERNAME
2017-06-16 17:07:05,740 DEBUG [AIF]: Extracting data from XXXXX:XXXX...
2017-06-16 17:07:05,865 ERROR [AIF]: Cannot get the olap server name for planning application XXXXX
2017-06-16 17:07:05,865 INFO [AIF]: EssbaseService.extractData - END (java.lang.Exception: Cannot get the olap server name for planning application XXXXX)
2017-06-16 17:07:05,880 DEBUG [AIF]: AIFUtil.callOdiServlet - END
2017-06-16 17:07:05,880 FATAL [AIF]: Error in CommData.extractDataFromSource
Traceback (most recent call last):
File "<string>", line 5143, in extractDataFromSource
RuntimeError: java.lang.Exception: Cannot get the olap server name for planning application XXXXX

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms