java.sql.SQLSyntaxErrorException: ORA-00904: "UD_OID_USR_KEY": invalid identifier

Oracle Community | Srivatsa.kashyap | 6 years ago
  1. 0

    OID target reconciliation error

    Oracle Community | 6 years ago | Srivatsa.kashyap
    java.sql.SQLSyntaxErrorException: ORA-00904: "UD_OID_USR_KEY": invalid identifier
  2. 0

    Webcenter tutorial bug

    Oracle Community | 7 years ago | 665981
    com.bea.p13n.jobmanager.exception.JobManagerRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: a tabela ou view não existe
  3. 0

    Reg : Unable to connect to JDBC Store

    Oracle Community | 5 years ago | 917343
    java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    EDQ integration with QAS

    Oracle Community | 1 year ago | Oliver Lockett
    com.datanomic.director.runtime.data.RecordReadException: Unable to read from staged data "OpenFin.oa_anlysis". (Code: 203,200)
  6. 0

    Application against Oracle or Postgres in Weblogic, Sequence Fails

    Stack Overflow | 1 year ago | Kumar
    java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
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: "UD_OID_USR_KEY": invalid identifier

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1188)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3430)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    13 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
    1 frame
  4. com.thortech.xl
    ReconMessageHandlerMDB.onMessage
    1. com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(Unknown Source)
    2. com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(Unknown Source)
    3. com.thortech.xl.dataobj.PreparedStatementUtil.execute(Unknown Source)
    4. com.thortech.xl.dataobj.util.tcReconciliationUtil.matchChildTableData(Unknown Source)
    5. com.thortech.xl.dataobj.util.tcReconciliationUtil.matchChildTableData(Unknown Source)
    6. com.thortech.xl.dataobj.util.tcReconciliationUtil.getProcessMatches(Unknown Source)
    7. com.thortech.xl.dataobj.util.tcReconciliationUtil.evaluateEvent(Unknown Source)
    8. com.thortech.xl.dataobj.tcRCE.checkDataSorted(Unknown Source)
    9. com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
    10. com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
    11. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    12. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    13. com.thortech.xl.dataobj.tcRCE.finishDataReceived(Unknown Source)
    14. com.thortech.xl.schedule.jms.reconOffline.ProcessOfflineReconMessages.finishReconciliationEvent(Unknown Source)
    15. com.thortech.xl.schedule.jms.reconOffline.ProcessOfflineReconMessages.execute(Unknown Source)
    16. com.thortech.xl.schedule.jms.messagehandler.MessageProcessUtil.processMessage(Unknown Source)
    17. com.thortech.xl.schedule.jms.messagehandler.ReconMessageHandlerMDB.onMessage(Unknown Source)
    17 frames
  5. weblogic.ejb.container
    MDListener.onMessage
    1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
    2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
    3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
    3 frames
  6. weblogic.jms.client
    JMSSession$UseForRunnable.run
    1. weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
    2. weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
    3. weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
    4. weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
    5. weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
    5 frames
  7. weblogic.work
    ExecuteThread.run
    1. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
    2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    3. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    3 frames