My Oracle Support Banner

Extracting The Data From Planning Application Fails With Error "Cannot Calculate Essbase Error(1023040) Msg From Remote Site" (Doc ID 2980453.1)

Last updated on OCTOBER 13, 2023

Applies to:

Oracle Hyperion Profitability and Cost Management Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : NA version, Data Management

Error in PCMCS Data Management while extracting the data from PBCS application.
 
Error from Process.log
------------------------

ERROR [AIF]: Cannot calculate. Essbase Error(1023040): msg from remote site [[DDMMYYYY]Local////Error(1051293) Login fails due to invalid login credentials]
INFO [AIF]: EssbaseService.extractData - END (false)
ERROR [AIF]: false
--------------------------------------------------------- END: Process Log From the Rest Job ---------------------------------------------------------
ERROR [AIF]: The rest service job has failed, see details above.
INFO [AIF]: EssbaseService.extractData - END (false)
DEBUG [AIF]: AIFUtil.callOdiServlet - END
FATAL [AIF]: Error in CommData.extractDataFromSource
Traceback (most recent call last):
  File "", line 2862, in extractDataFromSource
RuntimeError: false

DEBUG [AIF]: Comm.finalizeProcess - START
DEBUG [AIF]: CommData.updateRuleStatus - START
DEBUG [AIF]:
  UPDATE AIF_BALANCE_RULES
  SET STATUS = CASE 'FAILED'
  WHEN 'SUCCESS' THEN
  CASE ( SELECT COUNT(*) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 2158 AND pd.STATUS IN ('FAILED','WARNING') )
  WHEN 0 THEN 'SUCCESS'
  ELSE ( SELECT MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 2158 AND pd.STATUS IN ('FAILED','WARNING') ) END
  ELSE 'FAILED' END
  WHERE RULE_ID = 32
  
DEBUG [AIF]: CommData.updateRuleStatus - END
FATAL [AIF]: Error in Comm Extract Data
DEBUG [AIF]: Comm.updateProcess - START
DEBUG [AIF]: Comm.updateProcess - END
DEBUG [AIF]: The fdmAPI connection has been closed.
DEBUG [AIF]: Comm.finalizeProcess - END
INFO [AIF]: FDMEE Process End, Process ID: 2158

Changes

 

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
References


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