java.sql.SQLSyntaxErrorException: ORA-00926: missing VALUES keyword

Oracle Community | hammer | 2 years ago
  1. 0

    Error during Mapping execution after changing the order of Datasets

    Oracle Community | 2 years ago | hammer
    java.sql.SQLSyntaxErrorException: ORA-00926: missing VALUES keyword
  2. 0

    ODI-1228: Task INT-EXP-FF-ORC (Integration) fails on the target ORACLE conn

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

    Error delete previous check sum

    Oracle Community | 5 years ago | 883344
    java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODI - Moving source files of ODI from different server to ODI server.

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

    ODI error java.sql.SQLSyntaxErrorException: ORA-01918

    Oracle Community | 5 years ago | 894341
    java.sql.SQLSyntaxErrorException: ORA-01918: user 'STGMGR' 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-00926: missing VALUES keyword

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1079)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
    12 frames
  3. oracle.odi.runtime
    TaskExecutionHandler.handleTask
    1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
    2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
    3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
    4. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
    4 frames
  4. com.sunopsis.dwg
    SnpSession.treatSession
    1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2906)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:537)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740)
    5 frames
  5. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:338)
    1 frame
  6. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
    1 frame
  7. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:272)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:263)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:822)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    5 frames
  8. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame