Contents   Introduction   Concepts   User Help   Modeler Help   Browser Help
Administrator Help   Developer Help    Utility Help   Visio   Graphical Modeler

DB Integrity Report

A repository which is heavily used and suffers interruptions in operation (such as a power failure) or where unreliable database technology is used, may develop integrity problems. If you want to ensure the integrity of such a repository without doing a full database restore, or if you want to physically delete items which are no longer referenced or which have been logically deleted, then you can use this utility to determine what actions are required. There are various tests that can be performed, as listed on the screen capture below. When you select an option, the tool will test the integrity of that section of the repository. If any issues are found, it will report them. It will also generate recommended SQL code to be run on the repository to correct the problems (i.e. restore the repository to a valid state of affairs). This operation is left to be performed manually by an administrator applying the SQL to the relevant database. It is suggested that a backup be made before this is done. It is possible that some user data from incomplete transactions may be lost in the running of the SQL code.

Test All Classes will test the full repository for all structures. This can take considerable time on a large repository.

Test Attribute Types will test the internally defined data types inherent to the product.

Test Attributes will check the definition of Names Properties in the repository. 

Test Attribute Values will ensure that all properties of items contain valid values for their property type. This can take considerable time on a large repository.

Test Display Order will check the defintion of property display sequences within Type definitions.

Test Legal Attributes will check the definition and linking of Named Properties to their Type Definitions.

Test Legal Relationships will test the definition of relationships available to use between types.

Test Legal Targets will test the definition of relationships defined between types.

Test Node Instances will test the structujre of Items in the repository. Can be slow on a large repository.

Test Node Types will test type definitions.

Test Note Headers will test the discussion types used in free text properties, HTML properties and discussion threads.

Test Note Lines will test the detail continuation records relevant to discussion properties (see item above)

Test Relationships will test the relationships between Items.

Test Rel Types will test the definition of Relationship Types available for the definition of relationships between types.

This function is accessible from the main EVA Netmodeler system menu.