Home User Manual Discussion Forum Search

Database Maintenance  

The database maintenance tool checks the database for improper settings, inconsistencies, or corruption. You can then choose which fixes or tools to run, or follow the provided guidance to correct problems. It should only be run on one computer at a time. 

Note: If using Replication, database maintenance can be dangerous. Make certain all servers are connected prior to running (e.g. if mobile units). We also recommend making a backup of the database first, then running it after hours. You will need to 'Force Synchronization' after running, then check that replication is still running properly.

In the main menu, click Tools, Database Maintenance.

Checks Tab
All possible database checks are listed. 

  • Highlight the checks to perform or click None to deselect all checks. When no checks are selected, all database checks will run.
  • Show me everything in the log: If checked, when a check or fix is run, the results will include a detailed log. If unchecked, a truncated version of results will show.
  • Click Check to only run database checks and display results.
  • Click Fix to run database checks and fix any errors that do not require a manual fix. 
  • Breakdown: If an X shows in the Breakdown column, double click to see a breakdown of results.

Everytime any check or fix is run, MySQL will check every single table for corruption, so you may notice a delay. As checks are complete, the Results log will update. 

Note: Galera enterprise users can manually disable the MySQL integrity check by setting the DatabaseMaintenanceSkipCheckTable preference to true. This will also disable the Optimize button under the Tools tab.

Print Log Results: Click Print to send all results currently displaying to the printer. 

Manually Fix Errors: Some errors detected during a check must be fixed manually. If the results log indicates a manual fix is needed, double click on the row to open more details.

This window is non-modal. It can remain open while you access other areas to fix the issue. Close the main Database Maintenance window, then proceed. Click Print to print the results. See Manually Fixing DBM Errors for a list of errors and how to fix them.

Tools Tab
Each database maintenance tool addresses a specific issue. Before running a tool, read instructions carefully. Typically they take a long time to run but only need to be run once.

Ins Pay Fix: This tool will fix insurance payments that have been received but not Finalized (attached to insurance checks/payments). One check will be created for each claim. The claim payment date will be the date the claim was received.

Optimize: This tool will backup, optimize, and repair SQL commands on each individual table. Only use if corruption is suspected or for extremely large databases.

Appt Procs: This tool will fix procedure descriptions on appointments that are not correctly showing tooth numbers for some reason. It will also update procedure code text colors and previous date information for existing appointments, if you have Customized Procedure Text Colors for the appointment box.

Spec Char: Only use this tool if you are having trouble synching your appointments to the Mobile Synch App or if you receive an invalid character error while using the Middle Tier. It will permanently remove unsupported Unicode characters from appointment notes, procedure descriptions, patient address notes, patient address fields, adjustment notes, payment notes, and definition names. This will also remove characters from non-English languages. If you wish to continue, the password is "fix" without quotes.

InnoDb: This tool will convert all tables in the database to the selected storage engine (MyISAM or InnoDb). All users are initially set up as MyISAM. Users only switch to InnoDb if they have special needs, such as increased performance. User must have done research on MySQL website.

Tokens: This tool will check the database for any X-Charge tokens that are attached to the wrong credit card number. A second window will come up listing all credit cards and letting you decide which ones to check.

Remove Nulls: This tool willl remove extra, hidden characters that may be causing errors or problems and replace with empty strings.

Etrans:  This tool will clear etrans messages (electronic transactions) older than one year. An automatic backup will be created first. It can only be run by users with the Security Admin Permission.

Active TPs: This tool will create active treatments plans for patients that have treatment planned procedures but no active treatment plan. This was a known issue in early beta versions of 15.4.

Raw Emails: This tool can be useful if you are using the Email Inbox and backup size has grown too large. Large size is often due to the emailmessage table. Run the tool to look through all inbound emails, safely remove raw message content that is no longer needed, then optimize the emailmessage table.

 

Open Dental Software 1-503-363-5432