Skip to Content

Delete corrupt line in adt table

Sep 29, 2017 at 01:18 PM


avatar image

Hello. Because of a power failure on the server, the ADS from our customer stops working. Because off unexpectedly closing off the ADS one table contains a corrupt line. The records in this line has strange characters and dates in year 25342 ... (See attachment) When I open this table in arc32 and select this line, I've got a 7010 error (file read error). After some times it was possible to select the line in arc32 but deleting was not possible: also error 7010

Repair the table by using the tool ADSFIX didn't also fix the table. The corrupt line was still in the table.

After a few times we renamed the table in arc32. To our surprize the line was deleted :)

Question: is renaming the file in arc32 the solution to delete corrupt lines?

If not: what is the best way to delete such kind off line in a adt-table?

screenshot.png (208.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Michael Loop
Oct 02, 2017 at 08:24 PM

In general we would not expect renaming a table to clear corruption. It is difficult to know what happened for sure.

It sounds like an index may have been corrupted, resulting in different data in the index and the table. Possibly renaming the table forced a re-index when the table was accessed again.

Opening the table in Architect and selecting Table > Re-Index may have had the same effect.


Mike Loop
Senior Support Engineer
SAP Product Support

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I've never seen a corrupt index as cause for displaying corrupt data. In cases like this, I usually loop through the table and copy record by record to a new table. Not sure if renaming the table does the same.