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 JUNE 10, 2024

Applies to:

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

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