BI 7.0 Systemcopy with 1 failed during import

[steven_bier]

Hello,

we want to do a system copy with Export / Import both System are on Windos 2k3 64bit with MSSQL.

The Export running fine.

Now during the Import Step 1failed, the follwoing error is shown in

Import_log:

ERROR: 2011-01-10 12:52:19 com.sap.inst.migmon.LoadTask run

Loading of '_BIC_FZ0C0007' import package is interrupted with R3load error.

Process 'P:\usr\sap\QBI\SYS\exe\uc\NTAMD64\R3load.exe -i BICFZ0C0007.cmd -dbcodepage 4103 -l BICFZ0C0007.log -loadprocedure fast' exited with return code 2.

For mode details see '_BIC_FZ0C0007.log' file.

Standard error output:

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

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

BICFZ0C0007.log

P:\usr\sap\QBI\SYS\exe\uc\NTAMD64\R3load.exe: version R7.01/V1.4 [UNICODE]

Compiled Feb 24 2009 23:41:07

P:\usr\sap\QBI\SYS\exe\uc\NTAMD64\R3load.exe -i BICFZ0C0007.cmd -dbcodepage 4103 -l BICFZ0C0007.log -loadprocedure fast

(DB) INFO: connected to DB

(GSI) INFO: dbname = "QBITESTSERVERQBI64 "

(GSI) INFO: vname = "MSSQL "

(GSI) INFO: hostname = "TESTSERVERQBI64 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "TESTSERVERQBI64"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 2"

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 46 Step 6)"

(DB) INFO: /BIC/FZ0C0007 created

(DB) INFO: /BIC/FZ0C0007~0 created

Interface access functions from dynamic library dbmssslib.dll loaded.

(IMP) INFO: ExeFastLoad failed with <2: BCP Commit failed:[2627] Violation of PRIMARY KEY constraint '/BIC/FZ0C0007~0'. Cannot insert duplicate key in object 'qbi./BIC/FZ0C0007'.

[3621] The statement has been terminated.>

(IMP) ERROR: ExeFastload: rc = 2

(DB) INFO: /BIC/FZ0C0007~010 created

(DB) INFO: /BIC/FZ0C0007~020 created

(DB) INFO: /BIC/FZ0C0007~030 created

(DB) INFO: /BIC/FZ0C0007~040 created

(DB) INFO: /BIC/FZ0C0007~050 created

(DB) INFO: /BIC/FZ0C0007~060 created

(DB) INFO: /BIC/FZ0C0007~070 created

(DB) INFO: /BIC/FZ0C0007~080 created

(DB) INFO: /BIC/FZ0C0007~P created

(DB) INFO: disconnected from DB

I think this Table is a PSA Table but can we go ahead or abort import process ?

thanks

Steven

[markus_doehr2 · Accepted solution]

> we want to do a system copy with Export / Import both System are on Windos 2k3 64bit with MSSQL.

> The Export running fine.

> Interface access functions from dynamic library dbmssslib.dll loaded.

> (IMP) INFO: ExeFastLoad failed with <2: BCP Commit failed:[2627] Violation of PRIMARY KEY constraint '/BIC/FZ0C0007~0'. > Cannot insert duplicate key in object 'qbi./BIC/FZ0C0007'.

Did you execute SMIGR_CREATE_DDL on the source system and put the resulting SQL files in the appropriate export directory?

Note 888210 - NetWeaver 7.0/7.10: System copy (supplementary note)

Also note that such database migrations are only supported if they are done by certified migration consultants, SAP will otherweise bill support for OSS problems you create.

Markus

[steven_bier]

Hi Markus,

yes we execute this report, but no *.Sql file was created.

Can we go ahead and recreate this table ?

Thanks

Steven