Error 3010: Unknown Alias Name Used with Field Name in Index Key

If you are able to open AbacusLaw or if another user is already logged in.

1. Have all other users exit AbacusLaw, Abacus MessageSlips, and Abacus Accounting.
2. Navigate to File > Utilities > Reindex.
3. After the reindex has completed, try the same action that caused the error before again.

If you are NOT able to open AbacusLaw

1. Have all users exit AbacusLaw, Abacus MessageSlips, and Abacus Accounting.
2. If you can log into AbacusLaw, you can simply navigate to File > Utilities > Reindex. If not, read below to perform a manual reindex.
3. Navigate to the Abacus root directory (e.g., \Abacus\v23\data01\).
4. Click the dropdown on the Type column, and check the box next to ADI file, so that only files of this type are displayed.
5. Delete all *.adi files.

Be sure that you delete all files ending in ADI, and NO OTHER FILES. ADI files are index files, and do not store data. Other database files (ADTs and ADMs), store actual data, and deleting them will delete your database!

If you are running AbacusLaw v23.16 or earlier, also delete all .cdx files, but DO NOT deleteany .dbf or .fpt files.

The next time Abacus is started, it will recreate the index files, and should function normally.

Finding the cause of the error

1. File > Reports > Choose section
   • Going by section will help alleviate the overwhelming mount of reports in the system)
   • I also recommend creating a list of the Report name and expression as creating the index in the system requires all users out.
2. Select a report from the list and hit the “EDIT” button.
3. Inside the report edit window choose Index at the top.
   
   
   
   
4. If there is something in the expression section then that is a report you want to copy down the Name and exactly what is in that expression field.
   
   
   
   
5. Continue collecting other report names and expressions for later.

Creating Indexes in the system

This step requires all users to be out of the system.

1. Once all reports have been listed out we will need to create the indexes in the system.
   
   
   
   
2. Click “ADD” Remember you only need to add one per unique expression
   
   
   
   
3. In this window you will create the index
   
   • Database – Select the table this index will be used for.
     • Name report = names table
   • Index name – The name of the index
     
     • Select the field from the drop down list that the expression called for
   • Names > Orig_LOC = Orig_LOC
     • Condition – You can leave this field blank
       
       
       
       
4. Once all the indexes have been made click done and you will get this:
   
   
   
   
5. Select Yes and the system will re-index the Tables as is needed.
6. Now we can return to the reports and remove the expressions and select the index.
   
    
   
   
7. Once changed click done and done then move to the next report.