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
Workaround: Flush Caches
Engineering reviewed the issue and it will be addressed as a part of a user story in 16.2.3.
We improved the areas that could be causing mismatches and also added enhanced logging.