A required Multi-valued lookup with a numeric key and a parameter throws a System Error when no value is selected

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Issue

When creating a required MVL that uses a lookup with a numeric key and has a parameter throws a "System error. Contact system administrator. All required fields need to be filled out.".

Steps to Reproduce

 

1. Create a dynamic lookup
2. The key field in the query has to be numeric
3. The query has to contain a parameter
example code:

select
@select:ID:[email protected],
@select:full_name:[email protected]
from srm_resources r
where @[email protected]
and @WHERE:PARAM:USER_DEF:INTEGER:[email protected] <> 0

4. Add this lookup to an MVL attribute
5. The attribute has to be required
6. Once the attribute has been created, make sure that the Object's attribute "Lookup Parameter Mappings" has a mapping (in the example below, associate "test" with "Object ID" or "code"...)
7. Add this attribute into an object. Make sure that the Create view includes the required attribute.
8. Create a new instance of the object. Do not select any value for the MVL.

 

Expected result: "All required fields need to be filled out." is displayed highlighting the MVL field. The rest of the information is not lost.

Actual result: "System error. Contact system administrator. All required fields need to be filled out.". The current data is lost.

 

Cause

This is caused by CLRT-80227.

 

Solution

This issue has been resolved as of CA PPM 14.4 Patch 4 and 15.1.

 

Workaround

If the key is not Numeric but a String, the issue does not appear.

 

Show »

1* Create a dynamic lookup 2* The key field in the query has to be numeric 3* The query has to contain a parameter example code: select @select:ID:[email protected], @select:full_name:[email protected] from srm_resources r where @[email protected] and @WHERE:PARAM:USER_DEF:INTEGER:[email protected] <> 0 4* Add this lookup to an MVL attribute 5* The attribute has to be required 6* Once the attribute has been created, make sure that the Object's attribute "Lookup Parameter Mappings" has a mapping (in the example below, associate "test" with "Object ID" or "code"...) 7* Add this attribute into an object. Make sure that the Create view includes the required attribute. 8* Create a new instance of the object. Do not select any value for the MVL.

Environment

Release:
Component: STUDIO