Error 500 when opening a project after upgrade

book

Article ID: 197956

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

We get the error 500 when I try to open any project after upgrading:

In the logs we see the following:

ERROR 2020-08-24 13:15:26,319 [http-nio-13940-exec-1] niku.xql2 (clarity:admin:442342174__FB2F9403-2BC9-412B-B5E5-2332F9375E02:projmgr.projectProperties) Internal Processing exception

java.lang.Exception: Invalid expression qobj: com.niku.union.persistence.PersistenceException:

SQL error code: 904

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "ODF_CA_PROJECT"."TEST_FIELD": invalid identifier

Environment

Release : Any

Component : CA PPM PROJECT MANAGEMENT

Resolution

This seems to be a custom field on Project object called TEST_FIELD that's no longer there in the view. 

Go to Objects - Project - Attributes.
If the field is not there:

1. Recreate the TEST_FIELD attribute looking from another environment

2. Add it to the Edit views

3. Now try accessing the project again.
If the field is there:

1. Remove the field from Layout - Edit Views for Projects

2. Try opening the projects again

Attachments