STARETL Fails With Error: "ORA-01403: no data found | ORA-06512: at line xxx" (Doc ID 1552872.1)

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.

Symptoms

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)

Changes

 This issue most likely would occur during the initial setup of the P6 Reporting Database (STAR).

Cause

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 hundreds of Community platforms