Skip to Content
avatar image
Former Member

SAPINST is asking for a migration key in homogeneous system copy

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Dec 25, 2014 at 07:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 25, 2014 at 07:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

      Capture1.JPG (26.0 kB)
  • avatar image
    Former Member
    Dec 25, 2014 at 07:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      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

  • avatar image
    Former Member
    Dec 25, 2014 at 03:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded