Setup Wizard Credentials and Define Discovery Scopes - UI hangs OC when deleting credentials or scopes

Products

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

Issue/Introduction

• UIM 20.33 with October Monthly 2021 Hotfix with Oracle 19c as the backend database

Environment

• Release: 20.3, 20.4 or higher
• Component: UIM OPERATOR CONSOLE - WASP & CORE

Resolution

1. Identified the da_id with query below

select * from CM_DISCOVERY_AGENT 

2. Then we executed the queries below to delete all information for a given discovery_agent. In the example below the discovery agent da_id is 41, replace 41 with your da_id.

DELETE FROM CM_NETWORK_SNMP WHERE network_id IN (SELECT network_id FROM CM_DISCOVERY_NETWORK WHERE da_id = 41)
DELETE FROM CM_NETWORK_WMI  WHERE network_id IN (SELECT network_id FROM CM_DISCOVERY_NETWORK WHERE da_id = 41)
DELETE FROM CM_NETWORK_SHELL WHERE network_id IN (SELECT network_id FROM CM_DISCOVERY_NETWORK WHERE da_id = 41)
DELETE FROM CM_DISCOVERY_NETWORK WHERE da_id = 41
DELETE FROM CM_COMPUTER_SYSTEM_ATTR WHERE cs_attr_key='<xxxx>' and cs_attr_value=41
DELETE FROM CM_DEVICE_ATTRIBUTE  WHERE dev_attr_key='da_id' and dev_attr_value=41
DELETE FROM CM_NETWORK_LDAP WHERE da_id = 41

-- update the CS records that were discovered by the discovery agent

UPDATE CM_COMPUTER_SYSTEM SET da_id=null,cs_type='A' WHERE da_id = 41

-- now delete the discovery agent

DELETE FROM CM_DISCOVERY_AGENT WHERE da_id = 41

3.  Executed the commit command.

4. Deleted all Setup SNMP Credentials stored in the CM_SNMP_AUTHENTICATION table.

--Identify the snmp credential ids

SELECT * FROM CM_SNMP_AUTHENTICATION

--Delete the snmp credential ids

DELETE from CM_SNMP_AUTHENTICATION where snmp_id = 24

    Execute the commit command

5. Deactivated/Activated discovery_server probe and waited some time for the Discovery Server agent to be rediscovered

    Note: To speed up the display of the discovery_agent in the Setup Discovery Wizard menu, redeploy the discovery_agent on the secondary hub

6. Added Profiles to the Setup SNMP Credentials and Scopes and now the Discovery Wizard menu does not hang nor error.