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

Oracle Community | 3035834 | 1 year ago
  1. 0

    Facing Missing IN or OUT parameter at index:: 78 issue

    Oracle Community | 1 year ago | 3035834
    java.sql.SQLException: Missing IN or OUT parameter at index:: 78
  2. 0

    The following error is thrown, when a "Table Output" element is trying to insert data into a table on Oracle 12c. 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Because of an error, this step can't continue: 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleException: 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error inserting row into table [STAGED_ELEMENTS] with values: [19], [1], [305], [LTE], [CONTROLLER], [305], [2012/07/01 00:00:00.000], [null], [null], [null], [null] 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error inserting/updating row 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : operation not allowed: operation cannot be mixed with Oracle-style batching 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:445) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at java.lang.Thread.run(Thread.java:662) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error inserting/updating row 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : operation not allowed: operation cannot be mixed with Oracle-style batching 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.insertRow(Database.java:1411) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:284) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : ... 3 more 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: java.sql.SQLException: operation not allowed: operation cannot be mixed with Oracle-style batching 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at oracle.jdbc.driver.OraclePreparedStatement.setJdbcBatchStyle(OraclePreparedStatement.java:10733) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:10826) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at oracle.jdbc.driver.OraclePreparedStatementWrapper.addBatch(OraclePreparedStatementWrapper.java:1369) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.insertRow(Database.java:1355) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : ... 4 more

    Pentaho BI Platform Tracking | 3 years ago | Babak Tourani
    org.pentaho.di.core.exception.KettleException: Error inserting row into table [STAGED_ELEMENTS] with values: [19], [1], [305], [LTE], [CONTROLLER], [305], [2012/07/01 00:00:00.000], [null], [null], [null], [null] Error inserting/updating row operation not allowed: operation cannot be mixed with Oracle-style batching
  3. 0

    The following error is thrown, when a "Table Output" element is trying to insert data into a table on Oracle 12c. 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Because of an error, this step can't continue: 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleException: 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error inserting row into table [STAGED_ELEMENTS] with values: [19], [1], [305], [LTE], [CONTROLLER], [305], [2012/07/01 00:00:00.000], [null], [null], [null], [null] 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error inserting/updating row 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : operation not allowed: operation cannot be mixed with Oracle-style batching 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:445) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at java.lang.Thread.run(Thread.java:662) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error inserting/updating row 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : operation not allowed: operation cannot be mixed with Oracle-style batching 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.insertRow(Database.java:1411) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:284) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : ... 3 more 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: java.sql.SQLException: operation not allowed: operation cannot be mixed with Oracle-style batching 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at oracle.jdbc.driver.OraclePreparedStatement.setJdbcBatchStyle(OraclePreparedStatement.java:10733) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:10826) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at oracle.jdbc.driver.OraclePreparedStatementWrapper.addBatch(OraclePreparedStatementWrapper.java:1369) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.insertRow(Database.java:1355) 05.c - Insert into StgElts.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : ... 4 more

    Pentaho BI Platform Tracking | 3 years ago | Babak Tourani
    org.pentaho.di.core.exception.KettleException: Error inserting row into table [STAGED_ELEMENTS] with values: [19], [1], [305], [LTE], [CONTROLLER], [305], [2012/07/01 00:00:00.000], [null], [null], [null], [null] Error inserting/updating row operation not allowed: operation cannot be mixed with Oracle-style batching
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JPA Calling an Oracle function with OUT parameter

    objectmix.com | 1 year ago
    java.sql.SQLException: Missing IN or OUT parameter at index:: 9

    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:: 78

      at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.addBatch
      1. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1937)
      2. oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:12963)
      3. oracle.jdbc.driver.OraclePreparedStatementWrapper.addBatch(OraclePreparedStatementWrapper.java:1521)
      3 frames
    3. oracle.odi.runtime
      DataMovementTaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:42)
      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.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:87)
      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:577)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)
      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:1073)
      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