Return
-
Title
Seeing this informational message in alarms: Failed to convert value 'FG' from column 'type' into long -
Description
Information Monitored Server - SQL Server Collection Execution Failure Collection 'Health Check- Master Files' failed : Failed to convert value 'FG' from column 'type' into long -
Resolution
WORKAROUND:
Spotlight does its maintenance job at 3:00 AM. If you have a job that runs at 3:00 AM, it'll result in this error. Changing the Spotlight database maintenance schedule to another time may solve the issue. The Spotlight databases maintenance schedule can be adjusted from "Configure | Diagnostic Server | Database maintenance schedule."If the above suggestion doesn't help, you may filter out these alarms using the Alarm Actions. You can use "The details contain" to filter out key words from the error message. And you can use "Decrease the severity" or "Suppress the alarm" as the resulting action.STATUS:Waiting for fix in a future release of Spotlight on SQL Server Enterprise. -
Defect ID
DS-870