My Oracle Support Banner

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 SEPTEMBER 05, 2019

Applies to:

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


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 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'


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.