on 10-06-2008 7:07 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.