ODF_AUD_VALUE_FCT" line 26 error generated by Audit tab

book

Article ID: 222026

calendar_today

Updated On:

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

Cause

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.

Environment

Release : 15.9.1, 15.9.2

Component : CLARITY STUDIO

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.