search cancel

Resource Finder portlet displays no data when an MVL added to list view


Article ID: 229138


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


The Resource Finder portlet stops working when a Multi-Value Lookup is added to the list view. Once the field is added the portlet shows "There are no items to display" even is Show All is clicked.


  1. Create a Multi-Valued Lookup in the Resource object
  2. Navigate to Clarity Home > Resource Management > Resource Finder portlet
  3. Click on the Options icon > Configure > List Column Layout and add the attribute created in step one to the 'Selected Columns' section
  4. Click on 'Save And Return' button.

Expected Results: Data to be displayed along with the MVL lookup

Actual Results: Portlet shows: There are no items to display

This same behavior is also reproducible on the Project > Team tab if you use the Resource Finder magnifying glass


This is caused by DE28376/CLRT-74058


After a careful review to the affected area it was decided the defect will not be fixed due to its complexity

Workaround: Do not add Multi-Value lookup fields to the resource Finder portlet list view. If added, please remove it so the portlet works fine again

Additional Information

app-ca.log file shows the following error:

ERROR 2021-11-24 23:37:19,995 [http-nio-1593-exec-353] niku.union (clarity:admin:5588095__77A797B4-1F47-4CB8-97CF-750EBC6DBD9A:resource.resourceFinderSearch) Unable retrieve resource finder list
SQL error code: 904
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "SRM_RESOURCES"."MVL": invalid identifier