Re-indexing your SFM following network disconnection to fix corrupt index errors (Error 7017)

Error 7017 | Corrupt indexing error upon logging in to SFM

Problem

An SupplierSadsTable: Error 7017: Corrupt .ADI, .CDX, or .IDX index error pops up upon logging in to SFM.



Environment

SFM

Solution

A re-indexing would need to be carried out.

Before proceeding with the re-indexing, it is important that all users are logged out of both SFM & SIMS
  1. Go to SFM Administration > Reindex.
  2. Tick the System files box
  3. Click Reindex




Cause

This error normally occurs when there is a constant network disconnection.


    • Related Articles

    • How to Reindex SFM

      The Reindex Application Data files option performs a Reindex of those data files related only to the particular company which is in use. These data files include the company and system data files. This process also clears the Number of Logins field ...
    • How to Reindex POS

      Reindex solves most of the issues that can be caused by a power cut, or any other event that may affect the functionality of the POS. There are 2 ways to reindex POS. Method 1: Via the Toolbar You can go to Admin>Reindex: The below will pop up: ...
    • How to Reindex SIMS

      Reindex is mostly used to fix corrupted indices. If they are not repaired, the utility will indicate which databases need attention.  It is important that all users are out of SIMS (and SFM if applicable) or else an alert will pop up that another ...
    • Error: "Error reading file ... CDX file" given when using SIMS

      Problem Error: "Error reading file ... CDX file" given when using SIMS. The error would quote a file with the extension '.cdx'. Environment SIMS Solution A restart of SIMS and PC will generally resolve this error. If you are using Wi-Fi, switch to a ...
    • Error: "Allocation in Progress for Entity" when allocating entries in SFM

      Problem Error: "Allocation in Progress for Entity" Environment SFM Purchase or Sales Unallocated Entries Solution Go to Client (Current Year > Sales > Client Maintenance ) or Supplier List (Current Year > Purchases > Supplier Maintenance) Highlight ...