MIZI_BUSINESS TOPOLOGY_GENERAL_CLASSIFICATION make UCMDB use 100% CPU

  • KM03603214
  • 27-Feb-2020
  • 03-Mar-2020

Summary

MIZI_BUSINESS TOPOLOGY_GENERAL_CLASSIFICATION make UCMDB use 100% CPU

Error

When started to see that CPU usage of server machine with the UCMDB started to go to 100%.

 

Checked in the logs and find below 

 

Caused by: appilog.framework.shared.manage.impl.MamResponseException: CMDB Operation Internal Error: class com.mercury.topaz.cmdb.shared.tql.exception.FuseException : 

Number of start objects for compound link calculation is [14003247], while the limit is configured to [500000] : operation Model Query: Calculate Compound Link Backwards Funneled Query Node->root_node(indirect) : 15,14,13 of pattern MIZI_BUSINESS TOPOLOGY_GENERAL_CLASSIFICATION

Caused by: appilog.framework.shared.manage.impl.MamResponseException: appilog.framework.shared.manage.impl.MamResponseException: 

[ErrorCode [193] The number of start objects for compound link calculation exceeds limit, try to refine your TQL]

 

 

 

Cause

Caused by: appilog.framework.shared.manage.impl.MamResponseException: appilog.framework.shared.manage.impl.MamResponseException: 

[ErrorCode [193] The number of start objects for compound link calculation exceeds limit, try to refine your TQL]

Fix

Check first if the size of the environment is good according to hardware specifications and CIs/relationships in the UCMDB , if this is not the problem, continue with the steps below

 

MIZI_BUSINESS TOPOLOGY_GENERAL_CLASSIFICATION is the TQL that should be checked in this case, but take note that can be different TQL.

In this case as a workarround the fuze tql.compound.link.max.start.objects should be incremented, this will solve the problem at first stage.

 

In order to solve the problem in a better way, it can be possible to deactivate the TQL from the UI of the UCMDB so this won't run and cause the problem.