Missing Reference Report utility

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager uses the database to store all information. Relationships between tables are defined by certain tables (dbdict, erddef, link, and triggers) and applications other than by primary and foreign keys. There is a challenge to maintain database integrity when there is a change of a referenced value in the database.

Prior to version 9.40, although Service Manager can define relationships between Service Manager files through the link, erddef, and relatedObjectMap tables, there is no way to know if data stored in the files complies with the predefined relationships. As a result, orphan records and data redundancy may occur, which could lead to data corruption or data inconsistency. For example, renaming a Configuration Item or a department may result in orphan records, which still contain a reference to the old name (that is, a missing reference).

As of version 9.40, Service Manager provides a tool, Missing Reference Report, which can generate a report for selected files to help you find out and solve potential data integrity problems. This utility can help your organization mitigate system risk and save the total cost of ownership (TCO) of adopting Micro Focus Service Manager.

Missing Reference Report can report the following items:

Records that do not follow their primary key constraint

Records that reference values that do not exist in the target file.

Records that reference nonexistent field values and contain referential fields that are mapped to a large object (LOB)

Note This utility skips some relationships in the out-of-box system by default. For details, see List of skipped out-of-box relationships .

Limitations

This utility has the following limitations:

This utility can detect only missing references to fields of either the number or the character data type (including number and character fields in arrays). Other data types, such as logical and date/time, are not supported.

This utility ignores new or fixed relationships in which the same source field has multiple parents (target fields) defined. The location.full.name field in the contacts table is an example, as shown in the following table.

Source Table	Source Field	Target Table	Target Field	Definition	Status
contacts	location.full.name	company	company	link	new
contacts	location.full.name	location	location.full.name	link	new
contacts	location.full.name	location	location.full.name	link	new

Using the utility