on 12-25-2014 6:26 AM
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
WARNING | 2014-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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please check below note :
747773 - System copy of R/3 4.7 ExtSet 2: Migration key .. is wrong
Regards,
Ashish
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
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.
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
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.