Alarm error should not affect data collections and can be suppressed.
WORKAROUND:
Perform steps to suppress these alarms:
1. From Configure tab on top of the screen click Alarm Actions option
2. Click New and enter a rule name such as Spotlight Error Alarms
3. Enable “The alarm is” condition and click ‘alarms’ link at the bottom pane. Expand SQL Server alarms and enable ‘Monitored Server - SQL Server Collection Execution Failure’ alarm and click OK
4. Enable “The details contain” condition, and click ‘following phrases’ link at bottom pane
5. Click Add and enter:
CommandInBody
6. Click OK and OK
7. Enable “Suppress alarm” action and click OK to save and close Alarm Action rule
STATUS:
Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from
here.