How to remove unwanted connector from SOI dashboard

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

we are seeing the old connectors on the SOI dashboard and need to know how to remove them. 

Environment

Release:4.2
Component: SOIMGR

Resolution

If the connector is Offline.

 

- Select the offline connector
- Then click on the Remove Connector button
Once the removal is completed, the connector registration is permanently removed from the CA SOI database, and the connector name is removed from the tree on the Administration tab.

 

If the connector is Online.

 

- To remove the data (CI and Alerts) published from this unwanted connector the connector needs to be offline before it can be removed.

 

The procedure below shows how to offline the connectors in the DB so that users can remove them from the SOIUI\Administration\Connector Configuration by clicking the "Remove Connector" button so that SOI removes the connector and its related data properly.

- Run the following query to get the ConnectorID for the unwanted connector and write them down
  

select * from ConnectorConfiguration

 

 Note: If it is a IFW (catalyst 2.5) connector like Spectrum then there will be ConnectorService entry for the SOI  Integration Service. Similarly, a catalyst 3.x connector also going to have an entry. The                 connectorDesc column on the ConnectorConfiguration table tells you what connector it is. The ConnectorService entry on the MDRName column related to the unwanted connector also needs to be offlined before you can remove it. 

 

- I am going to use two connectors CA:00005 (spectrum) and CA:00050 (UIM) as an example, each of these connectors will have two entries in ConnectorConfiguration table.

Run the above select query to get the ConenctorID for all four entries.
Let's say the ConnectorID for the four connectors you need to remove are 1, 2, 3, and 4. We need to update two columns Status and ConnectorStatusDesc on the ConnectorConfiguration table to make these four connectors appear offline on the SOIUI\Administration\Connector Configuration. 
Use the following SQL query to update
    

Update ConnectorConfiguration set Status=0,ConnectorStatusDesc='No heartbeat message was received for this connector in over 200 seconds. Setting status to Offline' where ConnectorID='<connector id>'

- Once you run the above SQl query for all four of the connector entries in our example will show as offline. Now you can remove these connectors from SOIUI\Administration\Connector Configuration by clicking on the "Remove Connector". If you have a lot of data from these connectors then you may see "Remove Connector" button getting highlighted again which means it couldn't remove all data, in this case, you'll have to click "Remove Connector" button again. In some cases you may have to click on "Remove Connector" button 4/5 times before the connector is removed from the GUI.

Additional Information

 If you want to you can also use soitoolbox instead of clicking on "Remove Connector" button to remove the connector and its data. To do this use --cleanImportedData with soitoolbox, you'll need -c option to identify the connectors
. You can prevent soitoolbox from timing out by using a large enough timeout value with -t option. soitoolbox --help will provide more detail.