java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch Character to numeric conversion error

pentaho.com | 6 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Error saving to repository [Archive] - Pentaho Community Forums

    pentaho.com | 6 months ago
    java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch Character to numeric conversion error

    Root Cause Analysis

    1. java.sql.BatchUpdateException

      Character to numeric conversion error

      at com.informix.jdbc.IfxPreparedStatement.executeBatch()
    2. com.informix.jdbc
      IfxPreparedStatement.executeBatch
      1. com.informix.jdbc.IfxPreparedStatement.executeBatch(IfxPreparedStatement.java:3410)
      1 frame
    3. org.pentaho.di
      SaveProgressDialog$1.run
      1. org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1372)
      2. org.pentaho.di.repository.Repository.closeStepAttributeInsertPreparedStatement(Repository.java:3243)
      3. org.pentaho.di.trans.TransMeta.saveRep(TransMeta.java:1886)
      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