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.
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.
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