Clarity: Team Object Power Filter Error

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Description:

From Project List View, users are trying to build a power filter by selecting the Team Object and using any field on this object. When they do this it is generating an Error Message such as "Contact system administrator" error or "Error: Sorting by the column specified is not allowed" and not allowing the power filter to be executed successfully.

Unable to use previously saved v12 power filters that use Team (sub object). This is the exact same power filter that was saved in the environment as v12prior to upgrade.

When application log (app-ca.log) is checked it provides the following error message:

FOR MICROSOFT SQL SERVER:

ERROR 2013-11-08 17:21:32,058 [http-bio-1310-exec-2] niku.odf (clarity:admin:5036018__EBA5F3DE-A277-457E-8BFA-08322191A4C9:odf.viewSubmitExpression) com.niku.union.persistence.PersistenceException:
SQL error code: 4104
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The multi-part identifier "SRM_RESOURCES.MANAGER_ID" could not be bound.
SQL error code: 4104
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The multi-part identifier "SRM_RESOURCES.MANAGER_ID" could not be bound.
SQL error code: 1011
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The correlation name 'RES_MANAGER' is specified multiple times in a FROM clause.
SQL error code: 8180
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
Executed:
select count(*) as obj_count from (select 'x' pmd_analytical_partition_by, prteam.prid odf_pk, prteam.RSF_OBSUNIT_ID rsf_obsunit_id, [snip]
...
Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]The multi-part identifier "SRM_RESOURCES.MANAGER_ID" could not be bound.

FOR ORACLE:

ERROR 2013-11-15 14:15:23,924 [http-bio-14001-exec-5393] union.persistence (clarity:admin:12987348__A381DC92-8FA8-4161-980B-8452D7A8D51B:mainnav.work)
java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "SRM_RESOURCES"."MANAGER_ID": invalid identifier

Steps to Reproduce:

1. Login to Clarity as a Project Manager
   
   
2. Navigate to Home, Projects List View
   
   
3. In the Filter Section, click [Build Power Filter] link
   
   Left: Object = 'Team (Subobject)'
   Field = 'Resource' although you can select anything to replicate issue
   Operator = '=' (equal symbol)
   Right = select any value from browse dialog window
   
   
4. Click 'Add' button to add the expression
   
   
5. Click 'Save and Return' button
   
   
6. Page is returned to list view with error at top of page

Expected Result: The power filter is applied to the list

Actual Result: Error: Sorting by the column specified is not allowed

 

Environment

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component:

Resolution

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

Resolved in Clarity 13.1.0 Generic Patch TEC581256
Resolved in Clarity 13.2.0 Generic Patch TEC599354
Resolved in Clarity 13.3

Keywords: CLARITYKB, CLRT-71678, clarity13resolved, clarity133resolved.