Error 'SQLSyntaxErrorException: ORA-00942: Table or View Does Not Exist' When Navigating to a Business Process Log After Importing a Production Bundle

(Doc ID 2359014.1)

Last updated on FEBRUARY 26, 2018

Applies to:

Primavera Unifier - Version 16.1.0.0 and later
Primavera Unifier Cloud Service - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

After importing a Production Bundle from a Staging/Development environment into a Production environment, a generic system error is thrown when navigating to a Business Process Log.

The Business Process experiencing the issue is an existing BP in Production. During the bundle creation, a dependent BP design was not included and the Reference Process details are not coming up as a result.

ERROR
-----------------------
Error seen in the Unifier User Interface:
"The system could not process your request..."

Error seen in the Unifier.log File:
'SQLSyntaxErrorException: ORA-00942: table or view does not exist'

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