Alerts causing reaper to crash or stop.

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Alerts are crashing the reaper service. Reaper service crashes and won't restart.

Environment

RA/NFA windows 2008, windows 2012

Cause

Anytime that an alert is edited in the console, the alerts deploy and entries are created in the harvester.trap_definitions table for each alert/interface in the reporter.trap_definitions table.  Within seconds of the alerts deploying, the reaper crashes again. 

 

Viewed the harvester.paramater_descriptions table and there are two parameters there that were both enabled.

 

RealtimeReaper_RunAlarms = 1

Reaper_RunAlarms = 1

 

Verified on other servers and it was consistent that only the Reaper_RunAlarms = 1 was enabled.

 

Disabled the one on the customer’s site and the Reaper service stopped crashing.

 

We modified an existing alarm and created another new alarm.

They all sent alarms and emails with no problems.

Resolution

RDP to the Harvester server(s) and do the the following.

 

Open a windows command prompt.

Type:

mysql harvester

create table parameter_descriptions_BK (select * from parameter_descriptions);

update parameter_descriptions set DefaultValue="0" where Parameter="RealtimeReaper_RunAlarms";

update parameter_descriptions set DefaultValue="1" where Parameter="Reaper_RunAlarms";

exit

Restart  "CA MySql"  service.

Test the alerts.

Additional Information

Reference case #00729685