My Oracle Support Banner

Initial ETL Failure After Upgrading To 8.1.2 (Doc ID 2377380.1)

Last updated on JUNE 09, 2020

Applies to:

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

Symptoms

During the execution of the Initial ETL,the following error is observed in ODI:

ODI-1519: Serial step "root_step (InternalID:2)" failed because child step "SCN_populate_dict_to_process (InternalID:202)" is in error.
ODI-1217: Session SCN_populate_dict_to_process (369) fails with return code 20010.
ODI-1226: Step PRC_populate_dict_to_process fails after 1 attempt(s).
ODI-1232: Procedure PRC_populate_dict_to_process execution fails.
ODI-1228: Task Procedure-PRC_populate_dict_to_process-Command 0 fails on the target connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLException: ORA-20010: ORA-00904: "A"."VERSION": invalid identifier
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 803

-- ERROR while processing p_populate_dict_to_process
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 103
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 863
ORA-06512: at line 3

The referenced column (VERSION) did not exist until 8.1.2.

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.