After running a database check, clicking the link that appears on the Data Integrity Checker Utility window opens the Issues Summary dialog box. The Issues Summary dialog box displays issues that need repairing. The dialog box consists of a number of columns and rows, each row corresponds to a specific issue.
-
The Data Integrity Checker Utility solutions are supplied as a locked file and can only be opened and updated by Smart Community Support.
-
We recommended that you also check the Log file located in the Log folder in the DataIntegrityChecker folder, even if no issues were reported.
The columns are:
Check Boxes – Select the check box next to the issue you want to repair.
To select all the check boxes, check the top check box in the Column Name row.
No. – The row number.
Command ID – The issue ID number.
Category Type – The Category Type of the issue.
Issues Found – A brief description of the issue.
Status – The status of the issue found. These statuses consist of the following:
-
Ready to repair – An issue has been found that the software can fix.
-
Repaired – The issue has been repaired.
-
Manual repair – The repair is not possible with the repairs supplied with the software. Please create a log file and contact Customer Support at PPM Smart Community. See Export File below.
Rows Found – The number of rows, within the database, this issue has been found in.
(information) – Click this Icon to open a more detailed description of the issue.
File Version – The version number of the DataIntegrityCommands.ddti file installed with the Data Integrity Checker Utility Guide.
-
The File Version is not the software version number.
-
If you are asked what version of the solutions file you are running, this is the number requested.
-
You can also use this version number to confirm that the DataIntegrityCommands.ddti file you are working with is the most up to date.
Export File – Click to create a file of the selected issues for sending to support.
To export the Issues file, you must have Microsoft Excel installed on your machine.
Repair – Click to start repairing the selected issues in your database.