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 Manager9.41

Administer > Database Administration > Entity relationship management > Missing Reference Report utility > Identify the root cause of a missing reference

Identify the root cause of a missing reference

If a missing reference report has detected any invalid records, you need to identify their root causes. Remember that the data in the source file should also exist in the target file, otherwise the data is an “orphan” or there is a non-relational link or erddef definition behind that “orphan” data.

Example 1 : The missing reference is caused by a pure orphan value.

This example demonstrates the steps to handle a missing reference, using the operator file and out-of-box data in the system.

Task 2. Understand the report results.

Verify that Jos.Hair does not exist in the operator file. To do this, follow these steps:
1. Type operator in the command line, and press Enter.
2. Type Jos.Hair in the Login Name field, and click Search.
The search returns no results, which means that Jos.Hair does not exist in the operator file.
Open several existing operator records to understand what their Login Name values look like.

Note This step can help you find out if all values in a field should follow certain rules.
In the command line, type link and press Enter. The Search Link Records form opens.
Type assignment in the Name field, and click Search.
Locate the row in which the Source Field Name is wdManagerName.

This is the relevant relationship definition. You should check to see if this link relationship complies with the business logic or is designed as desired. If not, the inappropriate link definition is probably the root cause of the “orphan” data; in this situation, you need to take actions on the link definition. If yes (which is true in most scenarios), the “orphan” data is then a pure “orphan” (that is, a real missing reference).
Find the record in the assignment table whose Manager Name is Jos.Hair.

The Manager Name field is the wdManagerName field in the assignment table, which is mapped to the name field in the operator file.
According to the business logic, manager “Jos.Hair” should not have appeared in the assignment group record, because an assignment group manager should also be an operator in Service Manager. Furthermore, if you remove “Jos.Hair” from the Manager Name field and then click the Fill button, a list of operators is displayed. However, your previous search has already shown that “Jos.Hair” does not exist in the operator file. Therefore, it is true that “Jos.Hair” is an orphan value.

In summary, the root cause of this orphan value is that the assignment group record defines a manager name that cannot be found in the system.

Example 2. The missing reference is caused by an inappropriate link definition

The following describes an example of an inappropriate link definition.

Navigate to System Administration > Tailoring > Tailoring Tools > Relationship Manager, locate the following relationship record through a search.

SOURCE_FILE	SOURCE_FIELD	TARGET_FILE	TARGET_FIELD	RELATION_TYPE	DEFINITION_TYPE
contacts	location.full.name	company	company	Many to Many	link

In the relationship record, click Goto Definition to open the link definition, and locate the row that has a Source Field Name of location.full.name and a Target Field Name of company.
Type contacts in the Service Manager command line, press Enter, and then open a contact record through a search.

The location.full.name field in the contacts table has a label of Location Structure in contact records (the Address tab). As shown in the following figure, this field should be a combination of company and location according to the out-of-box business logic (for example, advantage/North America).
Open the company table in Database Manager, and locate a company record through a search.

The company field in the company table has a label of Company Code in company records. The following figure shows an example value.

It is obvious that the link file defines a pair of source and target fields that have different value structures and therefore should not be mapped to each other. So this is an inappropriate link definition.

Note Because of a limitation (see the Limitations section in Missing Reference Report utility), the Missing Reference Report utility does not report invalid records caused by this link definition when running a date reference check against the contacts table.

Steps to analyze a missing reference record

Normally, you can use the following process (which is similar to the example process described above) to analyze a missing reference record:

Search in the target file to make sure the orphan value cannot be found in the target file, and examine the data in the target file to see what a correct value should look like.
Go to the link or erddef record to locate the relevant relationship definition.
Identify the problem:
- Find the invalid "orphan" value in the source file.
- Find the non-relational definition in the link or erddef file.
Analyze the problem based on the business logic.
Find out the root cause of the problem.
Perform the following tasks based on the root cause identified:
- If the invalid record does contain a missing reference, correct the wrong information and then click Save. Alternatively, you can leave it as is if it is only historic data or you can click Delete to delete the record if you no longer need to keep it.
- If the invalid record was caused by an inappropriate link or erddef definition, update the link or erddef definition.
- Mark the corresponding relationship record so that it is skipped for future data reference checking. To do so, on the report details page of this relationship, click More or the More Actions menu and then select Skip Data Reference Check (see the following figure). If you open this relationship record from Relationship Manager, you will see the Enable Data Reference Check flag in the relationship is now turned off.

Send Help Center feedback