My Oracle Support Banner

Error "ORA-01403: no data found" and Unifier ETL Fails in Step 17/78 Part 2/2 for W_BP_DS and W_BP_FS (Doc ID 2983061.1)

Last updated on OCTOBER 30, 2023

Applies to:

Primavera Analytics - Version 21.12 and later
Information in this document applies to any platform.

Symptoms

Running the Unifier ETL process fails at step 17 - "Extract data from Unifier source database (source_extract_unifier)" and the following errors occur in the log:

INFO ETL.Message - (100,SYS_STG_BP,W_BP_FS,n/a,n/a)
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 67
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 58
INFO ETL.Message - Exception: Error during extract for table W_BP_FS: ORA-01403: no data found
INFO ETL.Message - (100,SYS_STG_BP,W_BP_FS,n/a,n/a)
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 138
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 67
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 58
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2STGSOURCE", line 24
INFO ETL.Message - Exception: Error during extract for table W_BP_FS: ORA-01403: no data found
INFO ETL.Message - (100,SYS_STG_BP,W_BP_FS,n/a,n/a)
INFO ETL.Message - DECLARE
INFO ETL.Message - *
INFO ETL.Message - ERROR at line 1:
INFO ETL.Message - ORA-01403: no data found
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2STGSOURCE", line 32
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 138
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 67
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 58
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2STGSOURCE", line 24
INFO ETL.Message - ORA-06512: at line 4
INFO ETL.Message - Exception: Error during extract for table W_BP_DS: ORA-01403: no data found
INFO ETL.Message - (100,SYS_STG_BP,W_BP_DS,n/a,n/a)
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 67
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 58
INFO ETL.Message - Exception: Error during extract for table W_BP_DS: ORA-01403: no data found
INFO ETL.Message - (100,SYS_STG_BP,W_BP_DS,n/a,n/a)
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 138
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 67
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 58
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2STGSOURCE", line 24
INFO ETL.Message - Exception: Error during extract for table W_BP_DS: ORA-01403: no data found
INFO ETL.Message - (100,SYS_STG_BP,W_BP_DS,n/a,n/a)
INFO ETL.Message - DECLARE
INFO ETL.Message - *
INFO ETL.Message - ERROR at line 1:
INFO ETL.Message - ORA-01403: no data found
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2STGSOURCE", line 32
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 138
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 67
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2UNIFSTAGING", line 58
INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2STGSOURCE", line

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!


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