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

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


Article ID: 188361


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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.

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


  • 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


  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