Documentation
API
Q&A
Read
AnnouncementsArticlesWebsite tips
Learn
Getting StartedManagerMaestroAnalyticsExchangeWorkspaces
Resources
VideosDownloadsExchange PackagesRelease Notes
Ideas
Contact
Platform
Manager
Maestro
Exchange
Workspaces
Analytics
Springboard

Database Integrity Checker Job

   Journey Manager (JM) The transaction engine for the platform.  |    System Manager / DevOps  |  23.04 This feature was introduced in 23.04 |  24.10This feature was updated in 24.10

Manager provides the Database Integrity Checker job that periodically executes a Database Integrity Checker service to check the integrity of a database used by the server. This scheduled job runs weekly.

The Database Integrity check consists of the following validation rules:

  1. Check tables for orphaned records based on entity relations.
  2. Remove invalid orphaned records, if the Delete Orphaned Records checkbox is selected in the Database Integrity Checker service.  |  24.10This feature was updated in 24.10
  3. Check tables' indexes.
  4. Check services' default values.
  5. Check forms' delivery method configuration.

For each validation rule, the Database Integrity Checker job generates a report, including the following information:

  1. An entity, target entity and the number of invalid records in a table.
  2. An entity name and columns which we expect to have an index on.

Then, the Database Integrity Checker job sends the report as an email to the Receive System Alerts - Database Integrity alert group. You need to assign this group to a user to receive the Database Integrity notifications.

The default Database Integrity Checker job configuration is shown below.

Manager database integrity checker job configuration

The Database Integrity Checker job adds an entry of the Database Integrity type to the Event Log. This allows you to find all Database Integrity issues easily.

The Event Log entry example is illustrated below:  |  24.10This feature was updated in 24.10

Database Integrity Checker Job found 2 invalid/orphaned groups: 
1 record(s) for Entity: submission_property_search Field: submission_property_oid TargetEntity: submission_property 
2 record(s) for Entity: submission_property Field: submission_oid TargetEntity: submission

You can also view the history of scheduled jobs and use Database Integrity Checker as a Job Name to narrow down your search, as shown below.

Manager view the history of database integrity checker scheduled job

Next, learn how to manage scheduled jobs