How to Check the Error Messages of Failed CIs/CI Relationships in a Push Job

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)`

When a data push job is completed with partial records failed, in the Universal CMDB studio, you can check the source CI XML of Universal CMDB, the XSLT-transformed XML and the response XML from Service Manager to see if the failure is caused by data issues.

To check the error messages of failed records in a data push job:

Navigate to Data Flow Management > Integration Studio.

Select the integration point for this integration from Integration Point list.

Click the Data Push tab.

Select the job from Integration Jobs.

Click the Query Status sub-tab.

Double-click a query with failures. The Error Message and CI Count for each failed CI Type are displayed.

Double-click an error message. A list of failed records is displayed.

Double-click a failed record.

The detailed error message of the record is displayed.

The following is a sample error message that indicates a validation failure, and the root cause is that a not-null key (key definition #18 of the device table) contains an empty value.