Unable to remove some attributes from Audit

Products

• Clarity PPM On Premise

Issue/Introduction

When trying to remove some attributes from audit (Project Start Date and Finish Date), Clarity throws an Internal Server Error.

In the app-ca.log, we see:

ERROR [...] audit.AuditTriggerBuilder (clarity:<user>:<session>:odf.saveAuditedAttributesList) [...]
com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'TT_PROJECT_OODF_CA_INV' in the database.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)

Environment

Clarity 16.3.3 using Microsoft SQL Server

Resolution

1. Note or take a screenshot of all the Audited Attributes that are listed in the Project object.
2. Go to the Audit configuration and remove ALL attributes, so that no attribute is audited, and Save.
3. Restore the Audit configuration by adding back the noted attributes and click Save.
4. If the TT_ trigger (temporary trigger) is still blocking the audit trail update actions on the UI then have the DBA drop the trigger manually from the niku database
   for e.g. DROP TRIGGER niku.TT_PROJECT_OODF_CA_INV;
5. Repeat step 3 to validate.