java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist[[*

Oracle Community | 962121 | 4 years ago
  1. 0

    Error while provisioning a user to EBS UM

    Oracle Community | 4 years ago | 962121
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist[[*
  2. 0

    in indices() function gives 'ORA-01722: invalid number' error

    Stack Overflow | 2 years ago | user3181365
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    hibernate.cfg.xml file error

    Stack Overflow | 1 year ago | user2517370
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  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)

  1. rafafviola 1 times, last 1 month ago
  2. wendellpereira 128 times, last 2 months ago
  3. balintn 4 times, last 2 months ago
  4. balintn 3 times, last 3 months ago
  5. pnaranja 2 times, last 4 months ago
1 more registered users
30 unregistered visitors
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-00942: table or view does not exist[[*

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
    11. oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:6629)
    12. oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:13502)
    13. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3767)
    14. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
    15. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
    15 frames
  3. oracle.iam.connectors
    EBSUserManagement.createUser
    1. oracle.iam.connectors.ebs.usermgmt.integration.EBSUserManagementHelper.isEmployeeExist(Unknown Source)
    2. oracle.iam.connectors.ebs.usermgmt.integration.EBSUserManagement.createUser(Unknown Source)
    2 frames
  4. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  5. com.thortech.xl
    tcOIU.eventPostInsert
    1. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpEBSCREATEUSER.CREATEUSER(adpEBSCREATEUSER.java:218)
    2. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpEBSCREATEUSER.implementation(adpEBSCREATEUSER.java:96)
    3. com.thortech.xl.client.events.tcBaseEvent.run(tcBaseEvent.java:196)
    4. com.thortech.xl.dataobj.tcDataObj.runEvent(tcDataObj.java:2492)
    5. com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(tcScheduleItem.java:3179)
    6. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(tcScheduleItem.java:752)
    7. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
    8. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
    9. com.thortech.xl.dataobj.tcORC.insertNonConditionalMilestones(tcORC.java:847)
    10. com.thortech.xl.dataobj.tcORC.completeSystemValidationMilestone(tcORC.java:1162)
    11. com.thortech.xl.dataobj.tcOrderItemInfo.completeCarrierBaseMilestone(tcOrderItemInfo.java:744)
    12. com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(tcOrderItemInfo.java:173)
    13. com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:235)
    14. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
    15. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
    16. com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2910)
    17. com.thortech.xl.dataobj.tcORC.autoDOBSave(tcORC.java:3008)
    18. com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(tcOrderPackages.java:471)
    19. com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(tcOrderPackages.java:180)
    20. com.thortech.xl.dataobj.tcOIU.provision(tcOIU.java:637)
    21. com.thortech.xl.dataobj.tcOIU.eventPostInsert(tcOIU.java:357)
    21 frames