Clarity: Team Object Power Filter Error

Document ID : KB000019270
Last Modified Date : 14/02/2018
Show Technical Document Details

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

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.