7122 Local server failed to rebuild index

Advantage Error Guide

Problem: Advantage Local server attempted to rebuild a corrupt index but the parent table was not opened exclusively. If the Advantage Database Server shutdown abnormally, it is possible that some updates to index files were not saved to disk. The next time such an index is opened, Advantage will attempt to rebuild the index automatically. To do this the table (and index) must be opened exclusively or by Advantage Remote Server.

Solution: Open the parent table and the index exclusively or using remote server. In the future, avoid shutting down the Advantage Database Server when index files are still open or disable the caching of index updates by setting the MAX_CACHE_MEMORY configuration value to zero.