SMS Utility: IDRepair.exe

This utility corrects occurrences of Large (>1073741824) IDs found in the critical Cyrious SMS databases.

In Cyrious large negative ID's are assigned to temporary records. At times the database engine will improperly assign that large ID to the permanent record in the database rather than the next ID in sequence. When this occurs you'll receive an error message.

Id Exceeds Established Parameters

These are critical steps

1. Prior to any changes to the Database, one should always make a backup of the database. See SMS - Backing Up the Database.
2. Ensure Cyrious is turned off everywhere
3. Shut down the SSLIP

1. Run the IDRepair Utility to scan for Large ID and re-sequence them as necessary.
2. By default the IDRepair.exe utility is located under C:\Program Files\Cyrious\SMS\Utilities\IDRepair.exe
3. Double click on IDRepair.exe to launch the utility.
4. Click Scan to search the listed tables for large IDs.
5. Click Execute to begin the re-sequence of those IDs.

Note: Not all tables are handled by this utility, in the event that you find other tables with this problem you may have to manually re-sequence those records using a SQL query or by hand through DBBrowser.