"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)

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

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