My Oracle Support Banner

STARETL Fails With Error 'ORA-01403: no data found' (Doc ID 1552872.1)

Last updated on AUGUST 19, 2019

Applies to:

Primavera Data Warehouse - Version R2.2 and later
Primavera Analytics - Version R2 and later
Information in this document applies to any platform.

Symptoms

The STARETL process fails with an error similar to the following:

ERROR at line 1:
staretl [INFO] (Message) - ORA-01403: no data found
staretl [INFO] (Message) - ORA-06512: at line 239
staretl [INFO] (Progress) - Step 39/48 Part 2/5 - FAILED (1403) (0 hours, 0 minutes, 0 seconds, 796 milliseconds)

Changes

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

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!


In this Document
Symptoms
Changes
Cause
Solution
References

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