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 | 3 years ago
  1. 0

    Admin server running into issues in SOA.

    Oracle Community | 3 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 | 4 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

  5. 0

    DB setup in OTM

    Oracle Community | 4 years ago | 925395
    java.sql.SQLSyntaxErrorException: ORA-00904: "T1"."OS_TYPE": invalid identifier Error Code: 904 Call: SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id)) bind => [eMEWorkstation, 1] Query: ReadAllQuery(name="WorkstationDb.queryWorkstationsByType" referenceClass=WorkstationDb sql="SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))")
  6. 0

    Admin server running into issues in SOA.

    Oracle Community | 3 years ago | 1007055
    java.sql.SQLSyntaxErrorException: ORA-00904: "TENANT_ID": invalid identifier

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    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