Error " java.sql.SQLSyntaxErrorException: ORA-00904: 'bpID_BP STATUS': invalid identifier" on BP Record After Importing a Configuration Package

(Doc ID 2336082.1)

Last updated on JANUARY 17, 2018

Applies to:

Primavera Unifier - Version 16.2.0.0 to 16.2.0.0 [Release 16.2]
Primavera Unifier Cloud Service - Version 16.2.0.0 to 16.2.0.0 [Release 16.2]
Information in this document applies to any platform.

Symptoms

After importing a Configuration Package from Staging into Production, a generic system error is displayed when attempting to create a new BP Record or access the SOV from within the Record.

The impacted Business Process has not been modified as part of the Configuration Package.

ERROR
-----------------------
The following error is seen in the UI:

"The system could not process your request. Logging in again may help in some cases. Contact your System Administrator if you are still having problems"

The following error is seen in the Unifier.log:

java.sql.SQLSyntaxErrorException: ORA-00904: 'bpID_BP STATUS': invalid identifier


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Log In as Company Administrator.
2) Navigate to a project 
3) Open the Business Process Record > Click on the SOV button and the Alert message above is seen.
4) Creating a new BP record also results in the same Alert message.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms