This documentation supports the 20.02 version of Remedy Action Request (AR) System.

To view an earlier version, select the version from the Product version menu.

Running the database consistency checker

The database consistency checker utility compares the Remedy Action Request System metadata with the database structure inside a database. You can use this utility to check the consistency in a database with the data in the AR server. For example, if an AR System form contains ten fields and you delete those fields directly through the database, after you run the database consistency checker utility, you get a warning about the mismatch in records. You must shut down the AR System before running the database consistency checker. 

The database consistency checker uses the -checkdb start up option for arserver.exe (Windows) and arserverd (UNIX).


  • This utility does not start the AR System server for normal use, but instead generates a report about the database tables.
  • Use the -i option to run the checkdb option against the correct server. Also, use the -s and the -l options to specify the name of the server and the path of the license directory, respectively. This enables the -checkdb option to locate the BMC Remedy AR System server, in case the installation directory is other than the default installation directory.
  • If you specify the log file path, use an absolute and not a relative log file path.
  • If a log file with the same name already exists, then the existing file is renamed to logFileName.bak, and a new file is created with the specified name.
  • If you do not specify a log file path, or if the path you specify is invalid, the AR System server creates the following log file:

To run the database consistency checker

  1. Start the AR System server executable using the -checkdb option.

    • For UNIX:

      -jar <ARSystemInstallDir>/bin/arserver.jar --unicode -checkdb
      "<Full Path to log file>" -s "<ARSystemServerName>" -i
      "<ARSystemInstallDir>" -l "<ARSystemLicenseDir>"


      /opt/jre/bin/java -jar
      "/opt/bmc/ARSystem/bin/arserver.jar" --unicode -checkdb
      "/usr/tmp/mycheckdb.log" -s "artest" -i "/opt/bmc/ARSystem" -l


      Full path to log file location is optional. If you do not provide the full path, the AR System server creates the ardbcheck.log file in the <ARSystemInstallDir>/db directory.

    • For Windows:

      -jar <ARSystemInstallDir>\arserver.jar --unicode -checkdb "<Full
      Path to log file>" -s "<ARSystemServerName>" -i
      "<ARSystemInstallDir>" -l "<ARSystemLicenseDir>"


      Files\java\jre\bin\java.exe" -jar "C:\Program Files\BMC
      Software\ARSystem\arserver.jar" --unicode -checkdb "C:\temp\mycheckdb.log" -s
      "artest" -i "C:\Program Files\Common Files\AR System" -l "C:\Program
      Files\Common Files\AR System\Licenses"


      Full path to log file location is optional. If you do not provide the full path, the AR System server creates the ardbcheck.log file in the <ARSystemInstallDir>\Arserver\db directory.

      The AR System server overwrites an existing log file. If your AR Server is non-Unicode then remove --unicode  from command line.

  2. Check the generated log for any inconsistencies.

Correcting database inconsistencies by using the database consistency checker warning messages

When you upgrade the Remedy AR System, the database consistency checker identifies the data inconsistencies between the database and the AR System Server. BMC provides detailed warnings that help you fix the inconsistency easily. If you ignore the warnings given by the database inconsistency checker, you may encounter problems such as data truncation or invalid values after the upgrade. 

The following table describes the examples of some warnings displayed by the database consistency checker:

Example warningDescription
Invalid size for Column [name=name; type=VARCHAR]
in table actlink;
should be size 254 and scale 0 but is of size 100 and scale 0

In the actlink table, reset the name column size from 100 to 254.

Found non-matching input length - Input length for field: C536870915 on table: T586 is 255, while in field definition it is 100.

In the T586 table, reset the length of the C536870915 field from 255 to 100.

Found non-matching data type - field: C536870917 on table: T586 has size 3000 while in in field definition it is set to unlimited(0).

In the T586 table, reset the size of the C536870917 field from 3000 to unlimited (0).

Index T3162_900987211_1 on table T3162 is defined in database,
however, it is not defined on definition of form STG_ImpactAnalysisCircuits

Index T3162_900987211_1 on the STG_ImpactAnalysisCircuits form is created directly on the database.

Best practice

We recommend that you create an index using Remedy Developer Studio.

Related topic

Checking the database tables

Was this page helpful? Yes No Submitting... Thank you


  1. Carina Burns

    This blog post: isn't in line with doc regarding the dt_socket port. "Above steps are not applicable for Remedy version older than 9.0 and steps are not required for Remedy version 9.1.02 onwards"

    Jan 20, 2021 09:31
    1. Anagha Deshpande

      Hello Carina,

      We are working on your query. We will respond back.



      Jan 20, 2021 09:17
      1. Anagha Deshpande

        Hello Carina,

        Apologies for the delayed response.

        We have updated the topic.



        Apr 05, 2021 12:06
  2. LJ LongWing

    Can you explain the note 'You must be connected to the Internet to run the preceding command for Windows'. Why would a db checker require internet connectivity?

    Sep 01, 2022 08:31
    1. Archita Singh

      Thank you for your feedback. We have updated the document. The database checker can be used offline and does not require internet connectivity.

      Jun 14, 2023 01:24