CA PPM: System error is thrown, when user attempts to update a custom field in List Filter Section of a portlet that is based on an NSQL query if the NSQL query was modified.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

System error is thrown, when user attempts to update a custom field in List Filter Section of a portlet that is based on an NSQL query if the NSQL query was modified. After receiving this error, the affected attribute(s) cannot be moved from Available to Selected sections in the List Filter Layout. They move back to Available section after clicking on 'Save'.

Steps to Reproduce:

1.    Navigate to CA PPM Administration, and create a query, say 'my query', with simple NSQL like below:

SELECT
 @SELECT:DIM:USER_DEF:IMPLIED:DEPARTMENTS:d.id:[email protected],
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:d.DEPARTCODE:[email protected],
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:d.DESCRIPTION:[email protected]
FROM DEPARTMENTS d
WHERE 1 = 1
AND @[email protected]

2.    Create a grid portlet, say 'my portlet', using the above query as its data provider. You may leave the default configuration (list column layout, list filter section) as is.

3.    Now navigate to CA PPM Application side (Home), and add the above portlet to the Overview page on a new tab, say 'my tab'.

4.    On the displayed portlet, click on the 'Configure' button, and navigate to 'List Filter Section' --> Fields page and choose 'Display: All'

5.    Make some modification to any attribute, say 'id', by clicking on its Properties icon/button, and changing the Filter Label from id --> id1. Save.

6.    Now navigate back to CA PPM Administration, and open the 'Department' object and go to its Attributes page.

7.    Create 2 simple String attributes, say attr01 and attr02.

8.    Navigate to the query that we created in step 1 (my query), and update its NSQL as below:

SELECT
 @SELECT:DIM:USER_DEF:IMPLIED:DEPARTMENTS:d.id:[email protected],
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:d.DEPARTCODE:[email protected],
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:d.DESCRIPTION:[email protected],
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:ca.attr01:[email protected],
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:ca.attr02:[email protected]
FROM DEPARTMENTS d, odf_ca_DEPARTMENT ca
WHERE 1 = 1
AND d.id = ca.id
AND @[email protected]

9.    Now navigate back to CA PPM Application side (Home), and perform Step 4 and Step 5 for 'attr01' field.

10.    Perform Step 4 and Step 5 for 'attr02' field.

Expected Result: 
You should be able to modify any attribute in the 'List Filter Section'.

Actual Result: 
You receive a System Error when you modify any attribute in the 'List Filter Section'.

11.    On the portlet, click on the 'Configure' button, and navigate to 'List Filter Section Layout’ and  move 'attr01' and 'attr02' fields from Available to Selected sections. Click on 'Save'.

Expected Result: 
Attributes stay in the Selected section after clicking on 'Save'.

Actual Result: 
Attributes move back to Available section after clicking on 'Save'.
 

Environment

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

Cause

 

 

Caused by DE32451

Resolution

 

 

Defect is fixed in 15.3.