My Oracle Support Banner

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 later
Oracle 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

 

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.