My Oracle Support Banner

"java.sql.SQLSyntaxErrorException: ORA-904: "TENANT_ID": invalid identifier" after Upgrade from 11.1.1.5 to 11.1.1.6 (Doc ID 1532151.1)

Last updated on AUGUST 01, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 and later
Information in this document applies to any platform.
***Checked for relevance on 28-July-2014***

Symptoms

The following error occured after the upgrade from 11.1.1.5 to 11.1.1.6.

DBLocker caught exception while retrieving locked messages. Will retry retrieval after 2 seconds Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: ORA-904: "TENANT_ID": invalid identifier

Error Code: 904
Call: SELECT t1.ID, t1.SHORT_EXCEPTION_MSG, t1.PROPERTIES, t1.RECOVERABLE, t1.EXCEPTION_TYPE, t1.CREATED_TIME, t1.CALLBACK_OPERATION, t1.CONTAINER_ID, t1.TARGET_ACTION_NAME, t1.FAULT_OBJ, t1.TARGET_REFERENCE, t1.STEP, t1.TARGET_TYPE, t1.RETRY_INTERVAL, t1.CASE_NAME, t1.EXCEPTION_MSG, t1.SYSTEM, t1.LOCK_TIME, t1.CONVERSATION_ID, t1.FAULT_NAME, t1.DEF_MESSAGE_ID, t1.EXCEPTION_TRACE, t1.INSTANCE_ID, t1.STATUS, t1.TENANT_ID, t1.MI_PARTITION_DATE, t1.RETRY_COUNT, t1.SOURCE_URI, t0.CASE_ID, t0.CONTAINER_ID, t0.DUMMY1, t0.MSG_ID, t0.COMPONENT_DN, t0.OPERATION, t0.CREATION_DATE, t0.PRIORITY, t0.COMPONENT_STATUS, t0.QNAME_LOCAL_PART, t0.CASE_INFO, t0.QNAME_NAMESPACE, t0.LOCK_TIME, t0.SOURCE_URI, t0.TENANT_ID, t0.INSTANCE_CREATED, t0.IS_EVENT, t0.STATUS FROM MEDIATOR_DEFERRED_MESSAGE t0, MEDIATOR_CASE_INSTANCE t1 WHERE ((((t1.STATUS = ?) AND (t1.LOCK_TIME = ?)) AND (t1.CONTAINER_ID = ?)) AND (t0.CASE_ID = t1.DEF_MESSAGE_ID))
  bind => [locked, 2013-02-24 15:50:48.347, 7175FC707E9911E2BFB60DF4BBE6AC85]
Query: ReadAllQuery(oracle.tip.mediator.instance.toplink.MediatorCaseInstance)
  at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
  at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:614)
  at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:468)
  at oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:447)
  at oracle.toplink.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:117)
  at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
  at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:179)
  at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:250)
  at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:583)
  at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2500)
  at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2458)
  at oracle.toplink.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:467)
  at oracle.toplink.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:874)
  at oracle.toplink.queryframework.DatabaseQuery.execute(DatabaseQuery.java:679)
  at oracle.toplink.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:835)
  at oracle.toplink.queryframework.ReadAllQuery.execute(ReadAllQuery.java:445)
  at oracle.toplink.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2265)
  at oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1079)
  at oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1063)
  at oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1037)
  at oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1009)
  at oracle.tip.mediator.common.error.ErrorDBLocker.getLockedMessages(ErrorDBLocker.java:111)
  at oracle.tip.mediator.common.listener.DBLocker.getLockedMessages(DBLocker.java:146)
  at oracle.tip.mediator.common.listener.DBLocker.run(DBLocker.java:81)
  at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:120)
  at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
  at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "T0"."TENANT_ID": invalid identifier

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

Changes

 SOA was upgraded from 11.1.1.5 to 11.1.1.6.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.