Error in Spotlight collection: "Collection 'Long running SQL' failed." (4281091)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error in Spotlight collection: "Collection 'Long running SQL' failed."
Description

User recently upgraded to version 11 and one of the connections is alerting with the following error:
"Collection 'Long Running SQL' failed: Traceback (innermost last): File 'longrunningsql', line 1, in ? java.lang.AssertionError: Rule"
A long running SQL does not exist and user has tried to acknowledge it, however, alarm error continues to persist.
Resolution

WORKAROUND
1. Open Configure | Alarms dialog
2. Choose database name
3. Select "SQL – Long Running SQL" alarm
4. Uncheck "Override the default settings for the alarm" option
STATUS

Waiting for future fix in Spotlight on SQL Server Enterprise.
Defect ID

SOSSE-3950

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title