Skip to Content
avatar image
Former Member

.ADI index gets corrupted when deleting large amounts of records

We have a rather large table (93 fields, 25 indexes), which I can consistently corrupt an index on by deleting a large amount of records.

I currently have a table of 459938 records.

If I attempt to delete 426744 of these using SQL (delete from TABLE1 where FIELD1>='8'), I get the message "poQuery: Error 7200: AQE Error: State = HY000; NativeError = 7017; [iAnywhere Solutions][Advantage SQL][ASA] Error 7017: Corrupt .ADI, .CDX or .IDX index."

Running a further select statement I can see only 2825 records were removed before the error occurred. Retrying the delete query results in one further record being deleted every time the query is run before getting the error again.

Deleting and recreating the indexes will fix the problem until the delete query is run again.

The problem can be reproduced on various servers using ADS but I am currently using WindowsServer2008R2.

I can also reproduce a very similar problem by simply highlighting all the records in Arc32 and pressing the "Delete current or selected records" button.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 15, 2016 at 09:31 AM

    Thanks for confirming the issue. The engineering are working on it, but currently we cannot commit a time frame for the fix.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 04:11 PM

    Kev, please try it with the version

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Hakan Haslaman

      That does seem to be the cause of the problem!

      Is this something that will be fixed? We have software that relies on the index using DESCEND().

      Thanks for your efforts so far.