Clarity PPM - Resources not visible in Resource List view
search cancel

Clarity PPM - Resources not visible in Resource List view


Article ID: 144916


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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.


Latest Version: 15.7.1


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:
<Description>This record has not been inserted</Description>
<![CDATA[SQL Exception with error code : 1422]]>

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


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.