So we upgraded our appliance to Windows 2008 R2 & NSM 220.127.116.11 using the provided upgrade package from McAfee. Everything was working fine for about a week then all of a sudden the system stopped recording alerts and logged the following Critical event and it keeps logging it each time it tries to log a High event.
|Fault Type:||Alert save failed|
|Last Occurrence Time:||2012-Nov-07 09:12:10 EST|
|Additional Text:||The Manager was unable to access the alert tables in the database. Error Message: No value specified for parameter 52.|
|Creation Time:||2012-Nov-04 00:27:30 EDT|
At first I thought it was the scripts that massage the data if you have over a million records so I exported the Configuration Only tables and then uninstalled NSM 7.1, installed a fresh copy, and then imported the Config Data and everything works fine for a day or two then it throws the error again and stops logging alerts. Restarting all of the NSM services seems to clear it out for a while but then it just comes back again.
Message was edited by: brentil on 11/7/12 9:58:04 AM GMT-05:00