java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch [Microsoft][ODBC Microsoft Access Driver]String data, right truncated (null)

pentaho.com | 3 months ago
  1. 0

    Unable to save!!! [Archive] - Pentaho Community Forums

    pentaho.com | 3 months ago
    java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch [Microsoft][ODBC Microsoft Access Driver]String data, right truncated (null)
  2. 0

    Batch Insert in Java - JDBC Batch Insert Query using JDBC

    viralpatel.net | 4 months ago
    sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ‘)’.
  3. 0

    ODI error: Executing Interface

    Oracle Community | 7 years ago | Varun Kaushal
    sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC Excel Driver] Operation must use an updateable query.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error in loading data from Oracle 10g to Excel

    Oracle Community | 4 years ago | 954808
    sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC Excel Driver] Operation must use an updateable query.
  6. 0

    Update exception

    Oracle Community | 8 years ago | 630556
    sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC Microsoft Access Dr iver] Too few parameters. Expected 7.

    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. sun.jdbc.odbc.JdbcOdbcBatchUpdateException

      [Microsoft][ODBC Microsoft Access Driver]String data, right truncated (null)

      at sun.jdbc.odbc.JdbcOdbcPreparedStatement.emulateExecuteBatch()
    2. sun.jdbc.odbc
      JdbcOdbcStatement.executeBatch
      1. sun.jdbc.odbc.JdbcOdbcPreparedStatement.emulateExecuteBatch(Unknown Source)
      2. sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeBatchUpdate(Unknown Source)
      3. sun.jdbc.odbc.JdbcOdbcStatement.executeBatch(Unknown Source)
      3 frames
    3. org.pentaho.di
      SaveProgressDialog$1.run
      1. org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1376)
      2. org.pentaho.di.repository.Repository.closeStepAttributeInsertPreparedStatement(Repository.java:3245)
      3. org.pentaho.di.trans.TransMeta.saveRep(TransMeta.java:1888)
      4. org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:68)
      4 frames
    4. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame