search cancel

Use dbvalidator to diagnose manager database issues

book

Article ID: 151525

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

How to use dbvalidator, the database validation tool, to diagnose database issues in Symantec Endpoint Protection Manager (SEPM).

Resolution

Where to find dbvalidator

The batch file, dbvalidator.bat, is located by default in:

  • 64-bit versions of Windows: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools
  • 32-bit versions of Windows: C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Tools

If SEPM is installed in a different directory or volume, this path may vary.

Run dbvalidator

  1. Click Start > Run
  2. Type cmd and press Enter.
  3. Click OK.
  4. Change directory to the tools installation folder (change the path as appropriate if the SEPM is installed elsewhere):
    • 64-bit operating systems: cd "C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools"
    • 32-bit operating systems: cd "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Tools"
  5. Type the command dbvalidator.bat and press Enter to run the batch file.

The tool will create a log file located at

  • 64-bit operating systems: cd "C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\logs\dbvalidator.log"
  • 32-bit operating systems: cd "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\logs\dbvalidator.log"

One of the following messages is displayed at the command prompt dependent upon whether or not the database has passed validation:

  • If the database is valid, the message, "Database validation passed." appears.
  • If the database is invalid, the message, "Database validation failed. Please check the log file for more details." appears.
  • If an error occurs, the message, "Some error occurred. Please check the log file for more details." appears.

Technical information

If the Dbvalidator results indicate it failed please contact Support for assistance as some database errors can be fixed.  

If database validation fails and cannot be repaired, restore from a known good database backup, or uninstall the manager, remove the database during uninstall process, then reinstall the management console, creating a new database.

To reconnect existing Symantec Endpoint Protection clients to the new management console, please see Disaster recovery best practices for Endpoint Protection and follow the instructions for disaster recovery without a database backup.