Staffing Workspace - Investments Tabs Not Displaying Data
search cancel

Staffing Workspace - Investments Tabs Not Displaying Data

book

Article ID: 274124

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

In 16.1.3, the Allocations by Investment and Assignments by Investment timeline sections do not display data, regardless of filters and permissions.  

  1. Connect to Allocations by Investment - remove all filters in the top portlet
  2. Now go to Assignments by Investment and remove all filters in the top portlet

Expected Results: The records to display

Actual Results: No results / blank

Error messages in logs:

  • ERROR 2023-09-14 08:32:00,311 [http-nio-8080-exec-485] association.OBAUtils (clarity:xxxxxxx:13810450__1957B263-5809-4072-8C10-CA4EBFA190A6:PPM_REST_API) (f7f489b9-00a8-4005-a4f5-579082957988) Error encountered while processing dynamic security. Security could not be verified.
    java.lang.NullPointerException
        at com.ca.ppm.object.association.OBAUtils.preProcessInvestmentCodesForRightCheck(OBAUtils.java:828)
        at com.ca.ppm.object.association.OBAUtils.getOBAInvestmentViewInstanceRightCheckSQL(OBAUtils.java:465)
        at com.ca.clarity.projmgr.security.OBAStaffSecurityDelegate.getViewInstanceSQL(OBAStaffSecurityDelegate.java:164)
        at com.ca.clarity.projmgr.security.OBAStaffSecurityDelegate.getViewInstanceSQLForStatement(OBAStaffSecurityDelegate.java:231)
        at com.ca.clarity.projmgr.rest.provider.OBAStaffResourceProvider.getDynamicSecurityParameters(OBAStaffResourceProvider.java:137)
        at com.ca.platform.osf.object.rest.provider.OBABaseResourceProvider.getDynamicParamsForInstance(OBABaseResourceProvider.java:247)
        at com.ca.platform.osf.object.rest.provider.ODFResourceProvider.getResources(ODFResourceProvider.java:1526)
        at com.ca.platform.osf.object.rest.provider.ODFResourceProvider.getEntities(ODFResourceProvider.java:220)
  • ERROR 2023-09-14 10:14:45,393 [http-nio-8080-exec-514] union.persistence (clarity:xxxxxxxxxx:13810450__1957B263-5809-4072-8C10-CA4EBFA190A6:PPM_REST_API) (c3fe0ecd-ddd6-467e-8c38-14118e7aff6e) Exception on odf-pmd.inv.select-list-rest-api-conditional.map statement null
    org.postgresql.util.PSQLException: ERROR: invalid reference to FROM-clause entry for table "prteam"
      Hint: There is an entry for table "prteam", but it cannot be referenced from this part of the query.
      Position: 5607
  • ERROR 2023-09-14 10:14:45,393 [http-nio-8080-exec-514] odata.EntitiesResponseImpl (clarity:dddddddddd:13810450__1957B263-5809-4072-8C10-CA4EBFA190A6:PPM_REST_API) (c3fe0ecd-ddd6-467e-8c38-14118e7aff6e) Exception reading objects: invcom.niku.union.persistence.PersistenceApplicationException                   
  • at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2464)                   
  • at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3788)                   
  • at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:932)
  • ERROR 2023-09-14 08:32:00,347 [http-nio-8080-exec-485] union.persistence (clarity:xxxxxxxxx13810450__1957B263-5809-4072-8C10-CA4EBFA190A6:PPM_REST_API) (f7f489b9-00a8-4005-a4f5-579082957988) Exception on odf-pmd.inv.select-list-rest-api-conditional.map statement nullorg.postgresql.util.PSQLException: ERROR: syntax error at or near "AND"  Position: 11535

Environment

Release : 16.1.3

Cause

Cache corruption

Resolution

  • Perform a full services restart to fix the issue
  • Clearing cache will not typically work