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.
Windows Server 2008 R2 SP1
SQL Express 2008 R2
APM 4.0.2 SP 1