0 Replies Latest reply on Aug 2, 2012 12:21 PM by phreakingeek

    APM SQL Insert issue with monitors

    phreakingeek

      Hello All,  I'm having an issue with APM creating or using any of the monitors.  When I try to create or import i get the attached message:

      "Cannot insert the value NULL into column 'Dirty', table 'SolarWindsOrion.odb.APM_ComponentTemplate'; column does not allow nulls. Insert fails.

      Followed by 6 lines of

      "Cannot insert the value NUL into column 'ComponentTemplateID', table 'SolarWinds.odb.APM_ComponentTemplateSetting'; column does not allow nulls. Insert fails.

       

      I've done nothing to alter the config of the DB.  I was able to add, remove, and customize the APM monotors without issue before.  I tried to remove and reinstall the APM app, but it did not fix the issue.  

       

      APM_Error.JPG

       

       

       

       

       

       

       

       

       

      Environment:

      Windows Server 2008 R2 SP1

      SQL Express 2008 R2
      APM 4.0.2 SP 1