Service Manager was unresponsive for a while when editing the Outage

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Service Manager was unresponsive for a while when editing the Outage (Outage Editor).

And the following message was displayed in the Outage Details:

SPC-OCC-12008: A critical problem was detected on the resource: DEVICE HAS STOPPED RESPONDING TO POLLS

 

 

Environment

Release : 21.2

Resolution

Optimize the Service Manager (SM) tables.

1. Open bash shell (bash -login)

2. Navigate to the $SPECROOT/mysql/bin/ directory

$ cd mysql/bin

3. Connect to the MySQL command prompt.

$ ./mysql.exe -uroot -proot reporting

4. Run the following optimize command for each table at a time (one by one): 

optimize table sm_attributes;
optimize table sm_customermhs;
optimize table sm_customers;
optimize table sm_guaranteeoutages;
optimize table sm_guaranteeperiods;
optimize table sm_monitormaps; 
optimize table sm_monitoroutages;
optimize table sm_monitors;    
optimize table sm_periods;    
optimize table sm_policies;
optimize table sm_resourcecauses;
optimize table sm_resourcemaps;
optimize table sm_resources;
optimize table sm_schemaversion;
optimize table sm_servicehealth;
optimize table sm_slaperiods;
optimize table sm_slas;     
optimize table sm_slmagreesto;
optimize table sm_slmlandscapes;
optimize table sm_slmmonitors;
optimize table sm_slmowns; 
optimize table sm_slmuses;
optimize table sm_users;
optimize table sm_usersmhs;