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)

Solutions on the web1370

  • via Oracle Community by 1007055, 11 months ago
    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
  • via Oracle Community by 787651, 1 year ago
    ORA-00942: table or view does not exist Error Code: 942 Call: update MEDIATOR_CASE_INSTANCE set STATUS ='locked', LOCK_TIME =?, CONTAINER_ID =? where STATUS = 'ready' and rownum < ? bind => [2010-07-26 18:11:21.953, 7B8FCFE198B111DFBFEE53AED0E9F621, 10] Query: DataModifyQuery()
  • via Oracle Community by palaneandavar, 11 months ago
    ORA-00904: "CONTEXTVAL": invalid identifier Error Code: 904 Call: INSERT INTO ORCHPROCESS (ID, BULKPARENTID, CHANGETYPE, CONTEXTVAL, CREATEDON, ENTITYID, ENTITYTYPE, MODIFIEDON, OPERATION, ORCHESTRATION, ORCHTARGET, PARENTPROCESSID, RETRY, SEQUENCE
  • Stack trace

    • 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(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.dispatch.db.DBAccess.getMessageFromDB(DBAccess.java:800) at oracle.tip.mediator.dispatch.db.DBAccess.getDeferredMessages(DBAccess.java:821) at oracle.tip.mediator.dispatch.db.DeferredDBLocker.getLockedMessages(DeferredDBLocker.java:153) at oracle.tip.mediator.common.listener.DBLocker.getLockedMessages(DBLocker.java:173) at oracle.tip.mediator.common.listener.DBLocker.run(DBLocker.java:93) 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.