Data Extract Failed From On Prem Database (Doc ID 2902631.1)

Last updated on JANUARY 06, 2023

Applies to:

Symptoms

While running DLR, process is failing to connect with EPM Agent.

2022-10-11 06:01:47,669 DEBUG [AIF]: Adding DB credentials
2022-10-11 06:01:47,675 DEBUG [AIF]: Adding DB bind variables
2022-10-11 06:01:47,681 DEBUG [AIF]: Adding DB query
2022-10-11 06:01:47,692 INFO  [AIF]: Original Extract Query:Select * From  V_EPM_CORP_SA where "Fin Year" = ~Year~ and "Month" = ~Period~
2022-10-11 06:01:47,692 INFO  [AIF]: Entering method parseQuery with sql:Select * From  V_EPM_CORP_SA where "Fin Year" = ~Year~ and "Month" = ~Period~
2022-10-11 06:01:47,692 INFO  [AIF]: UPDATED QUERY:Select * From  V_EPM_CORP_SA where "Fin Year" = ~Year~ and "Month" = ~Period~
2022-10-11 06:01:47,692 DEBUG [AIF]: Adding delimiter
2022-10-11 06:01:47,714 DEBUG [AIF]: Adding fetchSize
2022-10-11 06:01:47,726 INFO  [AIF]: Retrieved EPM Cluster name:XXXXXX
2022-10-11 06:01:47,728 INFO  [AIF]: Retrieved Cluster Mode:null
2022-10-11 06:01:47,728 INFO  [AIF]: Calling agent extract SYNC mode: BEGIN
2022-10-11 06:01:47,737 INFO  [AIF]: Retrieved EPM Agent name:XXXXXXX
2022-10-11 06:01:47,743 INFO  [AIF]: Request Payload Length:1773
2022-10-11 06:01:48,394 ERROR [AIF]: Error occurred while calling EPMI agent: java.net.UnknownHostException: XXXXXXXXXXX.local
2022-10-11 06:01:48,394 ERROR [AIF]: Unexpected error in importData:Error occurred while calling EPMI agent: java.net.UnknownHostException: XXXXXXXXXXXX.local
2022-10-11 06:01:48,397 ERROR [AIF]: java.lang.RuntimeException: Error occurred while calling EPMI agent: java.net.UnknownHostException: XXXXXXXXXXXX.local
2022-10-11 06:01:48,398 ERROR [AIF]: The script has failed to execute:
2022-10-11 06:01:48,401 FATAL [AIF]: Error in Comm.executeJythonScript
Traceback (most recent call last):
  File "<string>", line 485, in executeJythonScript
  File "/u01/test/PBCS_22.10.65/EPMSystem11R1/products/FinancialDataQuality/bin/plugin/OnPremDBExtractData.py", line 47, in <module>
    raise Exception(str(sys.exc_info()[1]).encode("utf-8"))
Exception: java.lang.RuntimeException: Error occurred while calling EPMI agent: java.net.UnknownHostException: 5IREPM08202201.vpj.local

2022-10-11 06:01:48,402 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 = 25 AND ENTITY_TYPE = 'PROCESS_EXTRACT_DATASOURCE' AND ENTITY_NAME = 'SunSystem_TB'
    
2022-10-11 06:01:48,412 FATAL [AIF]: Error in FileData.extractDataFromSource
Traceback (most recent call last):
  File "<string>", line 155, in extractDataFromSource
  File "<string>", line 444, in executeAdapterScript
  File "<string>", line 485, in executeJythonScript
  File "/u01/test/PBCS_22.10.65/EPMSystem11R1/products/FinancialDataQuality/bin/plugin/OnPremDBExtractData.py", line 47, in <module>
    raise Exception(str(sys.exc_info()[1]).encode("utf-8"))
Exception: java.lang.RuntimeException: Error occurred while calling EPMI agent: java.net.UnknownHostException: XXXXXXXXXXXXXX.local

Cause

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