CA PPM: Task Object Power Filter Error: 'Sorting by the column specified is not allowed'

Document ID : KB000045084
Last Modified Date : 10/08/2018
Show Technical Document Details
Introduction:

Problem:

Portlet based on Task Object using a power filter as default for Project object shows Error 'Sorting by the column specified is not allowed'.

Steps to Reproduce:

1. Create a Grid ported based on Task Object.
Add some columns in the List Column Layout.
Add some fields in the List Filter Layout. Check 'Allow Power Filter'
Put the portlet in any page
2. Navigate to the page where you put the portlet
3. Click on [Build Power Filter]
Select:
Object=Project (master Object)
Field= Progress
Operator =
Value 'Started'
Click Add
Click Save and Return
Click Filter
Notice that Portlet returns rows correctly
4. Click on Save Filter.
Enter Filter Name 'myfilter'
Check 'Default'
Click Save and Return
Click Filter
Notice that Portlet returns rows correctly
5. Click Clear. Click Filter. Select the Filter 'myfilter'
Notice that Portlet returns rows correctly

6. Logout. Log back in. Navigate to the Page. Check the Portlet.

 

Expected Result:  

Portlet should show correct results based on filter 

Actual Result:  

Portlet shows Error 'Sorting by the column specified is not allowed.' and ‘There are no items to display’

 

Additional Information:

app log shows:

ERROR 2016-03-03 16:23:00,107 [http-nio-80-exec-941] union.persistence (clarity:admin:5615072__225721DD-73BB-42A1-B682-6625A991E0CB:5017000)

java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "EXPR_PROJECT"."PROGRESS": invalid identifier

at

 

Cause:

Caused by CLRT-79956

Resolution:

Open. 

 

 

Instructions:
Please Update This Required Field