How to uninstall and then reinstall CABI probe in UIM 20.x

Products

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

Issue/Introduction

How do I completely uninstall CABI from UIM 20.x? How to remove CABI from UIM? 

This KB provides steps to completely remove/uninstall CABI from UIM.

You may need to uninstall and reinstall CA Business Intelligence (CABI) Bundled for one or more of the following reasons:

• CABI doesn't start
• Cannot access the dashboard or the dashboard fails to load
• Data Access Error, e.g., in OC Reports page 

Environment

• UIM ALL supported versions
• CABI 4.x, 7.50, 8.00
• uim_core_dashboards_pack - related versions
• uim_cabi_health_report_pack - related versions
• uim_unified_reporter_pack - related versions
• ump_cabi - related versions

Resolution

1. - Gather the scripts for MS SQL server (attached to this KB), or MySQL and Oracle from the following location on the cabi server, and save them off:
   
     \Nimsoft\probes\service\cabi\config\scripts\drop_tables\Scripts for Upgraded versions
2. Delete cabi probe (via IM or AC)
3. Delete wasp probe (via IM or AC)
4. RDP to the Cabi server and delete ../nimsoft/c folder
5. Delete ../nimsoft/probes/service/cabi folder
6. Delete ../nimsoft/probes/service/wasp folder
7. Run the delete queries against the UIM SQL database 3 times (attached script) (or previous grabbed scripts in the case of MySQL, and Oracle)
   Note: This is required due to some overlap in dependencies.  This process should not continue until all of these tables are dropped.
8. Deploy the cabi probe to the cabi server
   Note: Wasp probe will be automatically deployed with Cabi probe
9. Verify the following packs are deployed to the cabi server
      a. uim_unified_reporter_pack
      b. uim_cabi_health_report_pack
      c. uim_core_dashboards_pack
10. Cabi probe will take ~15 minutes to start
    Please note the last step from the documentation is to verify that the installation is complete.  You need to confirm that the following lines exist in the cabi.log file:
    
    <date_time> [main, cabi] cabi installed successfully.    
    ...    
    <date_time> [UserSynchronizationThread, cabi] Finished synchronizing users between DX UIM and CABI
    
    Restarting the cabi or wasp probes before observing those lines in the log may result in a failed deployment of CABI
11. Try to login to Cabi page once Cabi and wasp probes have ports and PIDs
    Login to the CABI server http://<CABI IP address or FQDN>/cabijs 
    
    

Here is an additional drop table script for Oracle:

 

ALTER SESSION SET NLS_SORT = BINARY_AI NLS_COMP = LINGUISTIC;
BEGIN
  FOR c IN ( SELECT table_name FROM user_tables WHERE table_name LIKE 'QUARTZ%' OR table_name LIKE 'JI%' 
            OR table_name LIKE 'ProfilingRecord' 
            OR table_name LIKE 'qrtz_job_details'
            OR table_name LIKE 'qrtz_simple_triggers'
            OR table_name LIKE 'qrtz_cron_triggers'
            OR table_name LIKE 'qrtz_simprop_triggers'
            OR table_name LIKE 'qrtz_blob_triggers'
            OR table_name LIKE 'qrtz_calendars'
            OR table_name LIKE 'qrtz_paused_trigger_grps'
            OR table_name LIKE 'qrtz_scheduler_state'
            OR table_name LIKE 'qrtz_fired_triggers'
            OR table_name LIKE 'qrtz_locks'
            OR table_name LIKE 'qrtz_triggers')
  LOOP
    EXECUTE IMMEDIATE 'DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS';
  END LOOP;
END;

 

Additional Information

Accessibility Error running Cabi report or UIM Dashboard " Cabi is not available or accessible"

How to Create certificates for OC, AC, and Cabi server in UIM and fix the certificate error " Your connection is not private"