STARETL Fails With Error: "ORA-01403: no data found | ORA-06512: at line xxx"
Last updated on JULY 10, 2017
Applies to:Primavera P6 Reporting Database - Version R2.2 and later
Primavera P6 Analytics - Version R2 and later
Information in this document applies to any platform.
The STARETL fails with an error similar to the following:
<05.03.2013 07:45:05> staretl [INFO] (Message) - ERROR at line 1:
<05.03.2013 07:45:05> staretl [INFO] (Message) - ORA-01403: no data found
<05.03.2013 07:45:05> staretl [INFO] (Message) - ORA-06512: at line 239
<05.03.2013 07:45:05> staretl [INFO] (Progress) - Step 39/48 Part 2/5 - FAILED (1403) (0 hours, 0 minutes, 0 seconds, 796 milliseconds)
This issue most likely would occur during the initial setup of the P6 Reporting Database (STAR).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms