In 16.1.3, the Allocations by Investment and Assignments by Investment timeline sections do not display data, regardless of filters and permissions.
- Connect to Allocations by Investment - remove all filters in the top portlet
- 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