Newly created group not reflecting in OC Copy Profile window

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

We have created a new group on the OC console. When we try to copy the profiles from the existing group, the new group does not show up in the list. We have checked the status of the DB in both the tables, CM GROUP Table and SSRV2DeviceGroup, and the group is present and the status is OK.

Environment

• DX UIM 23.4 CU3
• MCS-environment

Cause

• The target group did not have at least 1 computer system with a robot installed

Resolution

For profile copying, the system will primarily check three tables and two conditions.

The tables involved are:

• CM_GROUP
• CM_GROUP_MEMBER
• CM_COMPUTER_SYSTEM

The conditions are:

• The target group must not be of type Interface group.
• The target group must contain at least one computer system with a robot installed.

Here is the query which is responsible to return the target groups:

SELECT distinct cgrp.grp_id, cgrp.name, cgrp.grp_type ,cgrp.pgrp_id, cgrp.description,cgrp.active 
FROM CM_GROUP cgrp, CM_GROUP_MEMBER cgrpmember,CM_COMPUTER_SYSTEM cs 
WHERE cgrp.grp_id = cgrpmember.grp_id AND cgrpmember.cs_id = cs.cs_id  AND cgrp.master_element_group!=1 AND cs.nimbus_type in (1,2)

Issue no longer reproducible when requirements listed above are met (within the target group you must have at least one computer systems with a robot installed.)