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

Oracle Community | user8744020 | 1 year ago
  1. 0

    list of filesnames not read by variable in odi

    Stack Overflow | 1 year ago | user5297374
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. 0

    Error  while export data from a xml file to an relational table

    Oracle Community | 5 years ago | Papai
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Getting ODI-1227 error when running ODI for the first time

    Oracle Community | 3 years ago | 2612850
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  5. 0

    ODI-1519 error while running ETL Loads from ODI

    Oracle Community | 2 years ago | 959186
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
    13 frames
  3. org.identityconnectors.dbum
    DBUMConnector.executeQuery
    1. org.identityconnectors.dbum.SQLExecutionHandler.searchAccounts(SQLExecutionHandler.java:287)
    2. org.identityconnectors.dbum.SQLExecutionHandler.executeAccountSearch(SQLExecutionHandler.java:95)
    3. org.identityconnectors.dbum.DBUMConnector.executeQuery(DBUMConnector.java:199)
    4. org.identityconnectors.dbum.DBUMConnector.executeQuery(DBUMConnector.java:74)
    4 frames
  4. org.identityconnectors.framework
    SearchImpl.search
    1. org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:118)
    2. org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:82)
    2 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor5776.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  6. org.identityconnectors.framework
    ConnectorAPIOperationRunnerProxy.invoke
    1. org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:93)
    1 frame
  7. com.sun.proxy
    $Proxy575.search
    1. com.sun.proxy.$Proxy575.search(Unknown Source)
    1 frame
  8. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor5776.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  9. org.identityconnectors.framework
    ThreadClassLoaderManagerProxy.invoke
    1. org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:107)
    1 frame
  10. com.sun.proxy
    $Proxy575.search
    1. com.sun.proxy.$Proxy575.search(Unknown Source)
    1 frame
  11. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor5776.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  12. org.identityconnectors.framework
    BufferedResultsProxy$BufferedResultsHandler.run
    1. org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:162)
    1 frame