java.sql.SQLSyntaxErrorException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Admin server running into issues in SOA.
    via by 1007055,
  • Catalog search operations give ADF error
    via by Federator,
  • VO EXTENSION IN OAF R12.2.3
    via by Syed Abdul Wahab,
  • Error when i want to create a Resource
    via by Cedric.Catalyst,
  • EDQ integration with QAS
    via by Oliver Lockett,
    • java.sql.SQLSyntaxErrorException: ORA-00904: "TENANT_ID": invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135) at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:814) at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:540) 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)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    79 more bugmates