cancel
Showing results for 
Search instead for 
Did you mean: 

ora=1452

Former Member
0 Kudos

Hi all

when i am import the data foolowing error comes out,

also i am follws the sap note 11369.

but i cant understand how write the sql commond ,

please advise ,

(IMP) INFO: import of ZGL_GR completed (319 rows) #20080905215746

(DB) INFO: ZGL_GR~0 created #20080905215746

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "ZGL_GR~1" ON "ZGL_GR" ( "MANDT" , "GROUP_NAM" ) TABLESPACE PSAPDEV STORAGE (INITIAL 65536 NEXT 0000000640K 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

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20080905215746

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20080905231110

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\NW04\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL1.cmd -l C:\Program Files\sapinst_instdir\NW04\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL1.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20080905231110

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20080905231501

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\NW04\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL1.cmd -l C:\Program Files\sapinst_instdir\NW04\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL1.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): UTF8

Syslog: k xxx : rscpexcc 11

(rscpsumg) Please look also into "C:\Program Files\sapinst_instdir\NW04\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL1002.xml".

Syslog: k CQ3 : UMGSETTING& rscpexcc 12

(GSI) INFO: dbname = "DEV20080905060949 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "DEVSVR "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "DEVSVR"

(GSI) INFO: release = "5.2"

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

(GSI) INFO: machine = "2x Intel 80686 (Mod 15 Step 13)"

(DB) ERROR: DDL statement failed

(DROP INDEX "ZGL_GR~1")

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 occured when executing SQL statement (parse error offset = 35)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "ZGL_GR~1" ON "ZGL_GR" ( "MANDT" , "GROUP_NAM" ) TABLESPACE PSAPDEV STORAGE (INITIAL 65536 NEXT 0000000640K 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

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20080905231516

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20080906031452

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\NW04\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL1.cmd -l C:\Program Files\sapinst_instdir\NW04\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL1.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): UTF8

Syslog: k xxx : rscpexcc 11

(rscpsumg) Please look also into "C:\Program Files\sapinst_instdir\NW04\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL1003.xml".

Syslog: k CQ3 : UMGSETTING& rscpexcc 12

(GSI) INFO: dbname = "DEV20080905060949 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "DEVSVR "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "DEVSVR"

(GSI) INFO: release = "5.2"

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

(GSI) INFO: machine = "2x Intel 80686 (Mod 15 Step 13)"

(DB) ERROR: DDL statement failed

(DROP INDEX "ZGL_GR~1")

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 occured when executing SQL statement (parse error offset = 35)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "ZGL_GR~1" ON "ZGL_GR" ( "MANDT" , "GROUP_NAM" ) TABLESPACE PSAPDEV STORAGE (INITIAL 65536 NEXT 0000000640K 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

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20080906031502

05.10.2008 Page 1 of 2

Note 11369 - ORA-1452 during import after export from other system

Note Language: English Version: 15 Validity: Valid from 04.04.2007

thanks

with best reagds

jainendra

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

The DDL statement in your case is failing on a Z-table. Can you just follow the steps from SAP Note 23237 - duplicate keys, duplicate rows, duplicate records to find out if you have duplicate entries in your case?

Regards

Dhiraj

Answers (1)

Answers (1)

debasissahoo
Active Contributor
0 Kudos

Hi,

currently you can follow the notes as already provided above to solve the situation.

But FYI, this existence of duplicate record in a table might well be the reason because you probably missed "SE14 > Invalidate temporary tables" step (in the source system) of the homogeneous system copy guide. this deletes the temporary tables if exist.

Regards,

Debasis.