Troubleshooting and Limitations – UCMDB to XML Adapter

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

Problem: UCMDB to XML discovery fails with a timeout exception, with the following error in Data Flow Probe logs:

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (14070323 > 10485760). You can change this value on the server by setting the max_allowed_packet' variable.

Cause of problem: There is not enough DFM probe resources to export a large amount of CIs/relationships.

Solution #1:

Decrease the replication.chunk.size setting for the XmlPushAdapter, as follows:

In UCMDB, go to Data Flow Management > Adapter Management.
In the list of resources, go XMLExportAdapter > Adapters >XmlPushAdapter.
Right-click on XmlPushAdapter and choose Edit Adapter source from the pop-up menu.
In the XML Editor that opens, find the adapter setting replication.chunk.size and decrease the from the current value. For example, if replication.chunk.size is currently 1000, you can decrease it to 100 as follows:
```
<adapter-settings>
   <adapter-setting name="replication.chunk.size">1000</adapter-setting>
</adapter-settings>
```
and decrease the chunk size. For example:
```
<adapter-settings>
   <adapter-setting name="replication.chunk.size">100</adapter-setting>
</adapter-settings>
```
Click Save, and rerun the integration point.

Solution #2:

Instead of one large integration job, create a few smaller jobs. To do this, create a few export TQL queries that will cover all the CIs to export and will be the basis of the smaller integration jobs.

Problem: Several sub-jobs fail when you add the Model Hierarchy query to the integration job.

Solution: The integration does not support TQLs with SubGraphs and TQLs with Full Path Compound links.