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

[cwcheong]

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

[Former Member · Accepted solution]

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.

[Former Member]

Hello guys!

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

Best regards, Jaikbayev Bakhtiyar

[former_member661805]

Note work fine.

Tks

[Former Member]

Hi All,

I'm also facing same problem in Import ABAP Phase,

Error Message: " The migration key for a heterogeneous system copy is wrong. SOLUTION: Enter a valid migration key."

Source System: OS/400

DB: DB2 UDB for Iseries, 7.1

SAP: Solman 7.1

Target System: Linux 6

DB: DB2 LUM 10.1

SAP: Solman 7.1

Also I tried with “1G5fdEM50DwIrBzjt6TE5Pae ” (valid until 31/DEC/14) Key which is available in 1768158 (1768158 - System Copy of Systems Based on SAP NW 7.0 / 7.0 EHP 1-3 ) SAP note, but no luck.

Regards,

Vino

[Former Member]

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

[Former Member]

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?

[markus_doehr2]

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

[Former Member]

Hi,

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

1G5fdEM50TMIrBzjt6TE5Pae

This is as per the note 970518

Thaslim

[alex_tender]

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

[Former Member]

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

[Former Member]

Hi Samiran,

The note you have mentioned has worked for me 970518

regarding wrong migration key

Thanks!

Vardhan

[Former Member]

Dear Samiran,

Your solution worked for me. Thank you.

Kind rgds,

Ashwin Mane

[cwcheong]

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

[Former Member]

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

[cwcheong]

Unfortunately, i still don't have got any good answer or solution and still hoping for one very soon.

Pls update here should you manage to resolve it later.

One possible cause: Is your source system MDMP / IDES ? In my case, it seems to be a MDMP system with a few entries in table:TCPDB

[Former Member]

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

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

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

Maybe you can check the language configuration and export log of the source sytem.

For example: SAPAPPL0.log

(CNV) WARNING: conversion from MDMP to 1100 not possible

Correct language config and export again maybe can solve this problem.

(To change language config is dangerous. check notes 838403 and Backup)

Edited by: Chen stanley on Jul 14, 2008 4:47 AM

[cwcheong]

-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.

[Former Member]

Hi Steven

Please update R3load,R2trans & R3check with latest patches

Check note 898181

Hope this helps

Ravinder

[cwcheong]

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

[Former Member]

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>

[Former Member]

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

[cwcheong]

Thks for guys's prompt input. but still doesn't work despite r3load same release / version.

1. wondering, if we permit to migration IDES system.

2. also checked this 2 notes without luck

813964 - Migration Key Wrong - Release 4_7 and Web AS 6_x.htm

338372 - Migration key does not work.htm

Steven

[Former Member]

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