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 ; 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.
Release : 20.3
Component : UIM - MON_CONFIG_SERVICE
A group listed in CM_GROUP table which has its own self listed as the parent group.
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.