Parallel Migration Fails When Copying SY_SagePEPTask

Summary

During Parallel Migration, you receive the error: “Prepare failed with the following error: Create Table failed for …\MAS90\MAS_SYSTEM\SY_SagePEPTask\PHYISCAL UPDATE ABORT: SY_SagePEPTask – Error occurred during file copy.” Or error refers to the SY_SagePep.M4T file in the MAS_SYSTEM folder.

Cause

Possible corruption of SY_SagePEPTask.m4t or SY_SagePep.m4t files in the source installation.

Resolution

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

Restore SY_SagePEP.M4T and SY_SagePEPTask.M4T from backup (or previous version).
Or download clean versions (see Attachments section) to the older (source) installation:
Once SY_SagePEP.m4t and SY_SagePEPTask.m4t files are restored from backup or extracted from the Attachments on this article they need to be copied to the old/Source and new/Target installations:

Source (old) install:

  1. In the source (older version) installation, browse to the …\MAS90\MAS_SYSTEM folder
  2. Rename the following files:
    • SY_SagePEP.M4T
    • SY_SagePEPTask.M4T
  3. In the location where you restored the files or extracted the files, press Ctrl then select the SY_SagePEP.M4T and SY_SagePEPTask.M4T files that you restored or extracted from Knowledgebase article and right-click then select Copy
  4. In the old installation, …\MAS90\MAS_System\ folder, Right-click in any open area and select Paste

Target (new) install:

  1. In the new (target) installation, browse to the …\MAS90\MAS_SYSTEM folder
  2. Rename the following files:
    • SY_SagePEP.M4T
    • SY_SagePEPTask.M4T
  3. In the location where you restored the files or extracted the files, press Ctrl then select the SY_SagePEP.M4T and SY_SagePEPTask.m4t files that you restored or extracted from Knowledgebase article and right-click then select Copy
  4. In the new installation, …\MAS90\MAS_System\ folder, Right-click in any open area and select Paste

After both old and new installs have the SY_SagePEP.m4t and SY_SagePEPTask.m4t existing files renamed and replaced with the replacement files:

  1. Re-run the migration again from the new installation (after replacing both old & new install sets of SY_SagePEP & SY_SagePEPTask files).