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

Article Id: 4471

Status: Published

Updated On: 14-02-2018 08:19

Legacy Id: TEC1162723

Products:

CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM

Issue/Introduction:

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.

Cause:

Caused by CLRT-79696

Environment:

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

Resolution:

Currently being reviewed