"ODF_AUD_VALUE_FCT" line 26 error generated by Audit tab

Products

• Clarity PPM On Premise

Issue/Introduction

We are getting an error message when attempting to access project audit data.
When filtering on the Audit Trail tab data we get 'ERROR - Contact System Administrator' error.

In the app-ca.log I see the following associated error:

Caused by: java.sql.SQLDataException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01722: invalid number
ORA-06512: at "NIKU.ODF_AUD_VALUE_FCT", line 26
ORA-06512: at line 1

Environment

Release : 15.9.1, 15.9.2

Component : CLARITY STUDIO

Cause

Cause of the issue is having two different datatypes with the same ID in the CMN_AUDITS table which is not allowed since based on the datatype the audit trail processing may vary.

Resolution

The error message indicates there are audited attributes with the same code but different data type.

To resolve this, you will have to remove one of them from being audited in the Project object.

To delete the attribute, you will need to remove it from being audited first. After deleting it when you access the Audit Trail Tab in the Project you won’t get any error.

The records for the attributes with the same code but with different type (string and lookup in this example) will remain in the CMN_AUDITS table until the Purge Audit Trail job is run and delete them based on the “Days after which audit records will be purged” value that is set.