cancel
Showing results for 
Search instead for 
Did you mean: 

SAPINST is asking for a migration key in homogeneous system copy

Former Member
0 Kudos

Dear Experts,

I have R3 4.7 Extension set 2 SR1 Unicode system installed on AIX 6.1 and DB2 9.7 FP5. When i tried to do a homogeneous system copy (export/import)(I have installed Central instance successfully, got the error during Database instance installation), I got a pop up with below error message during Database Load phase.

when I click on OK button it is asking me for migration key.

Why SAPINST is asking for migration when I am performing homogenous system copy?

I have chosen below option while installing Database Installation.

I tried generating the migration key, restarted the SAPINST & entered the migration key but no luck. Got the same error message again.

I have downloaded the latest R3load from SMP & placed it in the Kernel.

I have restarted the installation by giving 777 permissions recursively to /backup/temp/sapinst_instdir, got the same error again.


My source has Kernel 640 version patch 390 & target system has Kernel 640 version patch 21. Is the lower kernel patch causing the issue?


Actually I am planning to update kernel patch to 390 on target system, does it help?



I am pasting MIGKEY.log, testMigKey.log, sapinst.log, sapinst_dev.log below. Can someone please check & suggest.


MIGKEY.log

/sapmnt/OS2/exe/R3load: START OF LOG: 20141224214602

/sapmnt/OS2/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP

/sapmnt/OS2/exe/R3load: version R6.40/V1.4 [UNICODE]

Compiled Sep 15 2012 06:06:07

/sapmnt/OS2/exe/R3load -dbcodepage 4102 -i /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPAPPL0.cmd -l MIGKEY.log -K

(DB) INFO: connected to DB

(TFH) ERROR: Unable to open /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPAPPL0.cmd

(TFH) ERROR: OS error message: Permission denied

(DB) INFO: disconnected from DB

/sapmnt/OS2/exe/R3load: job finished with 1 error(s)

/sapmnt/OS2/exe/R3load: END OF LOG: 20141224214603


testMigKey.log

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

sapinst.log

WARNING 2014-12-24 21:46:03

Execution of the command "/sapmnt/OS2/exe/R3load -dbcodepage 4102 -i /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPAPPL0.cmd -l MIGKEY.log -K """ finished with return code 2. Output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

sapinst_dev.log

WARNING2014-12-24 21:46:03
       CJSlibModule::writeWarning_impl()

Execution of the command "/sapmnt/OS2/exe/R3load -dbcodepage 4102 -i /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPAPPL0.cmd -l MIGKEY.log -K """ finished with return code 2. Output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

TRACE  [iaxxejsexp.cpp:208]
       EJS_Installer::writeTraceToLogBook()

++--++ R3load result of testMigKey() = 2

TRACE  [iaxxbjsmod.cpp:301]
       CJSlibModule::showMessageBox_impl()

The migration key for a heterogeneous system copy is wrong. Try again.

Thanks,

Vinay

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks All for your valuable inputs. SAP note 747773 helped me to skip the error, i have edited control.xml file & restarted SAPINST. It did not prompt for migration key & went well. I got a new error in the same phase(Database Load phase) now. Pasting the logs here, can someone pls. help.

SQL0539N  Table or nickname "SAPR3.DDNTT_CONV_UC" does not have a "PRIMARY" key.  SQLSTATE=42888


SQL0603N  A unique index cannot be created because the table contains data that would result in duplicate index entries.  SQLSTATE=23515

sapinst.log


ERROR 2014-12-25 05:34:30

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPSDIC.log.

ERROR 2014-12-25 05:35:00

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPAPPL1.log.

ERROR 2014-12-25 05:35:31

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPPOOL.log.

ERROR 2014-12-25 05:36:31

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPSPROT.log.

ERROR 2014-12-25 05:36:31

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPSSEXC.log.

SAPSDIC.log

(DB) ERROR: DDL statement failed

(ALTER TABLE "DDNTT_CONV_UC" DROP PRIMARY KEY )

DbSlExecute: rc = 99

  (SQL error -539)

  error message returned by DbSl:

SQL0539N  Table or nickname "SAPR3.DDNTT_CONV_UC" does not have a "PRIMARY" key.  SQLSTATE=42888

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ALLOW REVERSE SCANS )

DbSlExecute: rc = 99

  (SQL error -603)

  error message returned by DbSl:

SQL0603N  A unique index cannot be created because the table contains data that would result in duplicate index entries.  SQLSTATE=23515

(DB) INFO: disconnected from DB

SAPAPPL1.log

(DB) ERROR: DDL statement failed

(ALTER TABLE "ZOV_CONT_SUMMARY" DROP PRIMARY KEY )

DbSlExecute: rc = 99

  (SQL error -539)

  error message returned by DbSl:

SQL0539N  Table or nickname "SAPR3.ZOV_CONT_SUMMARY" does not have a "PRIMARY" key. SQLSTATE=42888

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "ZOV_CONT_SUMMARY~0" ON "ZOV_CONT_SUMMARY" ( "MANDT", "VKORG", "VTWEG", "SPART", "ZZOV_SRC", "ZZOV_CFT", "ZZOV_CONTRACT_NO", "VBELN" ) ALLOW REVERSE SCANS )

DbSlExecute: rc = 99

  (SQL error -603)

  error message returned by DbSl:

SQL0603N  A unique index cannot be created because the table contains data that would result in duplicate index entries.  SQLSTATE=23515

(DB) INFO: disconnected from DB

SAPPOOL.log


(DB) INFO: connected to DB

(GSI) INFO: dbname   = "OS2                                                                                                                             "

(GSI) INFO: vname    = "DB6                             "

(GSI) INFO: hostname = "UNKNOWN                                                         "

(GSI) INFO: sysname  = "AIX"

(GSI) INFO: nodename = "ri3pa043"

(GSI) INFO: release  = "1"

(GSI) INFO: version  = "6"

(GSI) INFO: machine  = "00F6DC4A4C00"

(DB) INFO: ATAB deleted/truncated

failed to read short nametab of table  (rc=32)

(CNVPOOL) conversion failed for row 0 of table  VARKEY = X

(CNV) ERROR: data conversion failed.  rc = 2

(RSCP) INFO: environment variable "I18N_POOL_WIDTH" is not set. Checks are active.

(DB) INFO: disconnected from DB

SAPSPROT.log


(DB) ERROR: DDL statement failed

(ALTER TABLE "DB6PMST" DROP PRIMARY KEY )

DbSlExecute: rc = 99

  (SQL error -539)

  error message returned by DbSl:

SQL0539N  Table or nickname "SAPR3.DB6PMST" does not have a "PRIMARY" key.  SQLSTATE=42888

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "DB6PMST~0" ON "DB6PMST" ( "COMPTIME", "PARTITN", "TAB_SCHEMA", "TABLE_NAME", "CALLERFLAG" ) ALLOW REVERSE SCANS )

DbSlExecute: rc = 99

  (SQL error -603)

  error message returned by DbSl:

SQL0603N  A unique index cannot be created because the table contains data that would result in duplicate index entries.  SQLSTATE=23515

(DB) INFO: disconnected from DB

/sapmnt/OS2/exe/R3load: job finished with 1 error(s)

/sapmnt/OS2/exe/R3load: END OF LOG: 20141225053603

SAPSSEXC.log


(DB) INFO: connected to DB

(GSI) INFO: dbname   = "OS2                                                                                                                             "

(GSI) INFO: vname    = "DB6                             "

(GSI) INFO: hostname = "UNKNOWN                                                         "

(GSI) INFO: sysname  = "AIX"

(GSI) INFO: nodename = "ri3pa043"

(GSI) INFO: release  = "1"

(GSI) INFO: version  = "6"

(GSI) INFO: machine  = "00F6DC4A4C00"

(DB) INFO: DOKCLU deleted/truncated

myCluster (55.23.Imp): 712: error when retrieving alternate nametab description for physical table DOKCLU.

myCluster (55.23.Imp): 713: return code received from nametab is 32

myCluster (55.23.Imp): 299: error when retrieving physical nametab for table DOKCLU.

(CNV) ERROR: data conversion failed.  rc = 2

(DB) INFO: disconnected from DB

/sapmnt/OS2/exe/R3load: job finished with 1 error(s)

/sapmnt/OS2/exe/R3load: END OF LOG: 20141225053603

ashish_vikas
Active Contributor
0 Kudos

what is output of uname command on source and target system ?


Also check :


813964 - Migration Key Wrong - Release 4.7 and Web AS 6.x


Regards,

Ashish

Message was edited by: ashish vikas

Former Member
0 Kudos

Hi Ashish,

uname commad output is same for both.

AIX

Thanks,

Vinay

ashish_vikas
Active Contributor
0 Kudos
My source has Kernel 640 version patch 390 & target system has Kernel 640 version patch 21. Is the lower kernel patch causing the issue?

I agree, you should try this.

In fact, you can place all kernel files in target system and see if it works.

Homogeneous system copy should not ask for Mig Key in first place. If this do not work, open a OSS to SAP.

Regards,

Ashish

Sriram2009
Active Contributor
0 Kudos

Hi Vinay

1. Your Source & target system OS/DB & kernel & DBSL patch are same?

2. Could you refer the SAP Notes

1519000 - ERROR: invalid migration key


338372 - Migration key does not work

BR

SS

Former Member
0 Kudos

Hi Sriram,

Yes, Source & target system OS/DB & kernel & DBSL patch are same

Thanks,

Vinay

Sriram2009
Active Contributor
0 Kudos

Hi Vinay

I think your installation selection may be warning. the migration key is required when your either OS or DB different from the source system.Are you using the SWPM or SAPINT to perform the system copy?

I think you have to select the Standard installation not Standard system copy /Migration(R3load-Based), refer the snapshot

Kindly read the Homogeneous system copy guide before start the process.

BR

SS

Former Member
0 Kudos

Hi Vinay,

Try by using latest version of R3trans, run R3trans -x and R3trans -d tests when you encounter this error and post the results.

Regards,

Kaleem

ashish_vikas
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi Ashish,

Thanks for the valuable note. It helped to skip the error, i have edited control.xml file & restarted SAPINST. It did not prompt for migration key & went well. I got a new error in the same phase(Database Load phase) now. Pasting the logs here, can someone pls. help.

SQL0539N  Table or nickname "SAPR3.DDNTT_CONV_UC" does not have a "PRIMARY" key.  SQLSTATE=42888


SQL0603N  A unique index cannot be created because the table contains data that would result in duplicate index entries.  SQLSTATE=23515

sapinst.log


ERROR 2014-12-25 05:34:30

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPSDIC.log.

ERROR 2014-12-25 05:35:00

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPAPPL1.log.

ERROR 2014-12-25 05:35:31

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPPOOL.log.

ERROR 2014-12-25 05:36:31

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPSPROT.log.

ERROR 2014-12-25 05:36:31

MSC-01015  Process finished with error(s). SOLUTION: Check log file /backup/temp/sapinst_instdir/R3E47X2/COPY/IMPORT/SYSTEM/ABAP/DB6/UC/DB/SAPSSEXC.log.

SAPSDIC.log

(DB) ERROR: DDL statement failed

(ALTER TABLE "DDNTT_CONV_UC" DROP PRIMARY KEY )

DbSlExecute: rc = 99

  (SQL error -539)

  error message returned by DbSl:

SQL0539N  Table or nickname "SAPR3.DDNTT_CONV_UC" does not have a "PRIMARY" key.  SQLSTATE=42888

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ALLOW REVERSE SCANS )

DbSlExecute: rc = 99

  (SQL error -603)

  error message returned by DbSl:

SQL0603N  A unique index cannot be created because the table contains data that would result in duplicate index entries.  SQLSTATE=23515

(DB) INFO: disconnected from DB

SAPAPPL1.log

(DB) ERROR: DDL statement failed

(ALTER TABLE "ZOV_CONT_SUMMARY" DROP PRIMARY KEY )

DbSlExecute: rc = 99

  (SQL error -539)

  error message returned by DbSl:

SQL0539N  Table or nickname "SAPR3.ZOV_CONT_SUMMARY" does not have a "PRIMARY" key. SQLSTATE=42888

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "ZOV_CONT_SUMMARY~0" ON "ZOV_CONT_SUMMARY" ( "MANDT", "VKORG", "VTWEG", "SPART", "ZZOV_SRC", "ZZOV_CFT", "ZZOV_CONTRACT_NO", "VBELN" ) ALLOW REVERSE SCANS )

DbSlExecute: rc = 99

  (SQL error -603)

  error message returned by DbSl:

SQL0603N  A unique index cannot be created because the table contains data that would result in duplicate index entries.  SQLSTATE=23515

(DB) INFO: disconnected from DB

SAPPOOL.log


(DB) INFO: connected to DB

(GSI) INFO: dbname   = "OS2                                                                                                                             "

(GSI) INFO: vname    = "DB6                             "

(GSI) INFO: hostname = "UNKNOWN                                                         "

(GSI) INFO: sysname  = "AIX"

(GSI) INFO: nodename = "ri3pa043"

(GSI) INFO: release  = "1"

(GSI) INFO: version  = "6"

(GSI) INFO: machine  = "00F6DC4A4C00"

(DB) INFO: ATAB deleted/truncated

failed to read short nametab of table  (rc=32)

(CNVPOOL) conversion failed for row 0 of table  VARKEY = X

(CNV) ERROR: data conversion failed.  rc = 2

(RSCP) INFO: environment variable "I18N_POOL_WIDTH" is not set. Checks are active.

(DB) INFO: disconnected from DB

SAPSPROT.log


(DB) ERROR: DDL statement failed

(ALTER TABLE "DB6PMST" DROP PRIMARY KEY )

DbSlExecute: rc = 99

  (SQL error -539)

  error message returned by DbSl:

SQL0539N  Table or nickname "SAPR3.DB6PMST" does not have a "PRIMARY" key.  SQLSTATE=42888

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "DB6PMST~0" ON "DB6PMST" ( "COMPTIME", "PARTITN", "TAB_SCHEMA", "TABLE_NAME", "CALLERFLAG" ) ALLOW REVERSE SCANS )

DbSlExecute: rc = 99

  (SQL error -603)

  error message returned by DbSl:

SQL0603N  A unique index cannot be created because the table contains data that would result in duplicate index entries.  SQLSTATE=23515

(DB) INFO: disconnected from DB

/sapmnt/OS2/exe/R3load: job finished with 1 error(s)

/sapmnt/OS2/exe/R3load: END OF LOG: 20141225053603

SAPSSEXC.log


(DB) INFO: connected to DB

(GSI) INFO: dbname   = "OS2                                                                                                                             "

(GSI) INFO: vname    = "DB6                             "

(GSI) INFO: hostname = "UNKNOWN                                                         "

(GSI) INFO: sysname  = "AIX"

(GSI) INFO: nodename = "ri3pa043"

(GSI) INFO: release  = "1"

(GSI) INFO: version  = "6"

(GSI) INFO: machine  = "00F6DC4A4C00"

(DB) INFO: DOKCLU deleted/truncated

myCluster (55.23.Imp): 712: error when retrieving alternate nametab description for physical table DOKCLU.

myCluster (55.23.Imp): 713: return code received from nametab is 32

myCluster (55.23.Imp): 299: error when retrieving physical nametab for table DOKCLU.

(CNV) ERROR: data conversion failed.  rc = 2

(DB) INFO: disconnected from DB

/sapmnt/OS2/exe/R3load: job finished with 1 error(s)

/sapmnt/OS2/exe/R3load: END OF LOG: 20141225053603

ashish_vikas
Active Contributor
0 Kudos

with help of

Can you please try to find if check for duplicate rows are there in the target databse and compare with source system databse ?

Regards,

Ashish

Former Member
0 Kudos

Hi Ashish,

I have executed below command in Target system as per thread SQL0603N  A unique index cannot be created because the table contains, got some duplicate records where as there are no duplicate records found in source system.

Found 1 duplicate entry for table DB6PMST, 7 for table ZOV_CONT_SUMMARY, 10132 for table DDNTT_CONV_UC.

Attaching the screen shots here. Can someone guide me how to fix the issue.

ashish_vikas
Active Contributor
0 Kudos

For me, this points of having a corrupt export.

Did you had any errors in source system export ? OR was SAP stopped when export was running ?

please try with a new export and import with a minimum kernel version of source release.

Regards,

Ashish

Former Member
0 Kudos

Hi Ashish,

I had couple errors during export related to file permissions, environment variable, code page mismatch. For uni code systems codepage value should be 4102 but initially I kept the default value 1100, I changed it to 4102 later on & issue got fixed. Source system export finished successfully.



I had stopped SAP application before I started source system export. As per system copy guide only Database should be up. Please correct me if i am wrong.


Thanks,

Vinay





ashish_vikas
Active Contributor
0 Kudos

I had couple errors during export related to file permissions, environment variable, code page mismatch. For uni code systems codepage value should be 4102 but initially I kept the default value 1100, I changed it to 4102 later on & issue got fixed. Source system export finished successfully.

Can you confirm, Are you using R3load in target system which is of minimum of same version that of source ?

If this is a test migration, I will try to have a clean Export again.

I had stopped SAP application before I started source system export. As per system copy guide only Database should be up. Please correct me if i am wrong.

you are correct.

Lets see what other ppl say here ?

Regards,

Ashish

Former Member
0 Kudos

Hi Ashish,

R3load version is same in both systems.

Target system:

Source system:

Dear Experts,

Can anyone Please shed some light on the issue.

Thanks,

Vinay