on 03-13-2013 4:07 PM
Hi experts,
during the import of a heterogeneous system copy ECC6 EHP6 (ABAP based on NW 7.03) two errors occurred in phase ABAP IMPORT:
FIRST (file D021T.log):
S:\usr\sap\PTS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20130313155313
S:\usr\sap\PTS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#17 $ SAP
S:\usr\sap\PTS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Jan 16 2013 17:03:04
patchinfo (patches.h): (0.324) SYB: migration to sybase using unsorted unload/load (note 1734039)
process id 3596
S:\usr\sap\PTS\SYS\exe\uc\NTAMD64\R3load.exe -i D021T.cmd -dbcodepage 4103 -k 1G5fdEM50DaIrBzjt6TE5Pae -l D021T.log -c 99000000 -loadprocedure fast
(DB) INFO: connected to DB
(GSI) INFO: dbname = "PTSSAPERPTST "
(GSI) INFO: vname = "SYBASE "
(GSI) INFO: hostname = "saperptst "
(GSI) INFO: sysname = "Windows NT"
(GSI) INFO: nodename = "SAPERPTST"
(GSI) INFO: release = "6.1"
(GSI) INFO: version = "7601 Service Pack 1"
(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 45 Step 7)"
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file E:\SAPCD\Export_Sybase\ABAP\DB/SQLFiles.LST
(SQL) INFO: found E:\SAPCD\Export_Sybase\ABAP\DB/SQLFiles.LST
(SQL) INFO: Trying to open E:\SAPCD\Export_Sybase\ABAP\DB/SQLFiles.LST
(SQL) INFO: E:\SAPCD\Export_Sybase\ABAP\DB/SQLFiles.LST opened
(SQL) INFO: Searching for SQL file SSEXC.SQL
(SQL) INFO: SSEXC.SQL not found
(SQL) INFO: Searching for SQL file E:\SAPCD\Export_Sybase\ABAP\DB/SYB/SSEXC.SQL
(SQL) INFO: E:\SAPCD\Export_Sybase\ABAP\DB/SYB/SSEXC.SQL not found
(DB) ERROR: DDL statement failed
(DROP INDEX "D021T"."D021T~0")
DbSlExecute: rc = 103
(SQL error 3701)
error message returned by DbSl:
[ASE Error SQL3701]Cannot drop the index 'D021T.D021T~0', because it doesn't exist in the system catalogs.
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "D021T~0" ON "D021T" ( "PROG", "DYNR", "LANG", "FLDN" ) with sorted_data )
DbSlExecute: rc = 99
(SQL error 1530)
error message returned by DbSl:
[ASE Error SQL1530]Create index with sorted_data was aborted because of row out of order. Primary key of first out of order row is '"SAPMK23B", "7000", "E", "HEADER
HEADER__"'
(DB) INFO: disconnected from DB
S:\usr\sap\PTS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
S:\usr\sap\PTS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130313155330
SECOND (file SAPAPPL0_1.log):
(CREATE UNIQUE INDEX "ADRCS2~0" ON "ADRCS2" ( "CLIENT", "TABLENAME", "FIELDNAME", "OBJKEY", "DATE_FROM", "NATION" ) with sorted_data )
DbSlExecute: rc = 99
(SQL error 1530)
error message returned by DbSl:
[ASE Error SQL1530]Create index with sorted_data was aborted because of row out of order. Primary key of first out of order row is '"200", "T499S", "ADDRNUM", "200 Z007 ", "00010101", " "'
(DB) INFO: disconnected from DB
I doesn't see any problem in Table (and index) in source system (Win/MsSQL).
No sap note or forum talk about this problem, any idea?
Thaks a lot for help
Maurizio
Hi Maurizio,
Error 1530 occurs when you try to create an index with the sorted_data option on a column or columns containing data that is not in sorted order. When this error occurs, no index is created.
The sorted_data option speeds index creation only for clustered indexes or unique nonclustered indexes. Creating a nonunique, nonclustered index with the sorted_data option may succeed, but there is no improvement in performance.
What you should do
To create an index after getting a 1530 error, do one of the following:
1) Sort the data (using your standard operating system procedures), bcp it into the table, and then create the index with the sorted_data option.
2) Create the index without the sorted_data option.
Another alternative is to create the indexes once the migration is completed from dbacockpit.
For now you may skip it by setting the ign status for these index entries in respective .TSK files and proceed ahead with migration
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks too much Deepak Kori, i've set the ign status for these index entries in respective .TSK
and after the upgrade from transaction SE14 i created the indexes.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check whether you are using the latest kernel files... If not, please download the latest kernel patch, lib_dbsl, R3load, R3* files and try again.
Mostly it should fix your issue.
Thanks and Regards,
Vimal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mauizio,
I believe that this is because the data was supposed to be in sorted order. Thus it is expecting the rows to be in order. In this case it was not and therefore stops.
Regards,
Graham
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.