java.sql.SQLSyntaxErrorException: ORA-00904: "TENANT_ID": invalid identifier Error Code: 904 Call: SELECT CASE_ID, CONTAINER_ID, DUMMY1, MSG_ID, COMPONENT_DN, OPERATION, CREATION_DATE, PRIORITY, COMPONENT_STATUS, QNAME_LOCAL_PART, CASE_INFO, QNAME_NAMESPACE, LOCK_TIME, SOURCE_URI, TENANT_ID, INSTANCE_CREATED, IS_EVENT, STATUS FROM MEDIATOR_DEFERRED_MESSAGE WHERE (((STATUS = ?) AND (LOCK_TIME = ?)) AND (CONTAINER_ID = ?)) bind => [1, 2013-07-16 17:23:12.814, A8424220EE5D11E2BF9C6D1C72885086] Query: ReadAllQuery(oracle.tip.mediator.common.persistence.MediatorDeferredMessage)

Oracle Community | 1007055 | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Admin server running into issues in SOA.

    Oracle Community | 4 years ago | 1007055
    java.sql.SQLSyntaxErrorException: ORA-00904: "TENANT_ID": invalid identifier Error Code: 904 Call: SELECT CASE_ID, CONTAINER_ID, DUMMY1, MSG_ID, COMPONENT_DN, OPERATION, CREATION_DATE, PRIORITY, COMPONENT_STATUS, QNAME_LOCAL_PART, CASE_INFO, QNAME_NAMESPACE, LOCK_TIME, SOURCE_URI, TENANT_ID, INSTANCE_CREATED, IS_EVENT, STATUS FROM MEDIATOR_DEFERRED_MESSAGE WHERE (((STATUS = ?) AND (LOCK_TIME = ?)) AND (CONTAINER_ID = ?)) bind => [1, 2013-07-16 17:23:12.814, A8424220EE5D11E2BF9C6D1C72885086] Query: ReadAllQuery(oracle.tip.mediator.common.persistence.MediatorDeferredMessage)
  2. 0

    Issues while starting soa_server1

    Oracle Community | 7 years ago | 737342
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: SELECT DRIVER_NAME, MIME_TYPES, PROTOCOLS, CARRIERS, SENDER_ADDRESSES, COST, DELIVERY_TYPES, SPEED, STATUS_TYPES, CHECKSUM, SUPPORTS_CANCEL, ENCODINGS, SUPPORTS_REPLACE, SUPPORTS_TRACKING, SUPPORTS_STATUS_POLLING, DEFAULT_SENDER, CAPABILITY, LOCK_VERSION FROM DRIVER_INFO Query: ReadAllQuery(oracle.sdpinternal.messaging.config.DriverInfo)
  3. 0

    Error retrieving instance details from soa-infra runtime

    Oracle Community | 5 years ago | 937917
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: SELECT GUID FROM VERSION Query: DataReadQuery()
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-00904: "TENANT_ID": invalid identifier Error Code: 904 Call: SELECT CASE_ID, CONTAINER_ID, DUMMY1, MSG_ID, COMPONENT_DN, OPERATION, CREATION_DATE, PRIORITY, COMPONENT_STATUS, QNAME_LOCAL_PART, CASE_INFO, QNAME_NAMESPACE, LOCK_TIME, SOURCE_URI, TENANT_ID, INSTANCE_CREATED, IS_EVENT, STATUS FROM MEDIATOR_DEFERRED_MESSAGE WHERE (((STATUS = ?) AND (LOCK_TIME = ?)) AND (CONTAINER_ID = ?)) bind => [1, 2013-07-16 17:23:12.814, A8424220EE5D11E2BF9C6D1C72885086] Query: ReadAllQuery(oracle.tip.mediator.common.persistence.MediatorDeferredMessage)

      at oracle.toplink.exceptions.DatabaseException.sqlException()
    2. oracle.toplink.exceptions
      DatabaseException.sqlException
      1. oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
      1 frame
    3. oracle.toplink.internal
      DatabaseAccessor.executeCall
      1. oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:614)
      2. oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:468)
      2 frames
    4. oracle.toplink.threetier
      ServerSession.executeCall
      1. oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:447)
      1 frame
    5. oracle.toplink.internal
      ExpressionQueryMechanism.selectAllRows
      1. oracle.toplink.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:117)
      2. oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
      3. oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:179)
      4. oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:250)
      5. oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:583)
      6. oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2500)
      7. oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2458)
      7 frames
    6. oracle.toplink.queryframework
      ReadAllQuery.execute
      1. oracle.toplink.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:467)
      2. oracle.toplink.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:874)
      3. oracle.toplink.queryframework.DatabaseQuery.execute(DatabaseQuery.java:679)
      4. oracle.toplink.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:835)
      5. oracle.toplink.queryframework.ReadAllQuery.execute(ReadAllQuery.java:445)
      5 frames
    7. oracle.toplink.internal
      AbstractSession.executeQuery
      1. oracle.toplink.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2265)
      2. oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1079)
      3. oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1063)
      4. oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1037)
      5. oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1009)
      5 frames
    8. oracle.tip.mediator
      DBLocker.run
      1. oracle.tip.mediator.dispatch.db.DBAccess.getMessageFromDB(DBAccess.java:800)
      2. oracle.tip.mediator.dispatch.db.DBAccess.getDeferredMessages(DBAccess.java:821)
      3. oracle.tip.mediator.dispatch.db.DeferredDBLocker.getLockedMessages(DeferredDBLocker.java:153)
      4. oracle.tip.mediator.common.listener.DBLocker.getLockedMessages(DBLocker.java:173)
      5. oracle.tip.mediator.common.listener.DBLocker.run(DBLocker.java:93)
      5 frames
    9. oracle.integration.platform
      WorkManagerExecutor$1.run
      1. oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:120)
      1 frame
    10. weblogic.work.j2ee
      J2EEWorkManager$WorkWithListener.run
      1. weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
      1 frame
    11. weblogic.work
      DaemonWorkThread.run
      1. weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
      1 frame