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

Pentaho BI Platform Tracking | Babak Tourani | 3 years ago
  1. 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
  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

    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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Not able to create space in jtrac 2.1.0

    j-trac | 3 years ago | varda14
    org.hibernate.exception.GenericJDBCException: could not insert: [info.jtrac.domain.Metadata]
  6. 0

    Hibernate exception - Java Programming Help - KnowCoding.com

    knowcoding.com | 1 year ago
    org.hibernate.exception.GenericJDBCException: could not insert: [user.Product]

    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

      operation not allowed: operation cannot be mixed with Oracle-style batching

      at oracle.jdbc.driver.OraclePreparedStatement.setJdbcBatchStyle()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.addBatch
      1. oracle.jdbc.driver.OraclePreparedStatement.setJdbcBatchStyle(OraclePreparedStatement.java:10733)
      2. oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:10826)
      3. oracle.jdbc.driver.OraclePreparedStatementWrapper.addBatch(OraclePreparedStatementWrapper.java:1369)
      3 frames
    3. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.database.Database.insertRow(Database.java:1355)
      2. org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:284)
      3. org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128)
      4. org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      4 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame