Use the Database Integrity Checker window to identify and repair data integrity problems.
About this task
You can check:
- Each reference from a parent item to a child item has a corresponding reference back from the child to the parent.
- No child item is referenced as a child of two different parent items.
- Every item in the database is referenced as the child of another item. If an item is not referenced by a parent, it (and any child objects it has) is not displayed in the database explorer. This data is recovered to a Lost and Found folder.
- Every project in the database has an entry in the project view list. The project view list is the list that Rational® DOORS® uses to generate the Project View in the database explorer.
When the database integrity check is complete, use the wizard to repair any inconsistencies in the database and move or restore any recovered data.
You can run a restricted integrity check on the contents of a selected folder or project. An integrity check on a project or folder cannot check for data that is not referenced by any other item. It can check for:
- Missing data
- Items that are referenced by more than one parent
- Projects that are not included in the project list
Procedure
- Log in to Rational DOORS as the administrator user. The administrator user is the only user who can run the database integrity checker.
- To check all the data in the database, select the database
. To check the data in a particular project or folder, select the project or folder and click File > Check Integrity. The Database Integrity Check wizard is displayed.
Note: If the database server is version 7.0 SP1 or earlier, you cannot check the integrity of data. If the database server is not compatible, an error is displayed.
- Follow the steps in the wizard to check and optionally repair problems with the integrity of the data. For more information about any of the pages in the wizard, click Help.
What to do next
If you chose to create a log file, you can view the results of the integrity check.
The log file is created in the directory you specified when you ran the integrity checker. It contains three sections:
- The first section contains a list of all the items that were checked, along with the date and time of the check. Items that have integrity problems are marked with ***, and a brief description of the problem is given.
- The second section contains a summary of each problem that was detected. The summary provides details of the parent and child references that existed for each item when it was checked.
- The final section contains details of the repairs you made to the database. Any repair that failed is marked with ***.