My Oracle Support Banner

After Upgrading the Primavera Gateway Deployment Fails With "Error Code: 904" (Doc ID 2536856.1)

Last updated on APRIL 30, 2019

Applies to:

Primavera Gateway - Version 18.8 and later
Information in this document applies to any platform.

Symptoms

When attempting to start the Primavera Gateway deployment after upgrading an existing Gateway database, the following error occurs.

ERROR
-----------------------
Error Code: 904
Call: SELECT APP_ID, CREATE_DATE, CREATE_USER, APP_DESC, EXTERNAL, APP_NAME, UPDATE_DATE, UPDATE_USER, APP_VERSION FROM APP WHERE (APP_ID = ?)
       bind => [1 parameter bound]
Query: ReadObjectQuery(name="app" referenceClass=AppEO )
       at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:388)
       at org.springframework.web.context.ContextLoader.loadParentContext(ContextLoader.java:563)
       at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:322)
       at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
       at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:705)
       Truncated. see log file for complete stacktrace
Caused By: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shared.context' defined in class path resource [META-INF/shared-context.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'm_externalRequestDAO': Unsatisfied dependency expressed through field 'jobPub'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jobPub' defined in class path resource [META-INF/services-context.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "EXTERNAL": invalid identifier

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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