MUX Staffing modules are blank or never load
search cancel

MUX Staffing modules are blank or never load

book

Article ID: 369244

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

MUX Staffing is not accessible, users not able to access Staffing modules

STEPS TO REPRODUCE:

1. Work in Staffing module (specifically Allocation by Investment and Allocation by Resource tabs

Expected Results: Staffing module to work well

Actual Results: The pages do not load, blank pages with only tabs names are shown


Errors in logs:

 2024-04-23T19:38:28.500Z ERROR 2024-04-23 12:38:28,500 [http-nio-8082-exec-771] ppm.rest (clarity:XXXXXXX:60215821__A74BFAE4-F187-49BA-AA02-7BAD2123146B:PPM_REST_API) (5205974e-9fab-4d0b-b10d-52b2da0a9f60) ODataODFObjectAdapter :: Exception occurred while retrieving resources. ODF object code alias: obaStaffs

2024-04-23T19:38:28.500Z ERROR 2024-04-23 12:38:28,500 [http-nio-8082-exec-771] ppm.rest (clarity:XXXXXXXX:60215821__A74BFAE4-F187-49BA-AA02-7BAD2123146B:PPM_REST_API) (5205974e-9fab-4d0b-b10d-52b2da0a9f60)
java.lang.NullPointerException
at com.ca.ppm.rest.adapter.RestQueryParser.buildConvertedFilterString(RestQueryParser.java:617)
at com.ca.ppm.rest.adapter.RestQueryParser.parseFilter(RestQueryParser.java:244)
at com.ca.ppm.rest.adapter.RestQueryParser.parseFilters(RestQueryParser.java:202)

 

2024-04-23T16:27:16.448Z ERROR 2024-04-23 09:27:16,448 [http-nio-8082-exec-753] odata.EntitiesResponseImpl (clarity:YYYYYYYYYYYYY:60248389__77058B26-6ABE-45CA-85ED-9B7E20D34ECA:PPM_REST_API) (47559cb7-f14e-4585-a45f-26c285433813) Exception reading objects: oba_staff
com.niku.union.persistence.PersistenceException:
SQL error code: 1722
Error message: ORA-01722: invalid number

Also API-1019 errors and error 500 in HAR file which corresponds to NullPointerExceptions on obaStaffs

Resolution

Workaround: Flush Caches

Engineering reviewed the issue and it will be addressed as a part of a user story in 16.2.3. 

  • Add defensive coding and add/improve logging for cache operations

We improved the areas that could be causing mismatches and also added enhanced logging.