ZCM server migration tool fails to migrate server and finishes with errors

When running the server migration tool to move a primary server from a Windows 2003 32 bit OS to Windows 2008 64 bit OS, the process ends with errors. The migration log shows the following:

Error 1:
JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect com.novell.zenworks.configure.ConfigureException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect at com.novell.zenworks.configure.util.DatabaseUpgradeUtils.getConnection(DatabaseUpgradeUtils.java:191) at com.novell.zenworks.configure.actions.UpdateOpaqueDataConfigureAction.configure(UpdateOpaqueDataConfigureAction.java:73) at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1758) at com.novell.zenworks.install.customcode.configure.BaseZenConfigAction.install(BaseZenConfigAction.java:63) at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.GhostDirectory.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.Installer.install(DashoA10*..) at com.zerog.ia.installer.actions.InstallProgressAction.n(DashoA10*..) at com.zerog.ia.installer.actions.ProgressPanelAction$1.run(DashoA10*..) Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(ErrorMessage.java:552) at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:856) at com.sybase.jdbc3.tds.Tds.handleIOE(Tds.java:3702) at com.sybase.jdbc3.tds.Tds.handleIOE(Tds.java:3647) at com.sybase.jdbc3.tds.Tds.login(Tds.java:456) at com.sybase.jdbc3.jdbc.SybConnection.tryLogin(SybConnection.java:247) at com.sybase.jdbc3.jdbc.SybConnection.regularConnect(SybConnection.java:223) at com.sybase.jdbc3.jdbc.SybConnection.<init>(SybConnection.java:198) at com.sybase.jdbc3.jdbc.SybConnection.<init>(SybConnection.java:132) at com.sybase.jdbc3.jdbc.SybDriver.connect(SybDriver.java:179) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.novell.zenworks.configure.util.DatabaseUpgradeUtils.getConnection(DatabaseUpgradeUtils.java:181) ... 12 more java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(ErrorMessage.java:552) at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:856) at com.sybase.jdbc3.tds.Tds.handleIOE(Tds.java:3702) at com.sybase.jdbc3.tds.Tds.handleIOE(Tds.java:3647) at com.sybase.jdbc3.tds.Tds.login(Tds.java:456) at com.sybase.jdbc3.jdbc.SybConnection.tryLogin(SybConnection.java:247) at com.sybase.jdbc3.jdbc.SybConnection.regularConnect(SybConnection.java:223) at com.sybase.jdbc3.jdbc.SybConnection.<init>(SybConnection.java:198) at com.sybase.jdbc3.jdbc.SybConnection.<init>(SybConnection.java:132) at com.sybase.jdbc3.jdbc.SybDriver.connect(SybDriver.java:179) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.novell.zenworks.configure.util.DatabaseUpgradeUtils.getConnection(DatabaseUpgradeUtils.java:181) at com.novell.zenworks.configure.actions.UpdateOpaqueDataConfigureAction.configure(UpdateOpaqueDataConfigureAction.java:73) at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1758) at com.novell.zenworks.install.customcode.configure.BaseZenConfigAction.install(BaseZenConfigAction.java:63) at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.GhostDirectory.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.Installer.install(DashoA10*..) at com.zerog.ia.installer.actions.InstallProgressAction.n(DashoA10*..) at com.zerog.ia.installer.actions.ProgressPanelAction$1.run(DashoA10*..)

Error 2:
com.novell.zenworks.sysconfig.LauncherException: Cannot run program "C:\Program Files (x86)\Novell\ZENworks\share\asa\Bin32\dbsvc.exe": CreateProcess error=2, The system cannot find the file specified com.novell.zenworks.configure.ConfigureException: com.novell.zenworks.sysconfig.LauncherException: Cannot run program "C:\Program Files (x86)\Novell\ZENworks\share\asa\Bin32\dbsvc.exe": CreateProcess error=2, The system cannot find the file specified at com.novell.zenworks.configure.actions.db.DatabaseConfigureAction.configure(DatabaseConfigureAction.java:212) at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1758) at com.novell.zenworks.install.customcode.configure.BaseZenConfigAction.install(BaseZenConfigAction.java:63) at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.GhostDirectory.install(DashoA10*..) at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..) at com.zerog.ia.installer.Installer.install(DashoA10*..) at com.zerog.ia.installer.actions.InstallProgressAction.n(DashoA10*..) at com.zerog.ia.installer.actions.ProgressPanelAction$1.run(DashoA10*..) Caused by: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: com.novell.zenworks.sysconfig.LauncherException: Cannot run program "C:\Program Files (x86)\Novell\ZENworks\share\asa\Bin32\dbsvc.exe": CreateProcess error=2, The system cannot find the file specified at com.novell.zenworks.configure.actions.db.SybaseDatabaseConfigure.createDatabase(SybaseDatabaseConfigure.java:207) at com.novell.zenworks.configure.actions.db.DatabaseConfigureAction.configure(DatabaseConfigureAction.java:208) ... 12 more Caused by: com.novell.zenworks.sysconfig.LauncherException: Cannot run program "C:\Program Files (x86)\Novell\ZENworks\share\asa\Bin32\dbsvc.exe": CreateProcess error=2, The system cannot find the file specified at com.novell.zenworks.sysconfig.NativeLauncher.runCommand(NativeLauncher.java:229) at com.novell.zenworks.sysconfig.NativeLauncher.runCommand(NativeLauncher.java:121) at com.novell.zenworks.sysconfig.NativeLauncher.runCommand(NativeLauncher.java:107) at com.novell.zenworks.sysconfig.NativeLauncher.runCommand(NativeLauncher.java:95) at com.novell.zenworks.configure.actions.db.SybaseDatabaseConfigure.createDatabaseService(SybaseDatabaseConfigure.java:369) at com.novell.zenworks.configure.actions.db.SybaseDatabaseConfigure.createDatabase(SybaseDatabaseConfigure.java:203) ... 13 more Caused by: java.io.IOException: Cannot run program "C:\Program Files (x86)\Novell\ZENworks\share\asa\Bin32\dbsvc.exe": CreateProcess error=2, The system cannot find the file specified at java.lang.ProcessBuilder.start(Unknown Source) at com.novell.zenworks.sysconfig.NativeLauncher.runCommand(NativeLauncher.java:182) ... 18 more Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified at java.lang.ProcessImpl.create(Native Method) at java.lang.ProcessImpl.<init>(Unknown Source) at java.lang.ProcessImpl.start(Unknown Source) ... 20 more

The log also shows this:
sybase-asa-10.0.1.3960.msi installed successfully

Restore the servers to the state before running the migration, then delete the C:\Program Files (x86)\Novell\ZENworks\install\downloads\msi\sybase-asa-10.0.1.3960.msi file or rename it to sybase-asa-10.0.1.3960.msi.superceded. Then re-run the migration utility.

The problem with the last item noted from the logs above, is that the migration should not show that Sybase 10 is being installed, it should be version 12. When looking in the C:\Program Files (x86)\Novell\ZENworks\install\downloads\msi on the server to be migrated the following files were found:
novell-zenworks-sybase-libs-10.0.1.3960.msi.superceded
novell-zenworks-sybase-libs-12.0.0.2601.msi
novell-zenworks-sybase-libs-12.0.0.2601.x86_64.msi
sybase-asa-10.0.1.3960.msi

This was the source of the issue as the sybase-asa-10.0.1.3960.msi should have been superseded and renamed to sybase-asa-10.0.1.3960.msi.superceded.