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
Cause of issue is having two different datatypes with same ID in the CMN_AUDITS table and this not allowed since based on the datatype the audit trail processing may vary.
Release : 15.9.1, 15.9.2
Component : CLARITY STUDIO
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.