Identifying and repairing problems with the integrity of the database
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 IBM® Engineering Requirements Management DOORS® (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
What to do next
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 ***.