Previous Topic: Upgrading ServiceCEO
The Database Validator is a tool that runs a number of tests on your database to ensure that there are no problems or data corruption. Running the Database Validator will ensure that any potential problems are caught and fixed as soon as possible.
You can run the Database Validator can be run in two different ways:
Before running any upgrade file. Upgrading ServiceCEO will automatically run the Database Validator before upgrading the database.
As a standalone program. At any time, you can run the Database Validator by selecting Start > All Programs > ServiceCEO > Database Validator. Click Start from the Database Validator window. Make sure that nobody is logged into ServiceCEO before you start it.
However you run it, the Database Validator dialog box will appear. It will take a minute for the tests to run. After the tests have run once, the Database Validator will attempt to fix all tests that failed and then will run all of the tests again. When complete, a results screen will appear. Click Details to see detailed results, including a listing of tests that did not pass as well as any tests that found an issue that was automatically fixed.
If you are upgrading your database, and no errors are found, the Database Validator automatically closes and the database upgrade begins.
Each test is assigned a severity. If any tests failed, you should view the detailed results and perform one of several actions, depending on the number and severity of errors that the Database Validator finds. The severities are:
Minor Errors. Minor tests are designed to catch small inconsistencies in your data, such as corporate customers with a First Name/Last Name (rather then a single company name). These tests are generally informational in nature; note of these issues will affect the day-to-day running of your business. You can upgrade a database with minor errors without any issues.
Major Errors. Major tests - indicated by a yellow caution sign - are issues that could affect some areas of the program. While you will be able to upgrade your database without any problems, we recommend you contact Technical Support to resolve these issues at your earliest convenience.
Critical Errors. Critical tests are indicated by a red warning sign. Critical tests catch problems that could affect your business; for that reason, we do not recommend that you upgrade a database with any open critical issues. We highly recommend that you contact Technical Support to resolve any critical issues before continuing to work in ServiceCEO.
Note that you can double-click the name of any test in the details pane to display the database records that were affected by this issue.
Other steps you can perform in the Database Validator are:
Details/Hide Details. This button expands and contracts the Database Validator screen so that you can see the individual test that failed.
Help. This button displays the Database Validator help, where you can read an explanation of the Database Validator tests and what they mean to your data.
If you are upgrading your database, please be sure to read the Upgrading ServiceCEO topic.
Next Topic: Training Overview