Re-indexing & Repairing EXACT Data

Before you start

1. Print this page, using the 'Print' button in the header of the Help.
2. Make a note of the system numbers for later checking, by looking in the Configure menu under practice Settings. Click the button, then write the existing numbers in the boxes below.

1. Make sure that all computers, including the one you are on, are logged out of EXACT.
2. Perform a network backup.
3. While you can sometimes rebuild just a single index to save time, often it is easier to just rebuild all indexes for a file. Depending on what index or indices your are rebuilding, the reindex process can be quite slow, and in most cases it would be best left to run overnight. If you are going to do this, make sure you disable any backups that may interfere; this is usually as simple as not putting a tape in.

To perform a Re-index

1. Start the EXACT re-indexing tool SoeAdmin. You may have an icon in the system tray at the bottom of the screen marked 'Server Administrator'; right-click on this, select "Administer Databases" from the menu, then follow the instructions from 2. below (all tables) or from 3. below (a single table index).
   Otherwise, from the Windows ‘Start’ menu click on ‘Run’, then 'Browse'. In the browser window, find the following directory/folder on the PC, where <drive> is the appropriate drive letter (usually C:)

   <drive>\Program Files\Software of Excellence\EXACT Server\
   
   Find and then double-click SoeAdmin.exe

   This will add the path and program name to the 'Run' dialog:

   

   Click the button.

2. A window similar to the following example:

   

3. If you are going to rebuild all indexes in a database, right-click the database, and select 'Repair Tables'.
   When the list of tables is displayed, click the 'ALL' button.
   Click the button; the selected table will be rebuilt and re-indexed.
   
   OR:
4. If you are instructed by SOE Support to reindex only a single table, click on the database name in the left pane, to expand the view, then click again on 'Tables' to show the tables, and once again on the table you need to rebuild the index for:

   

5. Right-click on the appropriate dataset and choose ‘Repair Table’ - this will fix any problems in the table as well as rebuild the indexes.

The re-index or repair should now start, and display a progress bar to indicate how far through the process it is. If you are leaving it overnight make sure that either YOU are the first one in or you leave a note so that no one uses the computers until you arrive.

After the Re-index

When the re-index has completed the dialogue box will disappear leaving only the SOE Administrator program running. Click on the to close this program. Next, to make sure that it has completed properly, log in to EXACT and display the system numbers as described in the "Before you start" section above. Check the numbers against the ones you wrote down earlier. If they are the same then you can continue using EXACT and allow any other terminals to log in as well.

If the numbers are different then you MUST click on the Reset System Numbers button, which is immediately below the system numbers. This will correct most of the numbers although you may still have to manually correct a couple. You can correct these by simply typing the numbers you wrote down into the appropriate boxes. When you have done this you can continue using EXACT and allow others to log in if they want.