Using the Database Validation Tool (DBValidator.bat)

book

Article ID: 180053

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

 

Resolution

If you encounter a problem with your Symantec Endpoint Protection Manager (SEPM) database, Symantec Support may ask you to run the Database Validation tool to assist in diagnosing the problem. The batch file, dbvalidator.bat, is located by default in:
  • 64-bit OS: \Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools folder.
  • 32-bit OS: \Program Files\Symantec\Symantec Endpoint Protection Manager\Tools folder.

This tool creates a log file that is called dbvalidator.log, which is placed in the Program Files(x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\logs folder.

When the tool finds a broken link to a database object, it inserts the XML content that is related to that object into the log file.

Run the Database Validation Tool from a command window

  1. Open a command prompt​​. Click Start > Run > Type: "cmd" (without quotes) > click OK.
  2. ​Change the directory to:
    • 64-bit OS: CD\Program Files(x86)\Symantec\Symantec Endpoint Protection Manager\Tools
    • 32-bit OS: CD\Program Files\Symantec\Symantec Endpoint Protection Manager\Tools
  3. ​​Type the following command to run the batch file:

    dbvalidator.bat

To run the DBvalidator from Windows

  1. Navigate to:
    • 64-bit OS: \Program Files(x86)\Symantec\Symantec Endpoint Protection Manager\Tools
    • 32-bit OS: \Program Files\Symantec\Symantec Endpoint Protection Manager\Tools
  2. Right Click the dbvalidator.bat file and select "Run as Administrator"
  3. When finished the DBvalidator command prompt will close automatically

DBvalidator Log Results Location

  1. Locate the dbvalidator.log in
    • 64-bit OS: \Program Files(x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\logs
    • 32-bit OS: \Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\logs
  2. Open the dbvalidator log in Notepad and scroll to the very bottom
  3. One of the following messages will be displayed at the command prompt to tell you whether the database has passed or failed validation:
    1. If the database is valid, you see the following message:

      Database validation passed.

    2. If the database is invalid, you see the following message:

      Database validation failed. Please check the log file for more details.

    3. If an error occurs, you see the following message:

      Some error occurred. Please check the log file for more details.

If If the Dbvalidator results indicate it failed please contact Support for assistance.