JIRA comes with a database integrity checker utility to help you identify and fix data inconsistencies, which can often occur as a result of the following:
- Installing and uninstalling add-ons with custom fields and workflow modules
- Direct database manipulation via custom applications and/or scripts
These inconsistencies can sometimes lead to workflow errors or even system crashes. In this recipe, we will look at how to correct these data inconsistencies.
Before you fix any errors found with the integrity checker utility, make sure you create a backup of your data.
Perform the following steps to run the integrity checker utility:
- Navigate to Administration | System | Integrity Checker.
- Select the data to be verified. Check the Select All option to verify all data.
- Click on the Fix button if there are any errors found to automatically correct the errors.
As shown in the following screenshot, we have two data integrity errors related to custom fields caused by custom fields being deleted but still referenced in configuration schemes. By selecting those two errors and clicking on the Fix button, JIRA will automatically fix the errors by removing the references.
