Use the Database Integrity Checker 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 children
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: You cannot check the integrity of data if the
database server is version 7.0 SP1 or earlier. An error is displayed
if the database server is not compatible.
- 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 ***.