Clarity PPM - Resources not visible in Resource List view

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

An issue was noticed where Resources that were imported from an integration with a third-party application, were present in the Database, but were not visible in the Resource List View (Home -> Resources). These same resources were however noticed to be visible from Admin -> Resources.

Environment

Latest Version: 15.7.1

Cause

The integration responsible for importing Resources into Clarity PPM, was using the application's XOG functionality to import records into the application. On further troubleshooting it was noticed that the XOG Writes that were being done were failing with the following error message:

<ErrorInformation>

<Severity>FATAL</Severity>

<Description>This record has not been inserted</Description>

<Exception>

<![CDATA[SQL Exception with error code : 1422]]>

</Exception>

</ErrorInformation>

Looking into the app-ca.log, the following errors were noticed:

SQL error code: 1422

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422:exact fetch returns more than requested number of rows

ORA-06512: at "NIKU.ODF_AUD_5002724_FCT", line 5

ORA-06512: at "NIKU.T_RESOURCE_OODF_CA_RESOURCE", line 227

ORA-04088: error during execution of trigger 'NIKU.T_RESOURCE_OODF_CA_RESOURCE'

It was discovered that there were dynamic lookup based attributes in the Resource object that were being audited, that were causing duplicates in their corresponding audit functions.

As a result of the XOG Write's failure to properly import Resource records into the system, these records were not available in the Resource List View.

Resolution

Remove dynamic lookup based attributes from the audit trail, and retry the XOG Write.

Please note that, although in this specific case, the Resource records were affected, the same can affect any other object instance types as well.