My Oracle Support Banner

Error: "EPM agent failed to extract data" When Using Credential Store Set to File in Datasource Target Application (Doc ID 2666748.1)

Last updated on MAY 06, 2020

Applies to:

Oracle Enterprise Planning and Budgeting Cloud Service - Version 20.03.50 and later
Oracle Planning and Budgeting Cloud Service - Version 20.03.50 and later
Information in this document applies to any platform.

Symptoms

When attempting to import data from Datasource application with Credential Store in application options set to "File",
the following error occurs.

ERROR
-----------------------
INFO [AIF]: Appending agent log to process log.
DEBUG [AIF]: Updating Agent Processes: FAILED
Appending EPM agent log to process:: END
Unexpected error in importData:EPM agent failed to extract data.
ERROR [AIF]: java.lang.RuntimeException: EPM agent failed to extract data.
ERROR [AIF]: The script has failed to execute:
FATAL [AIF]: Error in Comm.executeJythonScript
Traceback (most recent call last):
File "", line 580, in executeJythonScript
File "<Location>/OnPremDBExtractData.py", line 123, in
raise Exception(str(sys.exc_info()[1]).encode("utf-8"))

Exception: java.lang.RuntimeException: EPM agent failed to extract data.

DEBUG [AIF]:
UPDATE AIF_PROCESS_DETAILS
SET STATUS = 'FAILED'
 ,RECORDS_PROCESSED = CASE WHEN RECORDS_PROCESSED IS NULL THEN 0 ELSE RECORDS_PROCESSED END + NULL
  ,EXECUTION_END_TIME = CURRENT_TIMESTAMP
  ,LAST_UPDATED_BY = CASE WHEN (NULL IS NULL) THEN LAST_UPDATED_BY ELSE NULL END
  ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
  WHERE PROCESS_ID = 261 AND ENTITY_TYPE = 'PROCESS_EXTRACT_DATASOURCE' AND ENTITY_NAME = 'ADS_DS'
  
FATAL [AIF]: Error in FileData.extractDataFromSource
Traceback (most recent call last):
File "", line 156, in extractDataFromSource
File "", line 537, in executeAdapterScript
File "", line 580, in executeJythonScript
File "<Location>/OnPremDBExtractData.py", line 123, in
raise Exception(str(sys.exc_info()[1]).encode("utf-8"))
Exception: java.lang.RuntimeException: EPM agent failed to extract data.

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


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