search cancel

Resource Finder portlet displays no items when a 'Multi Valued lookup - number' attribute is added to the selected column


Article ID: 4471


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


If you create an attribute of type 'Multi Valued Lookup - Number' on the Resource object and add it to the Selected Columns of the Resource Finder portlet, you will get the following error in the app-ca.log and no entries are shown in the portlet list regardless of the filtering:

Caused by:java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "ODF_CA_RESOURCE"."Z_MULTI_VALUED_ATTR".invalid identifier.

Steps to Reproduce:

1. Create a 'Multi Valued Lookup - Number' in the Resource object.

2. Navigate to 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.  Click the Save and Return button.

Expected Result: Data in the Resource Finder portlet displayed including the newly created attribute.

Actual Result: No data displayed in the Resource Finder portlet.


Release: 451-101-15.1-Clarity-Creator User License


Caused by CLRT-79696


Currently being reviewed