Audit trail tab for the projects is throwing System Error

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

SUMMARY: Some audited attributes cause a System error on audit trail tab of project

STEPS TO REPRODUCE: 
1- Administration > Objects > project
2- Audit Trail
3- Add these attributes 
status_indicator
status
obj_work_status
inv_work_package
4- Save and Return

Expected Results: Audit trail displays as expected

Actual Results: Audit Trail throws a System Error

Environment

Release : 16.0.0, 16.0.1 

Component : CLARITY STUDIO

Cause

Reported Issue #: DE63809

Workaround: 

The workaround will not remove old Audit data. These fields will not be audited at this time.

Remove the attributes listed above by running this SQL: 

delete from odf_audited_attributes oaa
where object_code ilike 'project'
AND (attribute_code ilike 'status_indicator'
OR attribute_code ILIKE 'inv_work_package'
OR attribute_code ILIKE 'obj_work_status'
OR attribute_code ILIKE 'status'
);

Resolution

Resolved in 16.0.2 as part of the resolution for DE64154. 

 

Additional Information

For more details on DE64154, Reference: Deletion of custom object causing Audit Trail "System Error"