4 Replies Latest reply on Jan 15, 2020 5:10 PM by James Banks

    When I run BMC Migration for 11.4 to 2019 it gives me a bucnh of errors and does not migrate any data. What is the best place to start troubleshooting?

    Carlos Maysonet
      Share This:

      Any help with this will surely be apreciated

       

      Error Log

      Migration Tool Version: 20.19.2.48

      Source Track-It! 11 version: 11.4.1.599

      Target Track-It! 2019 version: 20.19.02.048

      Source table: TASKS where WorkOrderTypeId in (2,3)

      Target table: NAMSYSTEMPLATE

      2019/08/05 15:49:36 - Kitchen - Logging is at level : Minimal

      2019/08/05 15:49:36 - Kitchen - Start of run.

      2019/08/05 15:51:43 - Templates - Start of job execution

      2019/08/05 15:51:44 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:44 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:44 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:44 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:44 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:44 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:45 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:45 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:45 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:46 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:46 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:46 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

      2019/08/05 15:51:48 - Table output.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected batch update error committing the database connection.

      2019/08/05 15:51:48 - Table output.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException:

      2019/08/05 15:51:48 - Table output.0 - Error updating batch

      2019/08/05 15:51:48 - Table output.0 - Violation of UNIQUE KEY constraint 'UQ_NAMSYSTEMPLATE_NAME'. Cannot insert duplicate key in object 'dbo.NAMSYSTEMPLATE'. The duplicate key value is (Printer No Imprime).

      2019/08/05 15:51:48 - Table output.0 -

      2019/08/05 15:51:48 - Table output.0 - at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1379)

      2019/08/05 15:51:48 - Table output.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1368)

      2019/08/05 15:51:48 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:575)

      2019/08/05 15:51:48 - Table output.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:96)

      2019/08/05 15:51:48 - Table output.0 - at java.lang.Thread.run(Thread.java:745)

      2019/08/05 15:51:48 - Table output.0 - Caused by: java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'UQ_NAMSYSTEMPLATE_NAME'. Cannot insert duplicate key in object 'dbo.NAMSYSTEMPLATE'. The duplicate key value is (Printer No Imprime).

      2019/08/05 15:51:48 - Table output.0 - at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:947)

      2019/08/05 15:51:48 - Table output.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1355)

      2019/08/05 15:51:48 - Table output.0 - ... 3 more

      2019/08/05 15:51:48 - migrateTicketTemplates - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Errors detected!

      2019/08/05 15:51:48 - migrateTicketTemplates - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Errors detected!

      2019/08/05 15:51:48 - migrateTicketTemplates - Transformation detected one or more steps with errors.

      2019/08/05 15:51:48 - migrateTicketTemplates - Transformation is killing the other steps!

      2019/08/05 15:51:48 - Templates - Job execution finished

      2019/08/05 15:51:48 - Kitchen - Finished!

      2019/08/05 15:51:48 - Kitchen - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Finished with errors

      2019/08/05 15:51:48 - Kitchen - Start=2019/08/05 15:49:36.893, Stop=2019/08/05 15:51:48.279

      2019/08/05 15:51:48 - Kitchen - Processing ended after 2 minutes and 11 seconds (131 seconds total).