All Data Type Data Load to Planning Application Does Not Show Up Data In the Target Planning Even Though The FDMEE Process Complete Successfully. (Doc ID 2431089.1)

Last updated on SEPTEMBER 24, 2024

Applies to:

Symptoms

"All Data Type" data load from FDMEE to planning application complete successfully.
However data is not available/visible in the target planning application.

Process log has captured exception - NoAvailableOlapConnectionsException: Unable to obtain a connection to Hyperion Essbase.

2018-07-31 11:34:21,115 DEBUG [AIF]: loadMethod: OLU
2018-07-31 11:34:21,115 DEBUG [AIF]: dataFileFullName: /u01/app/oracle/product/fmw/user_projects/domains/EPMSystem/FDMEEApps/XXXXXX/outbox/XXXXXX_5348.dat
2018-07-31 11:34:21,116 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 5348 and parameter_name = 'DATE_FORMAT'
2018-07-31 11:34:21,116 DEBUG [AIF]: dateFormat: DD-MM-YYYY
Property file arguments: /DF:DD-MM-YYYY /TR /I:/u01/app/oracle/product/fmw/user_projects/domains/EPMSystem/FDMEEApps/XXXXXX/outbox/XXXXXX_5348.dat
No arguments were derived from the command line.Submitted (merged) command line:
 /DF:DD-MM-YYYY /TR /I:/u01/app/oracle/product/fmw/user_projects/domains/EPMSystem/FDMEEApps/XXXXXX/outbox/XXXXXX_5348.dat
[Tue Jul 31 11:34:21 EDT 2018]Successfully located and opened input file.
[Tue Jul 31 11:34:21 EDT 2018]Input file being read with UTF-8 encoding.
[Tue Jul 31 11:34:21 EDT 2018]Date format pattern "DD-MM-YYYY" specified for date data type loading.
[Tue Jul 31 11:34:21 EDT 2018]Header record fields: Driver Member, Point-of-View, Data Load Cube Name, Value
[Tue Jul 31 11:34:21 EDT 2018]Located and using "OFADataLoadDimension" dimension for loading data in "XXXXXX" application.
[Tue Jul 31 11:34:21 EDT 2018]Parent-child ordering option (/H switch) will not be performed: this option is not available for the "OFADataLoadDimension" dimension.
[Tue Jul 31 11:34:21 EDT 2018]Input file member load ordering option (/O switch) will not be performed: this option is only available for (non /IE) import operations.
[Tue Jul 31 11:34:21 EDT 2018]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: dd/MM/yy, sessionId: 1386321674
[Tue Jul 31 11:34:21 EDT 2018]Unable to obtain dimension information and/or perform a data load: com.hyperion.planning.olap.NoAvailableOlapConnectionsException: Unable to obtain a connection to Hyperion Essbase.  If this problem persists, please contact your administrator.
[Tue Jul 31 11:34:21 EDT 2018]Trace information: com.hyperion.planning.HyperionPlanningBean::createExternalException:10419, com.hyperion.planning.HyperionPlanningBean::endLoad:10107, com.hyperion.planning.utils.HspOutlineLoad::parseAndLoadInputFile:2007, com.hyperion.planning.utils.HspOutlineLoad::halAdapterInfoAndLoad:341, com.hyperion.planning.utils.HspOutlineLoad::loadAndPrintStatus:5496, com.hyperion.planning.utils.HspOutlineLoad::outlineLoadAsyncImpl:4468,
.....

FDMEE data load Process complete with a green check though.

2018-07-31 11:34:23,742 DEBUG [AIF]: Comm.finalizeProcess - START
2018-07-31 11:34:23,744 DEBUG [AIF]: CommData.updateRuleStatus - START
2018-07-31 11:34:23,744 DEBUG [AIF]:
    UPDATE AIF_BALANCE_RULES
    SET STATUS = CASE 'SUCCESS'
      WHEN 'SUCCESS' THEN
        CASE ( SELECT COUNT(*) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 5348 AND pd.STATUS IN ('FAILED','WARNING') )
          WHEN 0 THEN 'SUCCESS'
          ELSE ( SELECT MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 5348 AND pd.STATUS IN ('FAILED','WARNING') ) END
      ELSE 'SUCCESS' END
    WHERE RULE_ID = 144
    
2018-07-31 11:34:23,751 DEBUG [AIF]: CommData.updateRuleStatus - END
.....

Cause

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