org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated

Pentaho BI Platform Tracking | Markus Printz | 4 years ago
  1. 0

    Importing into a database repository (Oracle 11gR2) from a single xml file takes up to an hour (<100 jobs and transformations) and occasionally crashes. Observation is identical if started through kitchen or via xaction file from BI server. Independent job and transformation files are used to run the import, both files are attached. Here's an extract of the output in case of a crash (project dependent names are masked: [[..]]): INFO 21-05 11:45:41,535 - Repository import - Saving file [[transformation name]] INFO 21-05 11:45:41,535 - Repository import - Handling old version of transformation (if any)... ERROR 21-05 11:45:43,321 - [[repository name]] - Error saving transformation to repository! Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated INFO 21-05 11:45:43,322 - Repository import - Could not save transformation #2 as "[[transformation name]]": org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation(KettleDatabaseRepositoryTransDelegate.java:307) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:334) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:315) at org.pentaho.di.repository.RepositoryImporter.importTransformation(RepositoryImporter.java:491) at org.pentaho.di.repository.RepositoryImporter.transformationElementRead(RepositoryImporter.java:597) at org.pentaho.di.repository.RepositoryExportSaxParser.endElement(RepositoryExportSaxParser.java:86) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:277) at org.pentaho.di.repository.RepositoryExportSaxParser.parse(RepositoryExportSaxParser.java:58) at org.pentaho.di.repository.RepositoryImporter.importAll(RepositoryImporter.java:100) at Processor.processRow(Processor.java:84) at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1182) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40) at java.lang.Thread.run(Thread.java:662) Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated

    Pentaho BI Platform Tracking | 4 years ago | Markus Printz
    org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated
  2. 0

    Importing into a database repository (Oracle 11gR2) from a single xml file takes up to an hour (<100 jobs and transformations) and occasionally crashes. Observation is identical if started through kitchen or via xaction file from BI server. Independent job and transformation files are used to run the import, both files are attached. Here's an extract of the output in case of a crash (project dependent names are masked: [[..]]): INFO 21-05 11:45:41,535 - Repository import - Saving file [[transformation name]] INFO 21-05 11:45:41,535 - Repository import - Handling old version of transformation (if any)... ERROR 21-05 11:45:43,321 - [[repository name]] - Error saving transformation to repository! Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated INFO 21-05 11:45:43,322 - Repository import - Could not save transformation #2 as "[[transformation name]]": org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation(KettleDatabaseRepositoryTransDelegate.java:307) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:334) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:315) at org.pentaho.di.repository.RepositoryImporter.importTransformation(RepositoryImporter.java:491) at org.pentaho.di.repository.RepositoryImporter.transformationElementRead(RepositoryImporter.java:597) at org.pentaho.di.repository.RepositoryExportSaxParser.endElement(RepositoryExportSaxParser.java:86) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:277) at org.pentaho.di.repository.RepositoryExportSaxParser.parse(RepositoryExportSaxParser.java:58) at org.pentaho.di.repository.RepositoryImporter.importAll(RepositoryImporter.java:100) at Processor.processRow(Processor.java:84) at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1182) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40) at java.lang.Thread.run(Thread.java:662) Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated

    Pentaho BI Platform Tracking | 4 years ago | Markus Printz
    org.pentaho.di.core.exception.KettleException: Error saving transformation to repository! Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated
  3. 0

    tested in trunk: java.lang.reflect.InvocationTargetException: Error loading transformation at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:81) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:89) at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFile(Spoon.java:5679) at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFile(Spoon.java:5651) at org.pentaho.di.ui.spoon.Spoon.lastFileSelect(Spoon.java:1278) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:44) at org.pentaho.xul.swt.menu.MenuBar.handleMenuEvent(MenuBar.java:52) at org.pentaho.xul.swt.menu.Menu.handleMenuEvent(Menu.java:117) at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77) at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:945) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412) Caused by: org.pentaho.di.core.exception.KettleException: An error occured reading a transformation from the repository Unable to set partition schema for name [PartitionSchema], method: Mod partitioner This is the list of available partition schema: at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2609) at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2442) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:77) ... 23 more Caused by: org.pentaho.di.core.exception.KettleException: Unable to set partition schema for name [PartitionSchema], method: Mod partitioner This is the list of available partition schema:

    Pentaho BI Platform Tracking | 8 years ago | Jens Bleuel
    java.lang.reflect.InvocationTargetException: Error loading transformation
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    tested in trunk: java.lang.reflect.InvocationTargetException: Error loading transformation at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:81) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:89) at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFile(Spoon.java:5679) at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFile(Spoon.java:5651) at org.pentaho.di.ui.spoon.Spoon.lastFileSelect(Spoon.java:1278) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:44) at org.pentaho.xul.swt.menu.MenuBar.handleMenuEvent(MenuBar.java:52) at org.pentaho.xul.swt.menu.Menu.handleMenuEvent(Menu.java:117) at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77) at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:945) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412) Caused by: org.pentaho.di.core.exception.KettleException: An error occured reading a transformation from the repository Unable to set partition schema for name [PartitionSchema], method: Mod partitioner This is the list of available partition schema: at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2609) at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2442) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:77) ... 23 more Caused by: org.pentaho.di.core.exception.KettleException: Unable to set partition schema for name [PartitionSchema], method: Mod partitioner This is the list of available partition schema:

    Pentaho BI Platform Tracking | 8 years ago | Jens Bleuel
    java.lang.reflect.InvocationTargetException: Error loading transformation
  6. 0

    I have created a transformation that injects metadata to a row denormalizer step using PDI 5.4 The transformation works perfectly when I am saving the files as .ktr, but if I create and save exactly the same in a database repository I obtain an error when running. If I close the transformation in the database repository I obtain as well an error and it's not possible to open it. Both error logs contain: ArrayIndexOutOfBoundsException I am attaching the ktr files for your review. EDIT: Sorry, I'm not being able to upload the file. Tried with .zip .ktr in Chrome and Mozilla and the file doesn't attach. Is it another bug or just me, nothing working today? Maybe something related to this bug came back: PDI-9152 Error Log when running: org.pentaho.di.core.exception.KettleException: Transformation was unable to open [MetaInject 1] An error occured reading a transformation from the repository at org.pentaho.di.trans.Trans.<init>(Trans.java:592) at org.pentaho.di.ui.spoon.trans.TransGraph.start(TransGraph.java:3639) at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:880) at org.pentaho.di.ui.spoon.Spoon$31$1.run(Spoon.java:8464) at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1319) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: org.pentaho.di.core.exception.KettleException: An error occured reading a transformation from the repository at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:669) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:278) at org.pentaho.di.trans.Trans.<init>(Trans.java:568) ... 16 more Caused by: java.lang.ArrayIndexOutOfBoundsException Error log when opening: java.lang.reflect.InvocationTargetException: Error loading transformation at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:97) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:105) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4237) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4159) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141) at org.pentaho.ui.xul.swt.tags.SwtToolbarbutton.access$100(SwtToolbarbutton.java:48) at org.pentaho.ui.xul.swt.tags.SwtToolbarbutton$1.widgetSelected(SwtToolbarbutton.java:96) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1319) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: org.pentaho.di.core.exception.KettleException: An error occured reading a transformation from the repository at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:669) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:278) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:92) ... 29 more Caused by: java.lang.ArrayIndexOutOfBoundsException

    Pentaho BI Platform Tracking | 1 year ago | Azucena Coronel
    org.pentaho.di.core.exception.KettleException: Transformation was unable to open [MetaInject 1] An error occured reading a transformation from the repository

    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. org.pentaho.di.core.exception.KettleException

      Error saving transformation to repository! Error updating batch ORA-00001: unique constraint ([[schema name]].SYS_C009403) violated

      at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation()
    2. org.pentaho.di
      RepositoryExportSaxParser.endElement
      1. org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation(KettleDatabaseRepositoryTransDelegate.java:307)
      2. org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:334)
      3. org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:315)
      4. org.pentaho.di.repository.RepositoryImporter.importTransformation(RepositoryImporter.java:491)
      5. org.pentaho.di.repository.RepositoryImporter.transformationElementRead(RepositoryImporter.java:597)
      6. org.pentaho.di.repository.RepositoryExportSaxParser.endElement(RepositoryExportSaxParser.java:86)
      6 frames
    3. Xerces2-j
      SAXParserImpl.parse
      1. org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
      2. org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
      3. org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
      4. org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
      5. org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
      6. org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
      7. org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
      8. org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
      9. org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
      10. org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
      10 frames
    4. Java RT
      SAXParser.parse
      1. javax.xml.parsers.SAXParser.parse(SAXParser.java:277)
      1 frame
    5. org.pentaho.di
      RepositoryImporter.importAll
      1. org.pentaho.di.repository.RepositoryExportSaxParser.parse(RepositoryExportSaxParser.java:58)
      2. org.pentaho.di.repository.RepositoryImporter.importAll(RepositoryImporter.java:100)
      2 frames
    6. Unknown
      Processor.processRow
      1. Processor.processRow(Processor.java:84)
      1 frame
    7. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1182)
      2. org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
      2 frames
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame