22 Replies Latest reply: Mar 24, 2013 4:06 PM by Ashwin Mane RSS

Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)

Chee Woon Steven Cheong
Currently Being Moderated

Hi guys,

 

I am in the process of migrating system for the below

 

source system

IDES ECC 5.0

WebAS 6.40

MSSQL 2000 SP4/8.00

 

Target system

IDES ECC 5.0

WebAS 6.40

ORACLE 9.2.0.6

 

I am currently stuck at the migration key. At the heterogeneous system copy screen stage -> Database load which is asking for a migration key. I always got the error -> wrong migration key and unable to proceed.

 

We registered the key at service.sap.com/migrationkey on the source system's installation no.

 

kindly advise any experience of such and any other possible solution or alternative. Thks

 

Steven

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    Ravinder Singh Sahota
    Currently Being Moderated

    Hi

     

    Please enter the hostname in proper case.

    (as found in hostname command)

    Also make sure that installation numbers and source and target DB's are correctly selected while key generation.

     

     

    Also check SPA note 813964 for details

     

    ravinder

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    Currently Being Moderated

    Steven, I've had trouble in past with migration keys that has eventually been traced back to different versions of 'R3load' being used for the export and import.

     

    If possible make sure R3load is the exact same release & patch level during the export and import. I have found this applies even if you are moving to a different OS platform.

     

    Hope that helps

     

    Regards

    Danny

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    Chee Woon Steven Cheong
    Currently Being Moderated

    -extraced from logs.

    -both system was using R6.40/V1.4.

    -Migration key is masked off.

    -any suggestion/idea is appreciated.

     

    migkey.log

    -


    F:\usr\sap\EC1\SYS\exe\run/R3load.exe: START OF LOG: 20060619101345

     

    F:\usr\sap\EC1\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_LO_REL/src/R3ld/R3load/R3ldmain.c#1 $ SAP

    F:\usr\sap\EC1\SYS\exe\run/R3load.exe: version R6.40/V1.4

    F:\usr\sap\EC1\SYS\exe\run/R3load.exe -dbcodepage 1100 -i D:\Program Files\sapinst_instdir\ECC_50_ABAP_NUC\DB/SAPAPPL0.cmd -l MIGKEY.log -K 1WUxxxxxxxxxxxxxxxx

     

    (DB) ERROR: DbSlControl(DBSL_CMD_IMP_FUNS_SET) rc = 20

    (DB) ERROR: DbSlErrorMsg rc = 20

     

    F:\usr\sap\EC1\SYS\exe\run/R3load.exe: job finished with 1 error(s)

    F:\usr\sap\EC1\SYS\exe\run/R3load.exe: END OF LOG: 20060619101345

     

    extracted from sapinst.log

    -


     

    INFO 2006-06-19 10:16:56

    Working directory changed to D:\Program Files\sapinst_instdir\ECC_50_ABAP_NUC\DB.

     

    INFO 2006-06-19 10:16:56

    See 'F:\usr\sap\EC1\SYS\exe\run/R3load.exe  -dbcodepage 1100 -i "D:\Program Files\sapinst_instdir\ECC_50_ABAP_NUC\DB/SAPAPPL0.cmd" -l MIGKEY.log -K 1WUfxxxxxxxxxxxxxxx' output in 'D:\Program Files\sapinst_instdir\ECC_50_ABAP_NUC\DB\R3load.exe.log'.

     

    INFO 2006-06-19 10:16:56

    'F:\usr\sap\EC1\SYS\exe\run/R3load.exe  -dbcodepage 1100 -i "D:\Program Files\sapinst_instdir\ECC_50_ABAP_NUC\DB/SAPAPPL0.cmd" -l MIGKEY.log -K 1WUfxxxxxxxxxxxxxxx' returned with '2'.

     

    INFO 2006-06-19 10:17:28

    Creating file D:\Program Files\sapinst_instdir\ECC_50_ABAP_NUC\DB\R3load.exe.log.

    • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
      Ravinder Singh Sahota
      Currently Being Moderated

      Hi Steven

      Please update R3load,R2trans & R3check with latest patches

      Check note 898181

      Hope this helps

       

      Ravinder

      • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
        Chee Woon Steven Cheong
        Currently Being Moderated

        Installed with latest R3load,R3trans & R3check but still doesn't solve the wrong migration key.

        • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
          Currently Being Moderated

          It's a long shot, but have a look at note 459899, in particular the section below that is a direct copy from the note, this also mentions the DBSL_CMD_IMP_FUNS_SET error you've been getting & another potential fix. Yes it's about 3 years old & is for a BW install, but its Oracle & an R3Load process failing with the same error you currently have.

          good luck, you never know....

           

          beyond that I know from personal experience that migration keys can either work straight off or be very very frustrating for no obvious reason! I recommend checking with SAP if it is possible to migrate an IDES system (i'd be suprised if you can't)

           

          Danny

           

           

          -12/FEB/02-R/3LOAD error due to non-default mount directory-------

           

          You must use the default mount directory /sapmnt for your SAP System, otherwise R3LOAD cannot connect.

           

          DO NOT even use "/sapmnt/<SAPSID>".

           

          If you have already run in this problem, the following string exists in the SAP<TABART>.log, for example SAPAPPLO.log:

           

                     "... (DB) ERROR: DbSlControl(DBSL_CMD_IMP_FUNS_SET) rc = 20

           

                          (DB) ERROR: DbSlErrorMsg rc = 20... "

           

          Solution:

           

                      a) Open file <SAPinst_INSTDIR>/keydb.xml

           

                      b) Search for string

                      <table name="tORA_Environment" namespaces="DBMODORA WAPS">

           

                      c) Adjust DIR_LIBRARY path in row

           

                     <row>

           

                      <fld name="dbSid">

           

                        <strval><![CDATA[BW1]]>< /strval>

           

                      </fld>

           

                      <fld name="SapSystemName">

           

                        <strval><![CDATA[BW1]]>< /strval>

           

                      </fld>

           

                        <fld name="Name">

           

                        <strval><![CDATA[DIR_LIBRARY]]>< /strval>

           

                      </fld>

           

                      <fld name="Value">

           

                        <strval><![CDATA[/sapmnt/BW1/exe] ]></strval>

          Enter here exactly the sapmnt path that is mentioned in the

          SAP<TABART>.log.

           

                      </fld>

           

                     </row>

           

                      d) Save your settings.

           

                      e) Run ./sapinst in your <SAPinst_INSTDIR>

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    Chee Woon Steven Cheong
    Currently Being Moderated

    more info about error. I even tried the below.

    1.SAPF12 - F12 is homogeneous copied to sapec1 -F12 successfully.

    2.exported from sapec1-F12-SQL (same source / target system)

    3.import as sapec1-EC1-ORA. - STILL no luck and stuck with migration key error.

    4.r3load / ldctl similar version or latest version and etc.

    5. extracted error migkey.log.

    6. Source: Rel6.40(Non-unicode,IDES ECC 5.0,POSSIBLE WITH MDMP)

    7. Good solution will be rewarded with points.

    8. Tried Note: 788924 - no luck and was for unicode system.

    9. Loaded also latest R3load.* and dboraslib.* (on target)

     

    ---

    D:\usr\sap\EC1\SYS\exe\run\R3load.exe: START OF LOG: 20060905160733

     

    D:\usr\sap\EC1\SYS\exe\run\R3load.exe: sccsid @(#) $Id: //bas/640_LO_REL/src/R3ld/R3load/R3ldmain.c#1 $ SAP

    D:\usr\sap\EC1\SYS\exe\run\R3load.exe: version R6.40/V1.4

    D:\usr\sap\EC1\SYS\exe\run\R3load.exe -dbcodepage 1100 -i D:\Program Files\sapinst_instdir\ECC_50_ABAP_NUC\DB\SAPAPPL0.cmd

     

    -l MIGKEY.log -K 1WagdUM50T001eqtdAQt1aev

     

    (DB) INFO: connected to DB

    (DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

    (CNV) ERROR: rscpMCActivate rc = 2048

    .--


    ============--


    .|                              RSCP - Error      

     

                         || Error from:             Codepage handling (RSCP)                     || code: 2048  RSCPENOCONV 

     

    Wanted conversion not available.            || in character code "MDMP" unknown                                     ||

     

    module: rscpc    no:   22 line: 12409                    T100: TS012 || TSL01: F43  p3: MDMP                              

     

                      |`----


    '

    D:\usr\sap\EC1\SYS\exe\run\R3load.exe: job finished with 1 error(s)

    D:\usr\sap\EC1\SYS\exe\run\R3load.exe: END OF LOG: 20060905160750

    • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
      OEDIV OEDIV Bielefeld
      Currently Being Moderated

      Hello,

       

      I got the same error:

      ###############################################

                         RSCP - Error

      Error from:             Codepage handling (RSCP)

      code: 2048  RSCPENOCONV  Wanted conversion not available

      in character code "MDMP" unknown

      module: rscpc    no:   22 line: 12897                    T100: TS012

      TSL01: F43  p3: MDMP

                                                  

      when I tried to load an db export into a MaxDB system.

      A new R3load returned the same error.

      Is there a solution available?

      Regards, Armin

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    Samiran Patra
    Currently Being Moderated

    Hi Steven

     

    Please use the default Migration key for any heterogen sys copy " 1G5fdEM50T1IrBzjt6TE5Pae" as per SAP note 970518. Hope you should be through with this silly error.

     

    Best luck

     

    Samiran

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    Mervyn Duddy
    Currently Being Moderated

    We eventually we got through a long series of Wrong Migration Key errors by making the OS and DB selections as generic as possible.  That is, rather than trying to specify the exact version of Oracle, Linux and Unix, from the drop-down lists, we selected Linux and Unix without versions, and likewise with Oracle, even though we were also upgrading Oracle at the same time, from 9.2 to 10.2.

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    Alex Tender
    Currently Being Moderated

    Hi

     

    I had the same error, Found that the environment variables was not set, I added it and some other variables as well and it solved the problem.

     

    The variables that I changed:

    SAPSYSNAME

    DIR_LIBRARY

    db_ora_tnsname

    PATH

     

    good luck

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    Thaslim Jakson
    Currently Being Moderated

    Hi,

     

    Use the following migration key (valid until 31/DEC/08):

    1G5fdEM50TMIrBzjt6TE5Pae

     

    This is as per the note 970518

     

    Thaslim

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    ben yu
    Currently Being Moderated

    Dear all:

    I also have a similar error message:

     

    source system:

    DEV:SAP R/.3  4.71,non-Unicode system,kernel 640_64bit level 247

    OS:AIX 5.3 64BIT

    DB:ORACLE 9.2.0.4.0 64BIT

     

    target system:

    QAS:SAP R/.3  4.71,non-Unicode system,kernel 640_EX2_64bit level 247

    OS:WIN2003  R2 64BIT (AMD64)

    DB:ORACLE 10.2.0.2.0 64BIT

     

    MIGKEY.log

    ***********************************************************************************************************************

    D:\usr\sap\QAS\SYS\exe\run/R3load.exe: START OF LOG: 20090114161506

     

    D:\usr\sap\QAS\SYS\exe\run/R3load.exe: sccsid @(#)

    $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP

    D:\usr\sap\QAS\SYS\exe\run/R3load.exe: version R6.40/V1.4

    Compiled Aug 17 2008 23:18:48

    D:\usr\sap\QAS\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program

    Files\sapinst_instdir\R3E47X2

    \COPY\IMPORT\SYSTEM\ABAP\ORA\NUC\DB/SAPAPPL0.cmd -l MIGKEY.log -K

    1G5fdEM50TIIrBzjt6TE5Pae

     

    DbSl Trace: ORA-1403 when accessing table SAPUSER

     

    (DB) INFO: connected to DB

    (DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

    (CNV) ERROR: rscpMCInit rc = 2048

     

    -


    3-

    code: 2048 RSCPENOCONV

    convert MDMP to Unicode during export only

    module: rscpexmh location: 4 line: 424

    TSL01: CQI p3: MDMP&->&1100&during export only&&

    -


    .

     

    D:\usr\sap\QAS\SYS\exe\run/R3load.exe: job finished with 1 error(s)

    D:\usr\sap\QAS\SYS\exe\run/R3load.exe: END OF LOG: 20090114161506

     

    How to solve this issue?

    • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
      Markus Doehr
      Currently Being Moderated

      Please guys:

       

      if you post logfiles, please put code tags around them (mark the pasted text and press on the "<< >>" sign next to the "underline" button. This will prevent that the backend will interpret the input and makes the logs much more readable.

       

      Are those systems single codepage systems or MDMP systems? If the latter, then you need to enter "MDMP" as export codepage (not 1100 as by default). To make this field editable for non-numeric characters, follow the section "System copy of MDMP systems:" to change dialog.xml in

       

      Note 970518 - Hom./Het.System Copy SAP NetWeaver 7.0 (2004s) SR2

       

      although that note is for 7.00 it also works for 6.40 based kernels.

       

       

       

      Markus

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    sri vardhan
    Currently Being Moderated

    Hi Steven,

     

    Even I have strucked my migration process in same step at import abap phase

    Could you please help me in solving this issue if you have done.

    i have generate the migration key from service market place.

    At the initial stage of the migration process i have given the migration key it took it

    But now it is asking for a valid migration key

     

    Could you help me in solving the issue

     

    source system is

    win 2003with mssql as database

    target system is

    linux with maxdb as database

  • Re: Wrong Migration Key - Heterogeneous system copy (SQL to ORA DB)
    Bakhtiyar Jaikbayev
    Currently Being Moderated

    Hello guys!

    Solution you can find in note https://service.sap.com/sap/support/notes/970518

    Best regards, Jaikbayev Bakhtiyar

Actions