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
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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

    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