on 11-10-2011 7:36 AM
I encountered the error below when I try to import system copy in the import ABAP step.
WARNING[E] 2011-11-10 13:30:23.562
CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.
ERROR 2011-11-10 13:30:25.15
FCO-00011 The step runMigrationMonitor with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|runMigrationMonitor was executed with status ERROR .
The error in import.log is as below:
ERROR: 2011-11-10 11:04:15 com.sap.inst.migmon.LoadTask run
Loading of 'SAPAPPL0' import package is interrupted with R3load error.
Process 'D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -loadprocedure fast' exited with return code 2.
For mode details see 'SAPAPPL0.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
ERROR: 2011-11-10 13:30:09 com.sap.inst.migmon.LoadTask run
Loading of 'SAPAPPL2' import package is interrupted with R3load error.
Process 'D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.log -loadprocedure fast' exited with return code 2.
For mode details see 'SAPAPPL2.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
WARNING: 2011-11-10 13:30:20
Cannot start import of packages with views because not all import packages with tables are loaded successfully.
WARNING: 2011-11-10 13:30:20
18 error(s) during processing of packages.
INFO: 2011-11-10 13:30:20
Import Monitor is stopped.
Hi,
Can you tel us the current version of the SAP of which you are trying to do system copy, what is a code page of your source system and R3load version using for exporting the system.
For checking the R3load version, just goto command prompt and run R3LOAD -version.
Also if you check the previous log and the current log, you error has been changed. So create the DDL statement then try to import the system. For you reference kindly go through the SAP note: Note 771209 - NetWeaver 04: System copy (supplementary note)
Thanks,
Anil Bhandary
Edited by: Anil Bhandary on Nov 14, 2011 12:23 PM
Edited by: Anil Bhandary on Nov 14, 2011 12:24 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Actually even if I did not upgrade the r3load version, I still get the same error. Once I run the system copy import, the error will occur under the process 'Import ABAP', step 6. It will show Import Monitor jobs: running 9, waiting 1, completed 5, failed 4, total 19. It will just keep on with this screen and I'm not sure whether it is running because even I leave it to run for 2 days, the message will still remain the same. Therefore, I'm not sure actually which process is stuck as there is not much message from the log.
I'm doing heterogenous system copy because there will be change of OS and DB version. From Windows 2005 to 2008, MSSQL 2005 to 2008. Previously, I also tried to generate the DDL statement, however, no statement is generated. I can export and import successfully before I format the server, I also don't know what is missing or went wrong for this time.
I encountered the error below when I tried to import the system copy. I already updated the R3load, but is still the same error I encountered. Below is error from one of the log file. How should I tackle this problem?
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20111117093810
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#23 $ SAP
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4
Compiled Jul 10 2011 21:34:55
process id 2312
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -ctf I D:\Installer\export file\ABAP\DATA\SAPCLUST.STR C:\Program Files\sapinst_instdir\NW04S\LM\COPY\MSS\SYSTEM\CENTRAL\AS-ABAP\DDLMSS.TPL SAPCLUST.TSK MSS -l SAPCLUST.log
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: job completed
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20111117093810
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20111117093811
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#23 $ SAP
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4
Compiled Jul 10 2011 21:34:55
process id 3764
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -i SAPCLUST.cmd -dbcodepage 4103 -l SAPCLUST.log -loadprocedure fast
(DB) INFO: connected to DB
(GSI) INFO: dbname = "DEVSWIFSTEST "
(GSI) INFO: vname = "MSSQL "
(GSI) INFO: hostname = "SWIFSTEST "
(GSI) INFO: sysname = "Windows NT"
(GSI) INFO: nodename = "SWIFSTEST"
(GSI) INFO: release = "6.1"
(GSI) INFO: version = "7601 Service Pack 1"
(GSI) INFO: machine = "2x AMD64 Level 6 (Mod 44 Step 2)"
(DB) INFO: AABLG created
(DB) INFO: AABLG~0 created
Interface access functions from dynamic library dbmssslib.dll loaded.
(IMP) INFO: import of AABLG completed (1 rows) #20111117093844
(DB) INFO: CDCLS created
(DB) INFO: CDCLS~0 created
(IMP) INFO: ExeFastLoad failed with <2: BCP Commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'CDCLS~0'. Cannot i>
(IMP) ERROR: ExeFastload: rc = 2
(DB) INFO: CLU4 created
(DB) INFO: CLU4~0 created
(IMP) INFO: import of CLU4 completed (0 rows) #20111117093844
(DB) INFO: CLUSTERVER created
(DB) INFO: CLUSTERVER~0 created
(IMP) INFO: import of CLUSTERVER completed (0 rows) #20111117093844
(DB) INFO: CLUTAB created
(DB) INFO: CLUTAB~0 created
(IMP) INFO: import of CLUTAB completed (0 rows) #20111117093844
(DB) INFO: CVEP1 created
(DB) INFO: CVEP1~0 created
(IMP) INFO: import of CVEP1 completed (0 rows) #20111117093844
(DB) INFO: CVEP2 created
(DB) INFO: CVEP2~0 created
(IMP) INFO: import of CVEP2 completed (0 rows) #20111117093844
(DB) INFO: CVER1 created
(DB) INFO: CVER1~0 created
(IMP) INFO: import of CVER1 completed (0 rows) #20111117093844
(DB) INFO: CVER2 created
(DB) INFO: CVER2~0 created
(IMP) INFO: import of CVER2 completed (0 rows) #20111117093845
(DB) INFO: CVER3 created
(DB) INFO: CVER3~0 created
(IMP) INFO: import of CVER3 completed (0 rows) #20111117093845
(DB) INFO: CVER4 created
(DB) INFO: CVER4~0 created
(IMP) INFO: import of CVER4 completed (0 rows) #20111117093845
(DB) INFO: CVER5 created
(DB) INFO: CVER5~0 created
(IMP) INFO: import of CVER5 completed (0 rows) #20111117093845
(DB) INFO: DOKCL created
(DB) INFO: DOKCL~0 created
(IMP) INFO: import of DOKCL completed (0 rows) #20111117093845
(DB) INFO: DSYCLV created
(DB) INFO: DSYCLV~0 created
(IMP) INFO: import of DSYCLV completed (0 rows) #20111117093845
(DB) INFO: DSYO1 created
(DB) INFO: DSYO1~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DSYO1~0'. Cannot i>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: DSYO2 created
(DB) INFO: DSYO2~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DSYO2~0'. Cannot i>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: DSYO3 created
(DB) INFO: DSYO3~0 created
(IMP) INFO: import of DSYO3 completed (0 rows) #20111117093845
(DB) INFO: EDI30C created
(DB) INFO: EDI30C~0 created
(IMP) INFO: import of EDI30C completed (0 rows) #20111117093845
(DB) INFO: EDI40 created
(DB) INFO: EDI40~0 created
(IMP) INFO: import of EDI40 completed (0 rows) #20111117093845
(DB) INFO: EDIDOC created
(DB) INFO: EDIDOC~0 created
(IMP) INFO: import of EDIDOC completed (0 rows) #20111117093845
(DB) INFO: EPIDXB created
(DB) INFO: EPIDXB~0 created
(IMP) INFO: import of EPIDXB completed (0 rows) #20111117093845
(DB) INFO: EPIDXC created
(DB) INFO: EPIDXC~0 created
(IMP) INFO: import of EPIDXC completed (0 rows) #20111117093845
(DB) INFO: GLS2CLUS created
(DB) INFO: GLS2CLUS~0 created
(IMP) INFO: import of GLS2CLUS completed (0 rows) #20111117093845
(DB) INFO: IMPREDOC created
(DB) INFO: IMPREDOC~0 created
(IMP) INFO: import of IMPREDOC completed (0 rows) #20111117093845
(DB) INFO: J_CLU created
(DB) INFO: J_CLU~0 created
(IMP) INFO: import of J_CLU completed (0 rows) #20111117093845
(DB) INFO: KOCLU created
(DB) INFO: KOCLU~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'KOCLU~0'. Cannot i>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: MWOFF_CL created
(DB) INFO: MWOFF_CL~0 created
(IMP) INFO: import of MWOFF_CL completed (0 rows) #20111117093846
(DB) INFO: PCDCLS created
(DB) INFO: PCDCLS~0 created
(IMP) INFO: import of PCDCLS completed (0 rows) #20111117093846
(DB) INFO: PRCD_CLUST created
(DB) INFO: PRCD_CLUST~0 created
(IMP) INFO: import of PRCD_CLUST completed (0 rows) #20111117093846
(DB) INFO: REGUC created
(DB) INFO: REGUC~0 created
(IMP) INFO: ExeFastLoad failed with <2: BCP Commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'REGUC~0'. Cannot i>
(IMP) ERROR: ExeFastload: rc = 2
(DB) INFO: RFBLG created
(DB) INFO: RFBLG~0 created
(IMP) INFO: ExeFastLoad failed with <2: BCP Commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'RFBLG~0'. Cannot i>
(IMP) ERROR: ExeFastload: rc = 2
(DB) INFO: RFMHN created
(DB) INFO: RFMHN~0 created
(IMP) INFO: import of RFMHN completed (0 rows) #20111117093848
(DB) INFO: RKEPI created
(DB) INFO: RKEPI~0 created
(IMP) INFO: import of RKEPI completed (0 rows) #20111117093848
(DB) INFO: SFHOA created
(DB) INFO: SFHOA~0 created
(IMP) INFO: import of SFHOA completed (390 rows) #20111117093849
(DB) INFO: SFHYT created
(DB) INFO: SFHYT~0 created
(IMP) INFO: import of SFHYT completed (0 rows) #20111117093852
(DB) INFO: TESCL created
(DB) INFO: TESCL~0 created
(IMP) INFO: import of TESCL completed (0 rows) #20111117093858
(DB) INFO: UMG_TEST_C created
(DB) INFO: UMG_TEST_C~0 created
(IMP) INFO: import of UMG_TEST_C completed (0 rows) #20111117093901
(DB) INFO: UMG_TEST_F created
(DB) INFO: UMG_TEST_F~0 created
(IMP) INFO: import of UMG_TEST_F completed (0 rows) #20111117093901
(DB) INFO: VBCLU created
(DB) INFO: VBCLU~0 created
(IMP) INFO: import of VBCLU completed (0 rows) #20111117093901
(DB) INFO: VBFCL created
(DB) INFO: VBFCL~0 created
(IMP) INFO: import of VBFCL completed (0 rows) #20111117093901
(DB) INFO: VBLOG created
(DB) INFO: VBLOG~0 created
(IMP) INFO: import of VBLOG completed (0 rows) #20111117093901
(DB) INFO: VERCLUSTER created
(DB) INFO: VERCLUSTER~0 created
(IMP) INFO: import of VERCLUSTER completed (0 rows) #20111117093901
(DB) INFO: VER_CLUSTR created
(DB) INFO: VER_CLUSTR~0 created
(IMP) INFO: import of VER_CLUSTR completed (0 rows) #20111117093902
(DB) INFO: VTEST10 created
(DB) INFO: VTEST10~0 created
(IMP) INFO: import of VTEST10 completed (0 rows) #20111117093902
(DB) INFO: disconnected from DB
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 6 error(s)
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20111117093902
Dear Swiber,
i faced the same problem during Unicode conversion project, in the import phase.
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'QCMT030A~0'. Canno>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: QCMT030X deleted/truncated
can you please tell me how did you solve your problem??
best regards,
Ehab Magdy
Hello,
Could you post the latest contents of SAPAPPL0.log and SAPAPPL2.log ?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Some of the error in SAPAPPL0:
(DB) ERROR: DDL statement failed
(CREATE TABLE [ZVSL_MASTER] ( [MANDT] nvarchar(3) NOT NULL , [VESSEL_NAME] nvarchar(20) NOT NULL , [LOEKZ] nvarchar(1) NOT NULL , [ERNAM] nvarchar(12) NOT NULL , [ERDAT] nvarchar(8) NOT NULL , [AENAM] nvarchar(12) NOT NULL , [AEDAT] nvarchar(8) NOT NULL ) WITH ( DATA_COMPRESSION = ROW ) exec sp_bindefault 'numc3_default','ZVSL_MASTER.MANDT'
exec sp_bindefault 'str_default','ZVSL_MASTER.VESSEL_NAME'
exec sp_bindefault 'str_default','ZVSL_MASTER.LOEKZ'
exec sp_bindefault 'str_default','ZVSL_MASTER.ERNAM'
exec sp_bindefault 'numc8_default','ZVSL_MASTER.ERDAT'
exec sp_bindefault 'str_default','ZVSL_MASTER.AENAM'
exec sp_bindefault 'numc8_default','ZVSL_MASTER.AEDAT'
)
DbSlExecute: rc = 99
(SQL error 7738)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot enable compression for object 'ZVSL_MASTER'. Only SQL Server Enterprise Edition supports compression.
(DB) ERROR: DDL statement failed
(ALTER TABLE [ZVSL_MASTER] ADD CONSTRAINT [ZVSL_MASTER~0] PRIMARY KEY CLUSTERED ( [MANDT], [VESSEL_NAME] ) )
DbSlExecute: rc = 99
(SQL error 4902)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "ZVSL_MASTER" because it does not exist or you do not have permissions.
(IMP) INFO: InitFastLoad failed with <2: bcp_init failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'ZVSL_MASTER'.>
(IMP) INFO: DBSL will be used
(IMP) ERROR: DbSlEndModify failed
rc = 103, table "ZVSL_MASTER"
(SQL error 208)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'ZVSL_MASTER'.
(DB) ERROR: DDL statement failed
(CREATE TABLE [ZVSL_M_CONTROL] ( [MANDT] nvarchar(3) NOT NULL , [VESSEL_NAME] nvarchar(20) NOT NULL , [KOSTL] nvarchar(10) NOT NULL , [LTEXT] nvarchar(40) NOT NULL , [LOEKZ] nvarchar(1) NOT NULL , [ERNAM] nvarchar(12) NOT NULL , [ERDAT] nvarchar(8) NOT NULL , [AENAM] nvarchar(12) NOT NULL , [AEDAT] nvarchar(8) NOT NULL ) WITH ( DATA_COMPRESSION = ROW ) exec sp_bindefault 'numc3_default','ZVSL_M_CONTROL.MANDT'
exec sp_bindefault 'str_default','ZVSL_M_CONTROL.VESSEL_NAME'
exec sp_bindefault 'str_default','ZVSL_M_CONTROL.KOSTL'
exec sp_bindefault 'str_default','ZVSL_M_CONTROL.LTEXT'
exec sp_bindefault 'str_default','ZVSL_M_CONTROL.LOEKZ'
exec sp_bindefault 'str_default','ZVSL_M_CONTROL.ERNAM'
exec sp_bindefault 'numc8_default','ZVSL_M_CONTROL.ERDAT'
exec sp_bindefault 'str_default','ZVSL_M_CONTROL.AENAM'
exec sp_bindefault 'numc8_default','ZVSL_M_CONTROL.AEDAT'
)
DbSlExecute: rc = 99
(SQL error 7738)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot enable compression for object 'ZVSL_M_CONTROL'. Only SQL Server Enterprise Edition supports compression.
(DB) ERROR: DDL statement failed
(ALTER TABLE [ZVSL_M_CONTROL] ADD CONSTRAINT [ZVSL_M_CONTROL~0] PRIMARY KEY CLUSTERED ( [MANDT], [VESSEL_NAME], [KOSTL] ) )
DbSlExecute: rc = 99
(SQL error 4902)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "ZVSL_M_CONTROL" because it does not exist or you do not have permissions.
(IMP) INFO: InitFastLoad failed with <2: bcp_init failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'ZVSL_M_CONTROL'.>
(IMP) INFO: DBSL will be used
(IMP) ERROR: DbSlEndModify failed
rc = 103, table "ZVSL_M_CONTROL"
(SQL error 208)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'ZVSL_M_CONTROL'.
(DB) INFO: disconnected from DB
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 48700 error(s)
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20111110110414
Some of the error in SAPAPPL2:
(DB) ERROR: DDL statement failed
(CREATE TABLE [WWWLANGRES] ( [RELID] nvarchar(2) NOT NULL , [OBJID] nvarchar(40) NOT NULL , [LANGU] nvarchar(1) NOT NULL , [NAME] nvarchar(50) NOT NULL , [VALUE] nvarchar(250) NOT NULL ) WITH ( DATA_COMPRESSION = ROW ) exec sp_bindefault 'str_default','WWWLANGRES.RELID'
exec sp_bindefault 'str_default','WWWLANGRES.OBJID'
exec sp_bindefault 'str_default','WWWLANGRES.LANGU'
exec sp_bindefault 'str_default','WWWLANGRES.NAME'
exec sp_bindefault 'str_default','WWWLANGRES.VALUE'
)
DbSlExecute: rc = 99
(SQL error 7738)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot enable compression for object 'WWWLANGRES'. Only SQL Server Enterprise Edition supports compression.
(DB) ERROR: DDL statement failed
(ALTER TABLE [WWWLANGRES] ADD CONSTRAINT [WWWLANGRES~0] PRIMARY KEY CLUSTERED ( [RELID], [OBJID], [LANGU], [NAME] ) )
DbSlExecute: rc = 99
(SQL error 4902)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "WWWLANGRES" because it does not exist or you do not have permissions.
(IMP) INFO: InitFastLoad failed with <2: bcp_init failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'WWWLANGRES'.>
(IMP) INFO: DBSL will be used
(IMP) ERROR: DbSlEndModify failed
rc = 103, table "WWWLANGRES"
(SQL error 208)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'WWWLANGRES'.
(DB) ERROR: DDL statement failed
(CREATE TABLE [WWWPARAMS] ( [RELID] nvarchar(2) NOT NULL , [OBJID] nvarchar(40) NOT NULL , [NAME] nvarchar(50) NOT NULL , [VALUE] nvarchar(250) NOT NULL ) WITH ( DATA_COMPRESSION = ROW ) exec sp_bindefault 'str_default','WWWPARAMS.RELID'
exec sp_bindefault 'str_default','WWWPARAMS.OBJID'
exec sp_bindefault 'str_default','WWWPARAMS.NAME'
exec sp_bindefault 'str_default','WWWPARAMS.VALUE'
)
DbSlExecute: rc = 99
(SQL error 7738)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot enable compression for object 'WWWPARAMS'. Only SQL Server Enterprise Edition supports compression.
(DB) ERROR: DDL statement failed
(ALTER TABLE [WWWPARAMS] ADD CONSTRAINT [WWWPARAMS~0] PRIMARY KEY CLUSTERED ( [RELID], [OBJID], [NAME] ) )
DbSlExecute: rc = 99
(SQL error 4902)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "WWWPARAMS" because it does not exist or you do not have permissions.
(IMP) INFO: InitFastLoad failed with <2: bcp_init failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'WWWPARAMS'.>
(IMP) INFO: DBSL will be used
(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed
rc = 103, table "WWWPARAMS"
(SQL error 208)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'WWWPARAMS'.
(DB) ERROR: DDL statement failed
(CREATE TABLE [WWWREPS] ( [NAME] nvarchar(40) NOT NULL ) WITH ( DATA_COMPRESSION = ROW ) exec sp_bindefault 'str_default','WWWREPS.NAME'
)
DbSlExecute: rc = 99
(SQL error 7738)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot enable compression for object 'WWWREPS'. Only SQL Server Enterprise Edition supports compression.
(DB) ERROR: DDL statement failed
(ALTER TABLE [WWWREPS] ADD CONSTRAINT [WWWREPS~0] PRIMARY KEY CLUSTERED ( [NAME] ) )
DbSlExecute: rc = 99
(SQL error 4902)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "WWWREPS" because it does not exist or you do not have permissions.
(IMP) INFO: import of WWWREPS completed (0 rows) #20111110133006
(DB) INFO: disconnected from DB
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 103118 error(s)
D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20111110133007
Hello,
First we should be sure that we are using latest R3load kernel file.
And it seems that you didn't install the support Edition of SQL Server. Did you install the SQL Server software using SAP SQL DVDs ? Error message suggests that you might have install the standard edition not the enterprise edition.
Please verify.
Thanks
I had changed the MSSQL to enterprise version and upgrade the r3load. However, there is still error.
Error in sapinst:
INFO 2011-11-11 12:08:22.345
Execution of the command "D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -dbcodepage 4103 -i test_MIGKEY.cmd -l test_MIGKEY.log -K" finished with return code 0. Output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
INFO 2011-11-11 12:08:22.454
Execute step createPropertyFileForMigrationMonitor of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0
INFO 2011-11-11 12:08:22.517
Creating file C:\Program Files\sapinst_instdir\NW04S\LM\COPY\MSS\SYSTEM\CENTRAL\AS-ABAP\import_monitor_cmd.properties.
INFO 2011-11-11 12:08:22.611
Execute step exitForMigrationMonitor of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0
INFO 2011-11-11 12:08:22.736
Execute step runMigrationMonitor of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0
INFO 2011-11-11 12:08:22.814
Switched to user: devadm.
INFO 2011-11-11 12:08:22.829
Creating file C:\Program Files\sapinst_instdir\NW04S\LM\COPY\MSS\SYSTEM\CENTRAL\AS-ABAP\import_monitor.java.log.
INFO 2011-11-11 12:08:22.829
Switched to user: devadm.
INFO 2011-11-11 12:08:22.829
Working directory changed to C:\Program Files\sapinst_instdir\NW04S\LM\COPY\MSS\SYSTEM\CENTRAL\AS-ABAP.
INFO 2011-11-11 12:08:22.845
Output of C:\j2sdk1.4.2_33-x64\bin\java.exe -classpath migmon.jar -showversion -Xmx1024m com.sap.inst.migmon.imp.ImportMonitor -sapinst is written to the logfile import_monitor.java.log.
Error is SAPAPPL1:
(DB) INFO: /BDL/CUST_TREE_T created
(DB) INFO: /BDL/CUST_TREE_T~0 created
Interface access functions from dynamic library dbmssslib.dll loaded.
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BDL/CUST_TREE_T~0>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BDL/DEST created
(DB) INFO: /BDL/DEST~0 created
(IMP) INFO: import of /BDL/DEST completed (0 rows) #20111111121037
(DB) INFO: /BDL/HEAD created
(DB) INFO: /BDL/HEAD~0 created
(IMP) INFO: import of /BDL/HEAD completed (0 rows) #20111111121037
(DB) INFO: /BDL/INTSESS created
(DB) INFO: /BDL/INTSESS~0 created
(IMP) INFO: import of /BDL/INTSESS completed (0 rows) #20111111121037
(DB) INFO: /BDL/LOCKED created
(DB) INFO: /BDL/LOCKED~0 created
(IMP) INFO: import of /BDL/LOCKED completed (0 rows) #20111111121037
(DB) INFO: /BDL/MAINTAIN created
(DB) INFO: /BDL/MAINTAIN~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BDL/MAINTAIN~0'. >
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BDL/MSGLOG created
(DB) INFO: /BDL/MSGLOG~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BDL/MSGLOG~0'. Ca>
(IMP) ERROR: EndFastload: rc = 2
Error in SAPAPPL2:
(DB) INFO: /BEV3/CHRGVERW created
(DB) INFO: /BEV3/CHRGVERW~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGVERW~0'.>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGVKORG created
(DB) INFO: /BEV3/CHRGVKORG~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGVKORG~0'>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGVTWEG created
(DB) INFO: /BEV3/CHRGVTWEG~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGVTWEG~0'>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGVWDVB created
(DB) INFO: /BEV3/CHRGVWDVB~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGVWDVB~0'>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGVWVORG created
(DB) INFO: /BEV3/CHRGVWVORG~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGVWVORG~0>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGWAERK created
(DB) INFO: /BEV3/CHRGWAERK~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGWAERK~0'>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGXXXX created
(DB) INFO: /BEV3/CHRGXXXX~0 created
(IMP) INFO: import of /BEV3/CHRGXXXX completed (0 rows) #20111114105047
(DB) INFO: /BEV3/CHRGZEIT created
(DB) INFO: /BEV3/CHRGZEIT~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGZEIT~0'.>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGZHLBDG created
(DB) INFO: /BEV3/CHRGZHLBDG~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGZHLBDG~0>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGZHLSP created
(DB) INFO: /BEV3/CHRGZHLSP~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGZHLSP~0'>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGZHLWG created
(DB) INFO: /BEV3/CHRGZHLWG~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGZHLWG~0'>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHRGZNSCHL created
(DB) INFO: /BEV3/CHRGZNSCHL~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHRGZNSCHL~0>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHTABA created
(DB) INFO: /BEV3/CHTABA~0 created
(IMP) INFO: EndFastLoad failed with <2: BCP commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHTABA~0'. C>
(IMP) ERROR: EndFastload: rc = 2
(DB) INFO: /BEV3/CHTABLE created
(DB) INFO: /BEV3/CHTABLE~0 created
(IMP) INFO: ExeFastLoad failed with <2: BCP Commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/BEV3/CHTABLE~0'. >
(IMP) ERROR: ExeFastload: rc = 2
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.