java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Oracle Community | bb55232c-70b5-467b-aaec-a4eab129d656 | 2 years ago
  1. 0

    ODI Sequences error after deplopment: Missing IN or OUT parameter at index:: 1

    Oracle Community | 2 years ago | bb55232c-70b5-467b-aaec-a4eab129d656
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  2. 0

    ODI Load Plan in BI APPS 11.1.1.7.1

    Oracle Community | 3 years ago | user11156570
    java.sql.SQLException: ORA-20000: Error creating Index/Constraint : W_EMPLOYEE_DS_U1 => ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found ORA-06512: at line 213at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  3. 0

    ORA-01653: unable to extend table DW.W_ITEM_COST_G by 128 in tablespace DW_DATA

    Oracle Community | 2 years ago | 1020987
    java.sql.SQLException: ORA-01653: unable to extend table DW.W_ITEM_COST_G by 128 in tablespace DW_DATA
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle Technical Information

    blogspot.com | 3 months ago
    java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942: ORA-06512: at line 49
  6. 0

    Failed Data Load - SIL

    Oracle Community | 5 months ago | Edwin-ACE
    java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942: ORA-06512: at line 49at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

  1. balintn 11 times, last 2 months ago
  2. Cafecanudo 2 times, last 3 months ago
18 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.SQLException

    Missing IN or OUT parameter at index:: 1

    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
    2. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
    3. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
    4. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
    4 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:2913)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
    6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)
    6 frames
  5. oracle.odi.runtime
    StartScenRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
    1 frame
  6. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    1 frame
  7. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
    2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)
    3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    4 frames
  8. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame