Getting a System Error when bringing up a project thru project list

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

I have a project where after filtering for the project and clicking on the link, I get a "ERRORSystem error. Contact system administrator." error.

Errors in the app-ca.logs that may be displayed:

ERROR 2020-04-07 15:53:50,142 [http-nio-8080-exec-1] property.PropertyViewLoader (clarity:userID:.....odata.GetListContextByRow) Exception locating views for object project of subtype update in the database.
java.lang.NullPointerException

ERROR 2020-04-07 13:08:40,434 [http-nio-8080-exec-3] niku.xql2 (clarity:userID:.....:projmgr.projectProperties) ServiceHandler.postProcess failed.
java.lang.NullPointerException

Cause

• This issue can happen if there are one or more null values for a multi select lookup in the database
• To identify if this is the cause, run the below query:

SELECT * from odf_multi_valued_lookups
where object = 'project' and value is null and pk_id=<id of the project you can not open>
From the result you can get the attribute ID that has the issue

Resolution

1. Clear out the values in the attribute with the issue on the project list page
2. Save changes
3. Then repopulate the values in the lookup and save again

If the above doesn't resolve the issue please contact Broadcom support for assistance