java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to save repository element [C:\Pentaho\PDI\pdi_ee_4.4nightly920\pdi-ee\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\my_csvnoselect.ktr : my_csvnoselect] Unable to save step information to the repository for id_step=null at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:78) at org.pentaho.di.repository.pur.PurRepository.save (SourceFile:1737) at org.pentaho.di.repository.pur.PurRepository.saveTrans (SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.saveTrans0 (SourceFile:1917) at org.pentaho.di.repository.pur.i.a (SourceFile:525) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep (MonetDBBulkLoaderMeta.java:389) at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase (SourceFile:369)

Pentaho BI Platform Tracking | Golda David | 4 years ago
  1. 0

    1. Log into the EE repository 2.Open the \data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\csv.ktr file 3. Save it to the EE repository. You get an error dialog Unable to save repository element [C:\Pentaho\PDI\pdi_ee_4.4nightly920\pdi-ee\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\my_csvnoselect.ktr : my_csvnoselect] Unable to save step information to the repository for id_step=null with the following details java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to save repository element [C:\Pentaho\PDI\pdi_ee_4.4nightly920\pdi-ee\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\my_csvnoselect.ktr : my_csvnoselect] Unable to save step information to the repository for id_step=null at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:78) at org.pentaho.di.repository.pur.PurRepository.save (SourceFile:1737) at org.pentaho.di.repository.pur.PurRepository.saveTrans (SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.saveTrans0 (SourceFile:1917) at org.pentaho.di.repository.pur.i.a (SourceFile:525) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep (MonetDBBulkLoaderMeta.java:389) at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase (SourceFile:369) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:82) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleException: Unable to save repository element [C:\Pentaho\PDI\pdi_ee_4.4nightly920\pdi-ee\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\my_csvnoselect.ktr : my_csvnoselect] Unable to save step information to the repository for id_step=null at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:78) at org.pentaho.di.repository.pur.PurRepository.save (SourceFile:1737) at org.pentaho.di.repository.pur.PurRepository.saveTrans (SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.saveTrans0 (SourceFile:1917) at org.pentaho.di.repository.pur.i.a (SourceFile:525) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep (MonetDBBulkLoaderMeta.java:389) at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase (SourceFile:369) at org.pentaho.di.repository.pur.PurRepository.save(SourceFile:1759) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:78) ... 1 more Caused by: org.pentaho.di.core.exception.KettleException: Unable to save step information to the repository for id_step=null at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:78) at org.pentaho.di.repository.pur.PurRepository.save (SourceFile:1737) at org.pentaho.di.repository.pur.PurRepository.saveTrans (SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.saveTrans0 (SourceFile:1917) at org.pentaho.di.repository.pur.i.a (SourceFile:525) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep (MonetDBBulkLoaderMeta.java:389) at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase (SourceFile:369) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep(MonetDBBulkLoaderMeta.java:393) at org.pentaho.di.repository.pur.i.a(SourceFile:525) at org.pentaho.di.repository.pur.PurRepository.saveTrans0(SourceFile:1917) at org.pentaho.di.repository.pur.PurRepository.saveTrans(SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.save(SourceFile:1737) ... 2 more Caused by: java.lang.NullPointerException at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase(SourceFile:369) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep(MonetDBBulkLoaderMeta.java:389) ... 6 more

    Pentaho BI Platform Tracking | 4 years ago | Golda David
    java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to save repository element [C:\Pentaho\PDI\pdi_ee_4.4nightly920\pdi-ee\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\my_csvnoselect.ktr : my_csvnoselect] Unable to save step information to the repository for id_step=null at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:78) at org.pentaho.di.repository.pur.PurRepository.save (SourceFile:1737) at org.pentaho.di.repository.pur.PurRepository.saveTrans (SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.saveTrans0 (SourceFile:1917) at org.pentaho.di.repository.pur.i.a (SourceFile:525) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep (MonetDBBulkLoaderMeta.java:389) at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase (SourceFile:369)
  2. 0

    1. Log into the EE repository 2.Open the \data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\csv.ktr file 3. Save it to the EE repository. You get an error dialog Unable to save repository element [C:\Pentaho\PDI\pdi_ee_4.4nightly920\pdi-ee\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\my_csvnoselect.ktr : my_csvnoselect] Unable to save step information to the repository for id_step=null with the following details java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to save repository element [C:\Pentaho\PDI\pdi_ee_4.4nightly920\pdi-ee\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\my_csvnoselect.ktr : my_csvnoselect] Unable to save step information to the repository for id_step=null at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:78) at org.pentaho.di.repository.pur.PurRepository.save (SourceFile:1737) at org.pentaho.di.repository.pur.PurRepository.saveTrans (SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.saveTrans0 (SourceFile:1917) at org.pentaho.di.repository.pur.i.a (SourceFile:525) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep (MonetDBBulkLoaderMeta.java:389) at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase (SourceFile:369) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:82) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleException: Unable to save repository element [C:\Pentaho\PDI\pdi_ee_4.4nightly920\pdi-ee\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\my_csvnoselect.ktr : my_csvnoselect] Unable to save step information to the repository for id_step=null at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:78) at org.pentaho.di.repository.pur.PurRepository.save (SourceFile:1737) at org.pentaho.di.repository.pur.PurRepository.saveTrans (SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.saveTrans0 (SourceFile:1917) at org.pentaho.di.repository.pur.i.a (SourceFile:525) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep (MonetDBBulkLoaderMeta.java:389) at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase (SourceFile:369) at org.pentaho.di.repository.pur.PurRepository.save(SourceFile:1759) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:78) ... 1 more Caused by: org.pentaho.di.core.exception.KettleException: Unable to save step information to the repository for id_step=null at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:78) at org.pentaho.di.repository.pur.PurRepository.save (SourceFile:1737) at org.pentaho.di.repository.pur.PurRepository.saveTrans (SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.saveTrans0 (SourceFile:1917) at org.pentaho.di.repository.pur.i.a (SourceFile:525) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep (MonetDBBulkLoaderMeta.java:389) at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase (SourceFile:369) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep(MonetDBBulkLoaderMeta.java:393) at org.pentaho.di.repository.pur.i.a(SourceFile:525) at org.pentaho.di.repository.pur.PurRepository.saveTrans0(SourceFile:1917) at org.pentaho.di.repository.pur.PurRepository.saveTrans(SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.save(SourceFile:1737) ... 2 more Caused by: java.lang.NullPointerException at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase(SourceFile:369) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep(MonetDBBulkLoaderMeta.java:389) ... 6 more

    Pentaho BI Platform Tracking | 4 years ago | Golda David
    java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to save repository element [C:\Pentaho\PDI\pdi_ee_4.4nightly920\pdi-ee\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Local File\my_csvnoselect.ktr : my_csvnoselect] Unable to save step information to the repository for id_step=null at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:78) at org.pentaho.di.repository.pur.PurRepository.save (SourceFile:1737) at org.pentaho.di.repository.pur.PurRepository.saveTrans (SourceFile:1946) at org.pentaho.di.repository.pur.PurRepository.saveTrans0 (SourceFile:1917) at org.pentaho.di.repository.pur.i.a (SourceFile:525) at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep (MonetDBBulkLoaderMeta.java:389) at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase (SourceFile:369)
  3. 0

    Create a transformation with a table output step and give it a connection to a database. When you try to save the transformation you get the following error... java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to save step info to the repository for id_transformation=1 Unable to save step information to the repository for id_step=2 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:73) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:308) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation (KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta (KettleDatabaseRepositoryStepDelegate.java:179) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep (TableOutputMeta.java:582) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase (KettleDatabaseRepository.java:548) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:77) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleException: Unable to save step info to the repository for id_transformation=1 Unable to save step information to the repository for id_step=2 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:73) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:308) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation (KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta (KettleDatabaseRepositoryStepDelegate.java:179) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep (TableOutputMeta.java:582) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase (KettleDatabaseRepository.java:548) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta(KettleDatabaseRepositoryStepDelegate.java:187) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation(KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:308) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:73) ... 1 more Caused by: org.pentaho.di.core.exception.KettleException: Unable to save step information to the repository for id_step=2 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:73) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:308) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation (KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta (KettleDatabaseRepositoryStepDelegate.java:179) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep (TableOutputMeta.java:582) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase (KettleDatabaseRepository.java:548) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep(TableOutputMeta.java:587) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta(KettleDatabaseRepositoryStepDelegate.java:179) ... 5 more Caused by: java.lang.NullPointerException at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase(KettleDatabaseRepository.java:548) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep(TableOutputMeta.java:582) ... 6 more

    Pentaho BI Platform Tracking | 6 years ago | Rob Fellows
    java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to save step info to the repository for id_transformation=1 Unable to save step information to the repository for id_step=2 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:73) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:308) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation (KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta (KettleDatabaseRepositoryStepDelegate.java:179) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep (TableOutputMeta.java:582) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase (KettleDatabaseRepository.java:548)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Create a transformation with a table output step and give it a connection to a database. When you try to save the transformation you get the following error... java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to save step info to the repository for id_transformation=1 Unable to save step information to the repository for id_step=2 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:73) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:308) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation (KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta (KettleDatabaseRepositoryStepDelegate.java:179) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep (TableOutputMeta.java:582) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase (KettleDatabaseRepository.java:548) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:77) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleException: Unable to save step info to the repository for id_transformation=1 Unable to save step information to the repository for id_step=2 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:73) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:308) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation (KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta (KettleDatabaseRepositoryStepDelegate.java:179) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep (TableOutputMeta.java:582) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase (KettleDatabaseRepository.java:548) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta(KettleDatabaseRepositoryStepDelegate.java:187) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation(KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:308) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:73) ... 1 more Caused by: org.pentaho.di.core.exception.KettleException: Unable to save step information to the repository for id_step=2 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:73) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:308) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation (KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta (KettleDatabaseRepositoryStepDelegate.java:179) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep (TableOutputMeta.java:582) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase (KettleDatabaseRepository.java:548) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep(TableOutputMeta.java:587) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta(KettleDatabaseRepositoryStepDelegate.java:179) ... 5 more Caused by: java.lang.NullPointerException at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase(KettleDatabaseRepository.java:548) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep(TableOutputMeta.java:582) ... 6 more

    Pentaho BI Platform Tracking | 6 years ago | Rob Fellows
    java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to save step info to the repository for id_transformation=1 Unable to save step information to the repository for id_step=2 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:73) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:308) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save (KettleDatabaseRepository.java:327) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation (KettleDatabaseRepositoryTransDelegate.java:207) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta (KettleDatabaseRepositoryStepDelegate.java:179) at org.pentaho.di.trans.steps.tableoutput.TableOutputMeta.saveRep (TableOutputMeta.java:582) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.insertStepDatabase (KettleDatabaseRepository.java:548)
  6. 0

    A collegue designed a job with three "Evaluate Table" operators in it. Most of the time we have problems saving this job. It has also been broken in the repository a few times. We get the following error: Unable to load job entry of type Evaluate table content to the repository for id_job=27 Error inserting/updating row DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;DBDW101.R_STEP_ATTRIBUTE, DRIVER=3.51.90 Details: java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to load job entry of type Evaluate table content to the repository for id_job=27 Error inserting/updating row DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;DBDW101.R_STEP_ATTRIBUTE, DRIVER=3.51.90 at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:72) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleException: Unable to load job entry of type Evaluate table content to the repository for id_job=27 Error inserting/updating row DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;DBDW101.R_STEP_ATTRIBUTE, DRIVER=3.51.90 at org.pentaho.di.job.entries.evaluatetablecontent.JobEntryEvalTableContent.saveRep(JobEntryEvalTableContent.java:284) at org.pentaho.di.job.entry.JobEntryCopy.saveRep(JobEntryCopy.java:234) at org.pentaho.di.job.JobMeta.saveRep(JobMeta.java:1239) at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:68) ... 1 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error inserting/updating row DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;DBDW101.R_STEP_ATTRIBUTE, DRIVER=3.51.90 at org.pentaho.di.core.database.Database.insertRow(Database.java:1325) at org.pentaho.di.core.database.Database.insertRow(Database.java:1239) at org.pentaho.di.repository.Repository.insertStepAttribute(Repository.java:1697) at org.pentaho.di.repository.Repository.saveStepAttribute(Repository.java:3240) at org.pentaho.di.repository.Repository.saveStepAttribute(Repository.java:3209) at org.pentaho.di.job.entries.evaluatetablecontent.JobEntryEvalTableContent.saveRep(JobEntryEvalTableContent.java:271) ... 4 more Caused by: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;DBDW101.R_STEP_ATTRIBUTE, DRIVER=3.51.90 at com.ibm.db2.jcc.a.wc.a(wc.java:588) at com.ibm.db2.jcc.a.wc.a(wc.java:60) at com.ibm.db2.jcc.a.wc.a(wc.java:127) at com.ibm.db2.jcc.a.fl.b(fl.java:1599) at com.ibm.db2.jcc.a.fl.c(fl.java:1582) at com.ibm.db2.jcc.t4.db.k(db.java:353) at com.ibm.db2.jcc.t4.db.a(db.java:59) at com.ibm.db2.jcc.t4.t.a(t.java:50) at com.ibm.db2.jcc.t4.tb.b(tb.java:200) at com.ibm.db2.jcc.a.gl.Kb(gl.java:2365) at com.ibm.db2.jcc.a.gl.e(gl.java:3143) at com.ibm.db2.jcc.a.gl.Db(gl.java:572) at com.ibm.db2.jcc.a.gl.executeUpdate(gl.java:555) at org.pentaho.di.core.database.Database.insertRow(Database.java:1274) ... 9 more

    Pentaho BI Platform Tracking | 7 years ago | Holger Hymmen
    java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException: Unable to load job entry of type Evaluate table content to the repository for id_job=27 Error inserting/updating row DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;DBDW101.R_STEP_ATTRIBUTE, DRIVER=3.51.90

    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.lang.NullPointerException

      No message provided

      at org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase()
    2. org.pentaho.di
      SaveProgressDialog$1.run
      1. org.pentaho.di.repository.pur.RepositoryProxy.insertStepDatabase(SourceFile:369)
      2. org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.saveRep(MonetDBBulkLoaderMeta.java:389)
      3. org.pentaho.di.repository.pur.i.a(SourceFile:525)
      4. org.pentaho.di.repository.pur.PurRepository.saveTrans0(SourceFile:1917)
      5. org.pentaho.di.repository.pur.PurRepository.saveTrans(SourceFile:1946)
      6. org.pentaho.di.repository.pur.PurRepository.save(SourceFile:1737)
      7. org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:78)
      7 frames
    3. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame