Administer > Database Administration > Entity relationship management > Missing Reference Report utility

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 HPE 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 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 company company link new
    contacts location link new
    contacts location 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:

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