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';


3) Run incremetnal ETL again