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

Oracle Community | 2814059 | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Mapping issue !

    Oracle Community | 2 years ago | 2814059
    java.sql.BatchUpdateException: ORA-00942: table or view does not exist
  2. 0

    ODI Inserting to C$ filter is failing while running interface using package and load plan

    Oracle Community | 2 years ago | user12866742
    java.sql.BatchUpdateException: ORA-00942: table or view does not exist
  3. 0

    Update non-existent table - crash ORA-00942

    Stack Overflow | 6 years ago | Ten_of_a_Kind
    java.sql.BatchUpdateException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate Oracle Create table

    Stack Overflow | 2 years ago | Gercek Ad
    org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
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.BatchUpdateException

    ORA-00942: table or view does not exist

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch()
  2. Oracle jdbc
    OracleStatementWrapper.executeBatch
    1. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:15709)
    2. oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:264)
    2 frames
  3. oracle.odi.runtime
    TaskExecutorAgentRequestProcessor$1.doAction
    1. oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.executeBatch(BatchSQLCommand.java:110)
    2. oracle.odi.runtime.agent.execution.sql.SQLCommand.end(SQLCommand.java:323)
    3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:233)
    4. oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:28)
    5. oracle.odi.runtime.agent.execution.Executor.performAction(Executor.java:473)
    6. oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:334)
    7. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)
    8. oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:189)
    9. oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111)
    10. oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:864)
    11. oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2024)
    12. oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562)
    13. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
    14. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
    14 frames
  4. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
    1 frame
  5. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
    5 frames
  6. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame