Generic System Error Thrown Trying to Import a Bundle to Production: ORA-00942: table or view does not exist
Last updated on JULY 12, 2016
Applies to:Primavera Unifier Cloud Service - Version 18.104.22.168 to 22.214.171.124 [Release 16.1]
Primavera Unifier - Version 126.96.36.199 to 188.8.131.52 [Release 16.1]
Information in this document applies to any platform.
In Primavera Unifier version 184.108.40.206
The following Unifier Notification is thrown when trying to import a Bundle into Production:
"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
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.
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