My Oracle Support Banner

Argus Mart Incremental ETL fails with error - ORA-00942: table or view does not exist (Doc ID 2785916.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Mart - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

After the application of OCT 2020 CPU Patch, Argus Mart Incremental ETL failed with the below error, while creating STAGE INDEXES:

ODI-1519: Serial step "root_step (InternalID:266)" failed because child step "SCN_manage_sm_stage_indexes(1,0,2) (InternalID:289)" is in error.
ODI-1217: Session SCN_manage_sm_stage_indexes(1,0,2) (5419) fails with return code 20010.
ODI-1226: Step PRC_manage_sm_stage_indexes(1,0,2) fails after 1 attempt(s).
ODI-1232: Procedure PRC_manage_sm_stage_indexes(1,0,2) execution fails.
ODI-1228: Task Procedure-PRC_manage_sm_stage_indexes(1,0,2)-Command 0 fails on the target connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLException: ORA-20010: ORA-20011: ORA-00942: table or view does not exist
-- ERROR while processing SCASE_REG_REPORTS.
At 17-MAY-21
ORA-06512: at "AM_MART_USER.PKG_SM_UTIL", line 1825
ORA-06512: at "AM_STAGE_USER.PKG_SM_STAGE_UTIL", line 160

-- ERROR while processing p_manage_sm_stage_indexes at 17-May-2021 00:07:39
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 123
ORA-06512: at "AM_STAGE_USER.PKG_SM_STAGE_UTIL", line 179
ORA-06512: at line 3

Changes

OCT 2020 CPU Patch was applied on the Argus Mart Database Server, which was on Oracle Version 12c

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
References


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