{"id":19927,"date":"2020-06-06T07:19:59","date_gmt":"2020-06-06T07:19:59","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=19927"},"modified":"2023-11-03T08:44:48","modified_gmt":"2023-11-03T08:44:48","slug":"how-to-solve-error-incorrect-version-no-amigkey-mig-release-error-while-executing-the-pre-migration-script","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/06\/06\/how-to-solve-error-incorrect-version-no-amigkey-mig-release-error-while-executing-the-pre-migration-script\/","title":{"rendered":"How to solve error \u201cIncorrect version No (AMIGKEY\/MIG_RELEASE)\u201d Error while executing the Pre-Migration Script"},"content":{"rendered":"\n

In some industries the company wants to migrate the data from lower version to higher version in Sage X3. Every company wants to upgrade the system functionally or data on the higher version. For that we run some per-migration script. At that time, we will get Error: \u2018Incorrect version No (AMIGKEY\/MIG_RELEASE)\u2019<\/strong>. With the help of some SQL queries and script we can solve this error.<\/p>\n\n\n\n

For Pre-Migration utility follow the below step:<\/p>\n\n\n\n

Navigate To: Usage >> Migration >> Sequencing\nmonitor<\/strong><\/p>\n\n\n\n

  1. Enter plan and Select the folder for which folder you want to execute the Pre-Migration script. And click on create button as shown in below figure.<\/li><\/ol>\n\n\n\n\n\n

    While executing the script you will get Error:’Incorrect version No (AMIGKEY\/MIG_RELEASE)’<\/strong><\/em> as shown in below figure.<\/p>\n\n\n\n\n\n

    In the X3-folder in the table AMIGKEY a row with the information about the X3 version is missing.<\/p>\n\n\n\n

    You have to add it first via Script Editor. Then you have to add a value with the missing info about the version<\/p>\n\n\n\n

    This information is required when executing the pre-scripts for migration. If this information is missing, the error message mentioned above is displayed when executing the script UUMGPREX3.<\/strong><\/p>\n\n\n\n

    You have to add it first via Script Editor. Then you have to add a value with the missing info about the version.<\/p>\n\n\n\n

    Now you have to run these following queries in database:<\/p>\n\n\n\n

    select * from X3.ADOVAL where PARAM_0=’RELEASE’       …………….Query 1
    select * from X3.AMIGKEY                                                        ……………. Query 2<\/strong><\/p>\n\n\n\n

    Refer the below screenshot for the same:<\/p>\n\n\n\n\n\n

    Step 1 – Create a row for the info with\nIDENT_0 = MIG_RELEASE<\/strong><\/p>\n\n\n\n