STARETL Step 16 Fails PLS-00905: object STARUSER.STATUS_START_RUN is invalid ORA-06550:PL/SQL: Statement ignored staretl INFO (Progress) - Step 16/59 Part 1/1 - FAILED (Doc ID 2064525.1)

Last updated on OCTOBER 22, 2015

Applies to:

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

Symptoms

When attempting to run the STAR ETL process, the following error occurs on step 16:

ERROR
-----------------------
staretl INFO (Progress) - Step 16/59 Part 1/1 - TIMESTAMP StartProcess -- Start ETL Process
staretl INFO (Message) - === Step 16, Part 1 ====================================================
staretl INFO (Message) - === Start ETL Process
staretl DEBUG (Message) - SQL Plus(3) : -s ******** @run$script.sql
staretl INFO (Message) - BEGIN status_start_run('FULL'); END;
staretl INFO (Message) - *
staretl INFO (Message) - ERROR at line 1:
staretl INFO (Message) - ORA-06550: line 1, column 7:
staretl INFO (Message) - PLS-00905: object STARUSER.STATUS_START_RUN is invalid
staretl INFO (Message) - ORA-06550: line 1, column 7:
staretl INFO (Message) - PL/SQL: Statement ignored
staretl INFO (Progress) - Step 16/59 Part 1/1 - FAILED (6550) (0 hours, 0 minutes, 1 seconds, 828 milliseconds)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Run staretl.bat
  2. Step 1-15 complete successfully
  3. See error on step 16

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