Summary
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.