cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ERROR:ORA-01452: cannot CREATE UNIQUE INDEX;duplicatekey

Former Member
0 Kudos

Sapguru's,

Details:

ECC 5.0

Oracle 10g

windows 32bit 2003

Unicode to unicode

intel 32bit

Operation: DI installation - systemcopy R3load method on target system.

After CI installation i have replaced latest R3load , R3trans.

Important: i am using 64bit system export on 32bit system(sourcesystem:ECC 5.0/10g/win 2003 64bit/AMD64)

Error at Step: 22 of 32 (Database Load)

Task bar status: running 1 waiting 0

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

Table:DDNTT_CONV_UC

Error Logs are: SAPSDIC , SAPP00L , SAPSSEXC.

SAPSDIC LOG:

initial:

F:\usr\sap\R30\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPSDIC.cmd -l C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPSDIC.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

End:

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) TABLESPACE PSAPR30 STORAGE (INITIAL 11632640 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

.............................................................................................

SAPPOOL LOG:

Initial:

F:\usr\sap\R30\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPPOOL.cmd -l C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPPOOL.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

End:

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "R3020090409020420 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "AMEXR30 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "AMEXR30"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 "

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

(DB) INFO: AANK created #20090409145037

(IMP) INFO: import of AANK completed (0 rows) #20090409145037

(DB) INFO: AANK~0 created #20090409145037

(DB) INFO: AANL created #20090409145038

(IMP) INFO: import of AANL completed (0 rows) #20090409145038

(DB) INFO: AANL~0 created #20090409145038

(DB) INFO: ATAB created #20090409145038

failed to read short nametab of table A (rc=32)

(CNVPOOL) conversion failed for row 0 of table VARKEY = 010100

(CNV) ERROR: data conversion failed. rc = 2

(DB) INFO: disconnected from DB

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

F:\usr\sap\R30\SYS\exe\run/R3load.exe: END OF LOG: 20090409145044

.....................................................................................

SAPSSEXC LOG:

Initial:

F:\usr\sap\R30\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPSSEXC.cmd -l C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPSSEXC.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

End:

DB) INFO: DM45T~0 created #20090409152458

(DB) INFO: DM46S created #20090409152458

(IMP) INFO: import of DM46S completed (1747 rows) #20090409152458

(DB) INFO: DM46S~0 created #20090409152458

(DB) INFO: DM46S~A created #20090409152458

(DB) INFO: DOKCLU created #20090409152458

myCluster (55.18.Imp): 686: error when retrieving alternate nametab description for physical table DOKCLU.

myCluster (55.18.Imp): 687: return code received from nametab is 32

myCluster (55.18.Imp): 294: error when retrieving physical nametab for table DOKCLU.

(CNV) ERROR: data conversion failed. rc = 2

(DB) INFO: disconnected from DB

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

F:\usr\sap\R30\SYS\exe\run/R3load.exe: END OF LOG: 20090409152511

........................................................................................

I collected information:

Note: 11369 & 23237 ( for deleting duplicate keys)

Solution

Determine the keys:

DESCRIBE sapr3.<table name>;

???Fields with entry NOT NULL

Determine the duplicate records (summary diplay of the records

with multiple key values):

select alldata.rowid, alldata.*

from <table> alldata,

(SELECT <keycolumn 1>, ..., <keycolumn n>

FROM <table>

GROUP BY <keycolumn 1>, ..., <keycolumn n>

HAVING COUNT(*) > 1) keydata

where alldata.<keycolumn 1>=keydata.<keycolumn 1>

and ...

and alldata.<keycolumn n>=keydata.<keycolumn n>;

-


I have written select statement for DDNTT_CONV_UC table and executed that selected 130027 records but in my windows it showed only 12 records( then i got confused with 12records showing & statement it showing like 130027 on SQL windown OS level).

I didnt delete any records.

As for my friend suggestion i have truncated table then i pressed retry option on SAPINST.

I have set environmental variable like:I18N_NAMETAB_TIMESTAMPS=IGNORE;

Then i got once again error at 22 of 32 ( running 3 waiting 0)

sampe log names: SAPSDIC,SAPPOOL,SAPSSEXC.

SAPSDIC LOG:

Initial Error is same like error like ORA-1403

End Error with different table not DDNTT_CONV_UC.

Then i trucated another table then i started sapinst , once again i got error like above with same logs but different table .

But i checked the previously trucated table with select count(*) from SAPR30.DDNTT_CONV_UC - it showing count = 0.

At last i drop all previous error tables then i started sapinst then i got same error like droped table(error at 22 of 32 , running 3 waiting 0)

...............................................................................................

My Questions:

1.Can i build Ecc5.0/10g/win 32 2003/intel server(target system) with 64 bit export (ECC5.0/10g/win 64 2003 64bit/AMD 64 bit) (source system)?

2. Initial error : ORA-1403 when accessing table SAPUSER -

a. Why above error will come?

b. How to rectify this error?

c. Is it effect to SAP or Is it genral warining or can i discard it?

3. End error:ORA-1452 Cannot create Unique index:duplicate keys found

a. do i need to follow Note:11369 for all tables (which has same error like above)?

b. do i need to truncate the table or after doing truncate table why it is not load the data ?

c. Is there any best solution for my errors?

Really appreciated - if anybody gives guideliness for my above errors.

..................................................

Problem is : I cannot do export on source system once again. I have to use same export which i have(but i didnt get any problems when doing export earlier)

source system character set selected:WE8DEC/codepage:4103

Target system character set defaultly took by SAP is:UTF8 /codepage:4103

Thanks Advance.

Regards,

Bhaskar

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

>>1.Can i build Ecc5.0/10g/win 32 2003/intel server(target system) with 64 bit

>> export (ECC5.0/10g/win 64 2003 64bit/AMD 64 bit) (source system)?

yes, you can

>>2. Initial error : ORA-1403 when accessing table SAPUSER -

>>a. Why above error will come?

because the exported data contains duplicate primary keys where it should not

have them

>>b. How to rectify this error?

see answer in <a href="http://1.Can i build Ecc5.0/10g/win 32 2003/intel server(target system) with 64 bit export (ECC5.0/10g/win 64 2003 64bit/AMD 64 bit) (source system)?">this thread</a>

>>c. Is it effect to SAP or Is it genral warining or can i discard it?

you have to fix it anyway.

>>3. End error:ORA-1452 Cannot create Unique index:duplicate keys found

>>a. do i need to follow Note:11369 for all tables (which has same error like above)?

yes

>>b. do i need to truncate the table or after doing truncate table why it is not load the data ?

that depends on the table and the double content. normaly you have to delete the duplicate rows.

>>c. Is there any best solution for my errors?

you already refer the right note.

Peter

Former Member
0 Kudos

Peter,

Thanks very much for your answer .

Regards,

bhaskar

Former Member
0 Kudos

Hi Peter,

I have truncated each and every table which are giving ORA-1452 error.

I got duplicate in 68 tables. For all tables i truncated.

Then i retry sapinst then i got below error logs;

LOG FILES:

1.SAPSSEXC.log

2. SAP000L.log

..........................................................

1. SAPSSEXC log

F:\usr\sap\R30\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPSSEXC.cmd -l C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPSSEXC.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "R3020090409020420 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "AMEXR30 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "AMEXR30"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 "

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

(DB) INFO: DOKCLU deleted/truncated

myCluster (55.18.Imp): 686: error when retrieving alternate nametab description for physical table DOKCLU.

myCluster (55.18.Imp): 687: return code received from nametab is 32

myCluster (55.18.Imp): 294: error when retrieving physical nametab for table DOKCLU.

(CNV) ERROR: data conversion failed. rc = 2

(DB) INFO: disconnected from DB

...............................................................

2.SAPP00L.log

F:\usr\sap\R30\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPSSEXC.cmd -l C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\UC\DB/SAPSSEXC.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "R3020090409020420 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "AMEXR30 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "AMEXR30"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 "

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

(DB) INFO: ATAB deletd/truncated

failed to read short nametab of table A (rc=32)

(CNVPOOL) conversion failed for row 0 of table VARKEY = 010100

(CNV) ERROR: data conversion failed. rc = 2

(DB) INFO: disconnected from DB

.............................................................................

I got information from Service market place:

Note for lOG 1 above stated:421554

Stating above Note - Use lateset R3load - but i am using latest R3load of patch level 96 & i have done kernel upgradation after installing CI

................................................................................

My Questions:

1. Can you please give me any guidence or solution or notes to me to resolve this issue?

2.Truncate table will be gives the problem?- i am not able delete each & every table duplicate records manually because lot of duplicate records available in each and every table thats why i truncated effected table .

Thanks,

Bhaskar Rapelli