mon_config_service probe - "maximum recursion has been exausted" error - no new profiles are deployed

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

In this scenario, the "Maximum Recursion Error" is logged in mon_config_service probe logs and no new profiles are getting deployed:

Jul 16 11:37:44:760 [TimeController[checkDevices]-267, mon_config_service] TimeController.checkDevices:635: error during timed device processing: PreparedStatementCallback; uncategorized SQLException for SQL [ WITH groupHierarchy (grp_id,pgrp_id) AS (   SELECT grp_id, pgrp_id   FROM cm_group   WHERE grp_id = (select cm_group_id from ssrv2devicegroup where id = ?)   UNION all   SELECT cm.grp_id,cm.pgrp_id   FROM cm_group cm   INNER JOIN groupHierarchy t on t.grp_id = cm.pgrp_id)   select DISTINCT cmgm.cs_id from groupHierarchy gh join cm_group_member cmgm on cmgm.grp_id = gh.grp_id  JOIN cm_computer_system cs on cs.cs_id = cmgm.cs_id ]; SQL state [S0001]; error code [530]; The statement terminated. The maximum recursion 100 has been exhausted before statement completion.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The statement terminated. The maximum recursion 100 has been exhausted before statement completion.

Environment

Release : 20.3

Component : UIM - MON_CONFIG_SERVICE

Cause

A group listed in CM_GROUP table which has its own self listed as the parent group.

Resolution

1- Run the following query in UIM DB:

select * from cm_group where grp_id = pgrp_id

2- If the query return one or more groups, set a distinct value for prgp_id for each one.

 

If nothing is returned in the query mentioned above, please open a support case.