Argus Mart Full Load ETL - LP_INI_AM Failed With Error ODI-1519: Serial step "root_step...
(Doc ID 2897207.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 8.2.1 and laterOracle Life Sciences Argus Safety Cloud Service - Version 8.2 and later
Information in this document applies to any platform.
Symptoms
Argus Mart Full Load ETL - LP_INI_AM Failed with error:
ODI-1519: Serial step "root_step (InternalID:476)" failed because child step "SCN_exec_etl_custom_hooks_POST_ETL_POPULATION (InternalID:740)" is in error.
ODI-1217: Session SCN_exec_etl_custom_hooks_POST_ETL_POPULATION (53408) fails with return code 20010.
ODI-1226: Step PRC_exec_etl_custom_hooks_POST_ETL_POPULATION fails after 1 aattempt(s).
ODI-1232: Procedure PRC_exec_etl_custom_hooks_POST_ETL_POPULATION execution fails.
ODI-1228: Task Procedure-PRC_exec_etl_custom_hooks_POST_ETL_POPULATION-Command 0 fails on the target connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLException: ORA-20010: ORA-1403: no data found
ORA-6512: at "AM_MART_USER.SMQ_PT_UTILS", line 25
ORA-6512: at "AM_MART_USER.EMPIRICA_UTILS", line 6
ORA-6512: at line 1
ORA-6512: at "AM_MART_USER.TRG_SM_ETL_CUSTOM_HOOKS", line 3
ORA-6512: at "AM_MART_USER.PKG_SM_UTIL", line 877
ODI-1217: Session SCN_exec_etl_custom_hooks_POST_ETL_POPULATION (53408) fails with return code 20010.
ODI-1226: Step PRC_exec_etl_custom_hooks_POST_ETL_POPULATION fails after 1 aattempt(s).
ODI-1232: Procedure PRC_exec_etl_custom_hooks_POST_ETL_POPULATION execution fails.
ODI-1228: Task Procedure-PRC_exec_etl_custom_hooks_POST_ETL_POPULATION-Command 0 fails on the target connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLException: ORA-20010: ORA-1403: no data found
ORA-6512: at "AM_MART_USER.SMQ_PT_UTILS", line 25
ORA-6512: at "AM_MART_USER.EMPIRICA_UTILS", line 6
ORA-6512: at line 1
ORA-6512: at "AM_MART_USER.TRG_SM_ETL_CUSTOM_HOOKS", line 3
ORA-6512: at "AM_MART_USER.PKG_SM_UTIL", line 877
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 |