Generic System Error Thrown Trying to Import a Bundle to Production: ORA-00942: table or view does not exist (Doc ID 2160199.1)

Last updated on JULY 12, 2016

Applies to:

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

Symptoms

In Primavera Unifier version 16.1.2.2

The following Unifier Notification is thrown when trying to import a Bundle into Production:

ERROR
-----------------------
"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 is an excerpt written to the Unifier log files: /shell/subshell/log/search throws an exception at /shell/action.xml:2462: ~
/shell/action.xml:2462: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to production environment
2. Navigation, trying to access configuration, try changing projects, try accessing tasks
3. receive error. *This is happening to all users and does not seem to affect Staging.

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