ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

"ODF_AUD_VALUE_FCT" line 26 error generated by Audit tab


Article ID: 222026


Updated On:


Clarity PPM On Premise


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 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.


Release : 15.9.1, 15.9.2



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.