cancel
Showing results for 
Search instead for 
Did you mean: 

ASE Error SQL1530 on system copy import

former_member117942
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

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

Answers (3)

Answers (3)

former_member117942
Participant
0 Kudos

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!

Former Member
0 Kudos

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

Former Member
0 Kudos

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