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.

Document ID:  TEC1455645
Last Modified Date:  06/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA PPM

Releases

  • CA PPM:Release:14.2
  • CA PPM:Release:14.2 On Demand
  • CA PPM:Release:14.1
  • CA PPM:Release:14.1 On Demand
  • CA PPM:Release:14.3
  • CA PPM:Release:14.3 On Demand
  • CA PPM:Release:15.1

Components

  • CA PPM SAAS STUDIO INTERNAL ONLY:ODSTU
  • CA PPM STUDIOINTERNAL ONLY:PPMSTU
Problem:

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:id@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:d.DEPARTCODE:DEPARTCODE@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:d.DESCRIPTION:DESCRIPTION@
FROM DEPARTMENTS d
WHERE 1 = 1
AND @FILTER@

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:id@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:d.DEPARTCODE:DEPARTCODE@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:d.DESCRIPTION:DESCRIPTION@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:ca.attr01:attr01@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:DEPARTMENTS:ca.attr02:attr02@
FROM DEPARTMENTS d, odf_ca_DEPARTMENT ca
WHERE 1 = 1
AND d.id = ca.id
AND @FILTER@

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'.

Cause:

Caused by DE32451

Resolution:

Defect is fixed in 15.3.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing