Data Integrity Correction Overview

UCS Manager can diagnose and fix a number of data integrity issues in the UCS database. To use this functionality, proceed as follows:

  1. Select DataCorrection on the Tools menu.

  2. In the resulting Data integrity correction dialog box, verify the UCS application name and associated tenant at the top of the dialog box.

  3. Use checkboxes in the Diagnose and Fix columns to select one or more issues. The Data Integrity Correction Issues topic describes the issues and how they are fixed.

If you select both Diagnose and Fix, UCS diagnoses first, then fixes.

  1. Use radio buttons to select main and/or archive databases. Some issues apply to the main database only; see Data Integrity Correction Issues for a list.

  2. Click Start.

  3. Indicators at the bottom of the dialog box report on the progress of this run.

Other columns in this dialog box show the following:

If the task is taking too long you can click Stop. If a task takes a long time and the Status column shows Error, do the following:

  1. Increase the value of the DAP option long-query-timeout. This option is described in the eServices Reference Manual.

  2. Restart UCS and run the task again.