Time Slicing job fails with audit trigger is invalid after refresh

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Time Slicing job fails after database refresh with error:

java.base/java.lang.Thread.run(Thread.java:840)
Caused by: java.sql.SQLSyntaxErrorException: ORA-04098: trigger 'CLarity.T_TEAM_PPRTEAM' is invalid and failed re-validation
ORA-06512: at "CLARITY.PRJ_BLB_UPDATE_TEAMS_SP", line 5
ORA-06512: at line 1

Cause

Audit triggers not validated

Resolution

1. Request the DBA to review the triggers and recompile them
2. If any error during compile, address the specific error

For audit triggers that are not fixed this way: 

1. Connect to UI Classic - Administration - Studio - Open the respective object - Audit
2. Take note (screenshots) of all included attributes
3. Remove all auditing, save
4. Drop the affected trigger
5. Now re-add the same audited fields in UI

 

Additional Information

Also check a known issue: TSV Audit hardcodes schema name in audit triggers