alertoff Corruption Error

Overview

When DentiMax Practice Management is left running overnight, the alertoff table — which
tracks patients whose medical alerts have been suppressed for the day — cannot be properly
cleared when the day rolls over. This corrupts the table and prevents anyone in the office
from logging into DentiMax until it is resolved, producing the following error:

Error: Blob block buffers corrupt in the table alertoff

This article will guide you through safely stopping the DentiMax service, creating a database
backup, repairing the corrupted table, and clearing its contents.

Before You Begin

Confirm the following before proceeding:
1. You have access to the DentiMax Practice Management server computer.
2. DentiMax is closed on all computers in the office, including any error dialogs.
3. You know (or can identify) the location of the DentiMax database folder.

Procedure

Step 1 — Stop the DMSRVR Service

1. Close DentiMax on all computers in the office, dismissing any error dialogs that appear.
2. On the DentiMax server computer, press Ctrl + Shift + Esc to open Task Manager.
3. In Task Manager, click the Services tab. Locate the service named DMSRVR, right-
   click it, and select Stop.
   
4. Minimize Task Manager — you will need it again later.

Step 2 — Back Up the Database

1. Open File Explorer and navigate to the DentiMax data directory, typically located at C:\
   dentimaxdata.
2. Right-click the database folder and select Compress to > ZIP File (Windows 11) or
   Send to > Compressed (zipped) folder (Windows 10)
   
   
   
3. When prompted to rename the file, append today's date:
   1. Format: [Database Name] Month.Day.Year
   2. Example: Tony Tony Chopper DDS 4.7.26

Step 3 — Repair the alertoff Table

1. Open dbsys.exe, located at C:\Program Files\DentiMax\Server.

2. In dbsys, click Utilities in the top menu bar, then select Repair Table... from the
   dropdown.
   
3. In the Repair Table window, click the Select... button next to the Available Databases
   field. Navigate to the DentiMax database folder, select it, and click OK.
   
4. In the Available Tables list, scroll down and select alertoff.
5. Check the Force index rebuild checkbox at the bottom of the window, then click
   Repair.
   
6. When the repair completes, click OK, then click Close.

Step 4 — Empty the alertoff Table

1. Click Utilities again and select Empty Table...
   
2. Confirm that the Available Databases field still shows the correct office database path.
   If it does not, click Select... to re-select the correct database.
3. In the Available Tables list, click alertoff to select it.
4. Click Empty. A confirmation prompt will appear showing the filepath of the table to be
   emptied.
   
5. Review the filepath carefully. If it does not point to the correct database, click No and
   return to Step 3f. If it is correct, click Yes.
6. Click OK, then close dbsys.

Step 5 — Restart the Service and Verify

1. Reopen Task Manager (Ctrl + Shift + Esc) and navigate to the Services tab.
2. Right-click DMSRVR and select Start.
3. Attempt to log into DentiMax Practice Management on any workstation to confirm the
   error is resolved.

Additional Troubleshooting

For issues not covered by this runbook, or if you are unsure about any step, contact DentiMax
Practice Management Support at 1 (800) 704-8494 Ext. 805 or Support@DentiMax.com.