search cancel

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

book

Article ID: 188361

calendar_today

Updated On:

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

Environment

Release : 15.6

Component : CA PPM PROJECT MANAGEMENT

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

Additional Information

See KB 141061 - How to search for known Clarity PPM Issues using Self Service