0 Replies Latest reply: Nov 7, 2012 8:58 AM by brentil RSS

    Intermitent DBAccessError after upgrade to NSM 7.1

    brentil

      So we upgraded our appliance to Windows 2008 R2 & NSM 7.1.3.5 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
      Source:srleap:AlertDAO
      Condition Type:DBAccessError
      Alarm Type:Management
      Severity:Critical
      Last Occurrence Time:2012-Nov-07 09:12:10 EST
      Acknowledged:
      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