Deleting Orphaned Index Entries with SigmaX

[Product_Support]

Issue

A SigmaX Doctor report may display Category A errors such as:

UNC = 92 Object No. = 97 INDEX.REC ERROR
Index entry does not have a matching point file entry

UNC = 92 Object No. = 98 INDEX.REC ERROR
Index entry does not have a matching point file entry

Product Line

Satchwell BAS & Sigma

Environment

• Sigma
• SigmaX

Cause

These errors occur when an Index entry exists in the database, but the corresponding Outstation point file does not contain the object. This typically happens when:

• A technician deletes objects in the field using a laptop.
• The modified point file is uploaded to the server.
• The server retains outdated index entries for the deleted objects.

Resolution

Once confirmed that the objects should not exist, follow these steps to safely delete the orphaned index entries using the Doctor Index Editor:

⚠️ Important: There is no undo or confirmation prompt in this utility. Always back up your data before proceeding.

Steps to Delete Orphaned Entries

1. Open SigmaX and launch the Doctor utility.
2. Run the Index Editor.
3. In the Find field, enter the UNC and Object Number using a pipe separator (e.g., 92|97).
4. Click Point to locate the corresponding line in the index file.
5. In the Edit area, enter the Index Editor password: IE.
6. Click the Delete button to remove the entry.
7. Repeat steps 3–6 for any additional orphaned entries.
8. Once complete, click the index.bin button to generate a new index.bin file.
9. Close the Index Editor.
10. Run the Doctor Error Check again to verify the issue is resolved.