PPM Support Tip: Incremental ETL failing for CP1.3 ORA-02097 and ORA-01031

 

knowledge base article: KM00768181

 

Customer installed CP1.3 without any issues.

 

However, the Incremental ETL is failing with the following error:

 

Error:ORA-20000: Error:ORA-20000: incremental etl failed  -20000 ORA-20000: ORA-20001: Job failed: ORA-12801: error signaled in parallel query server P002, instance msp0lract004.etdbw.com:o1m1cdw2 (2)
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01031: insufficient privileges, error code:-20000, error code:-20000

 

Please run the following steps,

 

1)Back up your BO Schema


2)Run the following in BO schema

 

update rpt_params set parameter_value = 'TRUE' where parameter_name='ATOMIC_REFRESH_FLAG';
commit;

 

3) Run incremetnal ETL again

Tags: