import_monitor (ABAP import error)

[Former Member]

I am getting an error while I was installation NW2004s its stuck on "Import ABAP" and getting error,

under windows 2003 server.. oracle 10g

here is import_monitor.log file

INFO: 2015-05-25 13:39:46

Import Monitor is started.

CONFIG: 2015-05-25 13:39:46

Application options:

dbCodepage=1100

dbType=ORA

extFiles=yes

importDirs=E:\ALPHA\EEC6\E1\Disk1\export1\EXP1;E:\ALPHA\EEC6\E2\Disk2\export2\EXP2;E:\ALPHA\EEC6\E3\Disk3\export3\EXP3;E:\ALPHA\EEC6\E4\Disk4\export4\EXP4;E:\ALPHA\EEC6\E5\MyDisc\Disk5\export5\EXP5;E:\ALPHA\EEC6\E6\MyDisc\Disk6\export6\EXP6;E:\ALPHA\EEC6\E6\MyDisc\Disk6\export6\EXP7;E:\ALPHA\EEC6\E6\MyDisc\Disk6\export6\EXP8;E:\ALPHA\EEC6\E6\MyDisc\Disk6\export6\EXP9;E:\ALPHA\EEC6\E6\MyDisc\Disk6\export6\EXP10;E:\ALPHA\EEC6\E6\MyDisc\Disk6\export6\EXP11

installDir=C:\PROGRA_1\SAPINS1\ERP\SYSTEM\ORA\CENTRAL\AS

jobNum=3

loadArgs= -stop_on_error

monitorTimeout=30

orderBy=

r3loadExe=C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe

sapinst=

trace=all

tskFiles=yes

CONFIG: 2015-05-25 13:39:46

List of packages with table structure: 'SAP0000'.

CONFIG: 2015-05-25 13:39:46

List of packages with views: 'SAPVIEW'.

TRACE: 2015-05-25 13:39:46 com.sap.inst.migmon.imp.ImportStandardTask preCreate

Parse of 'C:\PROGRA_1\SAPINS1\ERP\SYSTEM\ORA\CENTRAL\AS\DDLORA.TPL' template file is started.

INFO: 2015-05-25 13:39:46 com.sap.inst.migmon.imp.ImportStandardTask preCreate

Parse of 'C:\PROGRA_1\SAPINS1\ERP\SYSTEM\ORA\CENTRAL\AS\DDLORA.TPL' template file is successfully completed.

Primary key creation: after load.

Index creation: after load.

INFO: 2015-05-25 13:39:46

Data codepage 4103 is determined using TOC file 'E:\ALPHA\EEC6\E1\Disk1\export1\EXP1\DATA\SAPAPPL0.TOC' for package 'SAPAPPL0'.

INFO: 2015-05-25 13:39:49

Version table 'SVERS' is found in STR file 'E:\ALPHA\EEC6\E4\Disk4\export4\EXP4\DATA\SAPSDIC.STR' from package 'SAPSDIC'.

INFO: 2015-05-25 13:39:49

Data conversion tables 'DDNTF,DDNTF_CONV_UC,DDNTT,DDNTT_CONV_UC' are found in STR file 'E:\ALPHA\EEC6\E4\Disk4\export4\EXP4\DATA\SAPSDIC.STR' from package 'SAPSDIC'.

TRACE: 2015-05-25 13:39:49 com.sap.inst.migmon.LoadTask run

Loading of 'SAPSDIC' import package is started.

TRACE: 2015-05-25 13:39:49 com.sap.inst.migmon.LoadTask processPackage

Task file generation for 'SAPSDIC' import package:

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe -ctf I E:\ALPHA\EEC6\E4\Disk4\export4\EXP4\DATA\SAPSDIC.STR "C:\Program Files\sapinst_instdir\ERP\SYSTEM\ORA\CENTRAL\AS\DDLORA.TPL" SAPSDIC.TSK ORA -l SAPSDIC.log

TRACE: 2015-05-25 13:39:49 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPSDIC' import package into database:

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe -i SAPSDIC.cmd -dbcodepage 1100 -l SAPSDIC.log -stop_on_error

ERROR: 2015-05-25 14:33:39 com.sap.inst.migmon.LoadTask run

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

Process 'C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe -i SAPSDIC.cmd -dbcodepage 1100 -l SAPSDIC.log -stop_on_error' exited with return code 2.

For mode details see 'SAPSDIC.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: 2015-05-25 14:33:46

Cannot continue import because not all import packages with data conversion tables are loaded successfully.

WARNING: 2015-05-25 14:33:46

1 error(s) during processing of packages.

INFO: 2015-05-25 14:33:46

Import Monitor is stopped.

[Former Member · Accepted solution]

Provide the details from 'SAPSDIC.log'

[Former Member · Accepted solution]

Hi,

thanks for reply

It very big log file. so I am sending last phase

DbSl Trace: ORA-1452 occurred when executing SQL statement (parse error offset=34)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "F4UHLP~0" ON "F4UHLP" ( "MANDT", "USERNAME", "TABFIELD", "FIELDFIELD", "VALUE" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 1556384 NEXT 0000000080K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1452)

error message returned by DbSl:

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

(DB) INFO: disconnected from DB

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe: job finished with 1 error(s)

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe: END OF LOG: 20150525143339

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe: START OF LOG: 20150525151143

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe: version R7.00/V1.4

Compiled Apr 2 2006 23:20:35

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe -i SAPSDIC.cmd -dbcodepage 1100 -l SAPSDIC.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(DB) ERROR: DDL statement failed

(DROP INDEX "F4UHLP~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

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

DbSl Trace: ORA-1452 occurred when executing SQL statement (parse error offset=34)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "F4UHLP~0" ON "F4UHLP" ( "MANDT", "USERNAME", "TABFIELD", "FIELDFIELD", "VALUE" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 1556384 NEXT 0000000080K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1452)

error message returned by DbSl:

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

(DB) INFO: disconnected from DB

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe: job finished with 1 error(s)

C:\usr\sap\DEV\SYS\exe\nuc\NTI386\R3load.exe: END OF LOG: 20150525151144

[Former Member · Accepted solution]

This is the common note everyone will recommend.

Link: [https://service.sap.com/sap/support/notes/23237]

Also refer the previous post answered related to your issue.

Link: [;

Link: [;