on 12-11-2007 5:09 PM
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
>>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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
11 | |
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.