Error: "ORA-00904: "DAILY": invalid identifier" When Running The STARETL Process

(Doc ID 2061048.1)

Last updated on SEPTEMBER 29, 2015

Applies to:

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

Symptoms

When running STARETL process, it failed at step 49 With Error ORA-00904: "DAILY": invalid identifier

For example:
TIMESTAMP staretl INFO (Message) - === Step 49, Part 1
====================================================
TIMESTAMP staretl INFO (Message) - === Merge Project History (populate_temp_spread_per.sql)
TIMESTAMP staretl DEBUG (Message) - SQL Plus(4) : -s ******** @run$script.sql SCRIPTNAME:populate_temp_spread_per.sql
TIMESTAMP staretl INFO (Message) - ACTIVITY HISTORY MERGE :: CURRENT RUN DATE: TIMESTAMP
TIMESTAMP staretl INFO (Message) - Exception: Error during load for table W_ACTIVITY_SPREAD_PER_TS: ORA-00904:
TIMESTAMP staretl INFO (Message) - "DAILY": invali
TIMESTAMP staretl INFO (Message) - (100,W_ACTIVITY_SPREAD_PER_TS,W_ACTIVITY_SPREAD_PER_TS,n/a,n/a)
TIMESTAMP staretl INFO (Message) - DECLARE
TIMESTAMP staretl INFO (Message) - *
TIMESTAMP staretl INFO (Message) - ERROR at line 1:
TIMESTAMP staretl INFO (Message) - ORA-00904: "DAILY": invalid identifier
TIMESTAMP staretl INFO (Message) - ORA-06512: at line 248
TIMESTAMP staretl INFO (Progress) - Step 49/59 Part 1/5 - FAILED (904) (0 hours, 0 minutes, 2 seconds, 340 milliseconds)


STEPS TO REPRODUCE:
1. Build up EPPM R15.1.0.0(B0163) environment with Oracle 11.2.0.4
2. Log-in P6 web with 'admin' user
3. Open one project named "Project Nano"
4. Right click "Set Project Preferences"
5. From left Panel, select Analytics
6. Change the Analytics setting in P6 as below
     History level: Activity
     History Interval: Month
     Activity: Daily (this is set by default to Daily when setting history level to activity)
7. Save and close
8. Publish the project
9. Run Global Scheduled services
10. Run STARETL
11. ETL process failed at the same step 49 with the same error

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