Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
|A single word||
||Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".|
You can specify that the search results contain a specific phrase.
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.
Two or more words in the same topic
|Either word in a topic||
|Topics that do not contain a specific word or phrase||
|Topics that contain one string and do not contain another||
|A combination of search types||
- Entity relationship management
- Entity Relationship Diagram utility
- Missing Reference Report utility
- Start the refcheck.startup scheduler
- Enable data reference checking for a file
- Skip data reference checking for a relationship
- Run a data reference check against selected files
- View the status of existing data reference checks
- Cancel a scheduled data reference checking job
- View missing reference report results
- Identify the root cause of a missing reference
- Relationship Manager
Missing Reference Report utility
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 .
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
Note To use this utility, you must have the SysAdmin capability word.
The following tasks describe how you can use this utility: