8 Replies Latest reply on Aug 29, 2019 3:56 PM by Brian Da Silva

    Migration from 11.4 to 2019 stalled at 70%..

    Richard Gooding
      Share This:

      Hi,  I am running the migration tool on our current trackit 11.4 server. The migration gets to tracked items and it halts and have not moved since yesterday. Same thing happened yesterday so I aborted and started again.

      Could some one tell me where the logs are kept so I can do some troubleshooting?

      Thanks

      Richard

        • 1. Re: Migration from 11.4 to 2019 stalled at 70%..
          Cris Coffey

          There is a LOT going on when tracked items are migrated. It takes quite a while to do that part of the migration. It is best to just let it run.  You also have the option of downloading the new R3 update and the new migration tool that goes with it and skipping tracked items if you choose. Some people do that and allow the asset discovery and scan to populate their asset information fresh.

          • 2. Re: Migration from 11.4 to 2019 stalled at 70%..
            Richard Gooding

            Thanks you..

            The R3 migration stopped me as the target server had trackit 20.19.02.048

             

            Do uninstall and reinstall the 03 version or can I install  the 03 version over the 02 version?

             

            Thanks again.

            Richard Gooding

            519-570-9777 (WRPS) ext.8211

            • 3. Re: Migration from 11.4 to 2019 stalled at 70%..
              Cris Coffey

              You can install the 03 update right over the 02 update. This is documented in the documentation on installing and upgrading here:

               

              https://docs.bmc.com/docs/trackit2019/en/upgrading-852580883.html

              • 4. Re: Migration from 11.4 to 2019 stalled at 70%..
                Richard Gooding

                Hi Cris,

                I did what you suggested and reran the migration. THis time it crashed during the Purchase Orders migration.. Below is the content of the log file

                 

                Migration Tool Version: 20.19.3.72

                Source Track-It! 11 version: 11.4.1.558

                Target Track-It! 2019 version: 20.19.03.072

                Source table: PURCHASE

                Target table: _SMDBA_._PO_

                2019/08/29 16:14:38 - Kitchen - Logging is at level : Minimal

                2019/08/29 16:14:38 - Kitchen - Start of run.

                2019/08/29 16:16:40 - PurchaseOrder - Start of job execution

                2019/08/29 16:16:41 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:41 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:41 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:41 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:41 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:41 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:41 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:43 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:43 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:43 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:43 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:43 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

                2019/08/29 16:16:43 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

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

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

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

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

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

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

                2019/08/29 16:17:05 - Add FILEBLOB.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : UnexpectedError:

                2019/08/29 16:17:05 - Add FILEBLOB.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : java.lang.OutOfMemoryError: Java heap space

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at java.util.Arrays.copyOf(Unknown Source)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at java.lang.AbstractStringBuilder.ensureCapacityInternal(Unknown Source)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at java.lang.AbstractStringBuilder.append(Unknown Source)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at java.lang.StringBuffer.append(Unknown Source)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at java.text.MessageFormat.subformat(Unknown Source)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at java.text.MessageFormat.format(Unknown Source)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at java.text.Format.format(Unknown Source)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.mozilla.javascript.ScriptRuntime$DefaultMessageProvider.getMessage(ScriptRuntime.java:3755)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.mozilla.javascript.ScriptRuntime.getMessage(ScriptRuntime.java:3723)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.mozilla.javascript.ScriptRuntime.getMessage2(ScriptRuntime.java:3684)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.mozilla.javascript.Context.reportRuntimeError2(Context.java:970)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.mozilla.javascript.NativeJavaObject.reportConversionError(NativeJavaObject.java:896)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.mozilla.javascript.NativeJavaObject.coerceTypeImpl(NativeJavaObject.java:625)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.mozilla.javascript.Context.jsToJava(Context.java:1729)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.pentaho.di.core.util.JavaScriptUtils.jsToString(JavaScriptUtils.java:130)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.pentaho.di.core.util.JavaScriptUtils.convertFromJs(JavaScriptUtils.java:53)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.getValueFromJScript(ScriptValuesMod.java:486)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:416)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:540)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)

                2019/08/29 16:17:05 - Add FILEBLOB.0 - at java.lang.Thread.run(Unknown Source)

                2019/08/29 16:17:05 - migratePOAttachment - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Errors detected!

                2019/08/29 16:17:05 - migratePOAttachment - Transformation detected one or more steps with errors.

                2019/08/29 16:17:05 - migratePOAttachment - Transformation is killing the other steps!

                2019/08/29 16:17:05 - migratePOAttachment - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Errors detected!

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

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

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

                2019/08/29 16:17:05 - Abort Attachment on Error - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Aborting job.

                2019/08/29 16:17:05 - PurchaseOrder - Job execution finished

                2019/08/29 16:17:05 - Kitchen - Finished!

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

                2019/08/29 16:17:05 - Kitchen - Start=2019/08/29 16:14:38.067, Stop=2019/08/29 16:17:05.779

                2019/08/29 16:17:05 - Kitchen - Processing ended after 2 minutes and 27 seconds (147 seconds total).

                • 5. Re: Migration from 11.4 to 2019 stalled at 70%..
                  Cris Coffey

                  You should probably contact support at this point since it failed. They can now get copies of the logs, a copy of the database, and troubleshoot and determine exactly what the problem is.

                  • 6. Re: Migration from 11.4 to 2019 stalled at 70%..
                    Richard Gooding

                    OK thanks for all your help

                    • 7. Re: Migration from 11.4 to 2019 stalled at 70%..
                      Cris Coffey

                      Wish I could help more but when it gets to this point its time to call in the experts.

                      • 8. Re: Migration from 11.4 to 2019 stalled at 70%..
                        Brian Da Silva

                        This is the error indicated in the above log file "Add FILEBLOB.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : java.lang.OutOfMemoryError: Java heap space"

                        The migration tool has run of memory to complete the pentaho job. Please contact support as we have a solution for this error.