Dynamic multivalue lookup returns API error in new UX

Products

• Clarity PPM On Premise

Issue/Introduction

Dynamic multi-value lookup value selection in new UI/modern UX returns error CMN-0009: Attribute 'Attribute name' has invalid Lookup Value '[xxxx]'

Another side affect of this defect is if you are able to update MVL via XOG or in Classic but when going to the List in MUX you will see multiple values because of wild character search. See screenshot below.

 

STEPS TO REPRODUCE:

1. Create custom lookup (name: SPP Prvky, id: C_L_SPP_PRVKY) from query

SELECT  @SELECT:RESOURCES.ID:[email protected],

        @SELECT:RESOURCES.FULL_NAME:[email protected],

        @SELECT:RESOURCES.LAST_NAME:[email protected],

        @SELECT:RESOURCES.FIRST_NAME:[email protected],

        @SELECT:RESOURCES.UNIQUE_NAME:[email protected],

        @SELECT:RESOURCES.UNIQUE_NAME:[email protected],

        @SELECT:RESOURCES.LAST_UPDATED_DATE:[email protected]

FROM    SRM_RESOURCES RESOURCES              

WHERE   @[email protected] 

AND     case when resources.user_id is null then 0 else resources.user_id end != -99            

AND     RESOURCES.RESOURCE_TYPE = 3

2. Create custom attribute on object Project

Attribute name: SPP Prvky

ID: c_prj_spp

API attribute ID: c_prj_spp

3. Create custom lookup (name: SPP Prvky Task, id: C_L_SPP_TASK) from query

SELECT @SELECT:RESOURCES.ID:[email protected],

        @SELECT:RESOURCES.FULL_NAME:[email protected],

        @SELECT:RESOURCES.LAST_NAME:[email protected],

        @SELECT:RESOURCES.FIRST_NAME:[email protected],

        @SELECT:RESOURCES.UNIQUE_NAME:[email protected],

        @SELECT:RESOURCES.UNIQUE_NAME:[email protected],

        @SELECT:RESOURCES.LAST_UPDATED_DATE:[email protected]

from ODF_MULTI_VALUED_LOOKUPS mv

left join PRTASK tsk on tsk.PRPROJECTID = mv.PK_ID

left join SRM_RESOURCES RESOURCES on RESOURCES.ID = mv.VALUE

where mv.OBJECT = 'project' and mv.attribute = 'c_prj_spp'

and (tsk.PRPROJECTID = @WHERE:PARAM:USER_DEF:INTEGER:[email protected] or @WHERE:PARAM:USER_DEF:INTEGER:[email protected] is null)

4. Create custom attribute on object Task

1. 1. Name: SPP Prvky
   2. Id: c_tsk_spp_prvky
   3. Data type: Multi Valued Lookup
   4. Map parameter prj_id to prprojectid

 

5. Add custom project attribute to detail module in New UX and try to select multiple values

6. Add custom task attribute to the task detail view and try to select a subset of the values selected in the previous step

 

Expected result: Task lookup value saved selected to be saved

 

Actual result: Task lookup value select not saved, error message in browser console

CMN-0009: Attribute 'attribute name' has invalid Lookup Value '[xxxxx]'

Browser trace:

{resourceId: "5006001", httpStatus: "400",…}

1. errorCode: "lookupValueInvalid"
2. errorMessage: "CMN-0009: Attribute 'SPP Prvky' has invalid Lookup Value '[5005083]'"
3. httpStatus: "400"
4. resourceId: "5006001"

Response:

{"resourceId":"5006001","httpStatus":"400","errorMessage":"CMN-0009: Attribute 'SPP Prvky' has invalid Lookup Value '[5005083]'","errorCode":"validation.lookupValueInvalid"}

 

Cause

This is caused by clarity PPM defect DE58124

Environment

Clarity PPM 15.8.1, 15.9, 15.9.1, 15.9.2

Resolution

DE58124, Fixed in 16.0