'ORA-20002: Errors encountered in the load process for: W_HS_PRODUCT_ACCESS_SECS' in Initial ETL (Doc ID 2965401.1)

Last updated on AUGUST 16, 2023

Applies to:

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

Symptoms

Below error is observed on ODI while executing Argus Analytics Initial ETL (LP_FL_AN job) -

ODI-1519: Serial step "Full Load (InternalID:472)" failed because child step "Parallel - SDE Stage Full Loads (InternalID:529)" is in error.

ODI-1518: Parallel step "Parallel - SDE Stage Full Loads (InternalID:529)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: SCN_01_14_SDE_PRODUCT_ACCESS_SEC_DIM_FL (InternalID:538)

ODI-1217: Session SCN_01_14_SDE_PRODUCT_ACCESS_SEC_DIM_FL (1349) fails with return code ODI-1298.

ODI-1226: Step Int_SDE_Product_Access_Sec_Dim_FL_DS_STEP fails after 1 attempt(s).

ODI-1240: Flow Int_SDE_Product_Access_Sec_Dim_FL_DS_STEP fails while performing a Truncate Error Table - End-IKM AN SQL Control Append - SDE Dim FL- operation. This flow loads target table W_HS_PRODUCT_ACCESS_SECS.

ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-LS_AN_ArgusAnlaytics_UNIT (120)" is in error.

ODI-1298: Serial task "SERIAL-EU-LS_AN_ArgusAnlaytics_UNIT (120)" failed because child task "Truncate Error Table - End-IKM AN SQL Control Append - SDE Dim FL- (180)" is in error.

ODI-1228: Task Truncate Error Table - End-IKM AN SQL Control Append - SDE Dim FL- fails on the target connection DS_AN_ArgusAnlaytics.

Caused By: java.sql.SQLException: ORA-20002: Errors encountered in the load process for: W_HS_PRODUCT_ACCESS_SECS. Please check the error table: AN_DWH.EL$_W_HS_PRODUCT_ACCESS_SECS for more information...

ORA-06512: at line 13

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)