Upgrade failing referencing to Audit Triggers

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Steps to Reproduce: 

1. Set up a clarity system with few attributes enabled for trigger 
2. Ensure services are stopped 
3. Start the upgrade 

Expected Results: Upgrade should be successful 

Actual Results: Upgrade fails with below error 

8/01/24 6:20 AM (ExecTask) Total bootstrap time: 0H:0M:9.49SException in thread "main" com.niku.union.persistence.PersistenceException: Invalid trigger

Environment

Clarity Release: 16.2.x 

Cause

DE153656

Resolution

Workaround: 

• Roll back the upgrade 
• Disable audit for the objects where upgrade failed by checking the install.log
• Created an attribute to ensure meta data of object is regenerated or Drop audit trigger start is %T_
• Re run the upgrade