Return
-
Title
The number of values in collection 'LiteSpeed Activity' has exceeded the limit. -
Description
Error is in SpotLight, not LiteSpeed. Screenshot attached. Component: LiteSpeed Backup History The following error occurred while collecting data The number of values (76995) in collection 'LiteSpeed Activity' has exceeded the limit of 10000 Error Code:13 Table: LiteSpeed Activity -
Cause
Too many rows being returned by Spotlight query of LiteSpeed Activity table. Issue introduced in Spotlight on SQL Server Enterprise edition 10.0.1. When accessing the Database Drilldown page, selecting a DatabaseName from the top section, and then selecting the LiteSpeed Backups tab in the Database Details tab on the lower half of the page, a caution icon shows with the message "Litespeed activity has exceeded limit of 10000..."
In addition to this, Spotlight's query might be blocking LiteSpeed backups. Spotlight alerts that LiteSpeed Backups Failed, and LiteSpeed Backup Warnings seems to be blocking LiteSpeed backups. -
Resolution
See Spotlight KB article SOL120616. Patch information for Spotlight on SQL Server Enterprise Edition version 10.0.1 is included in the solution. Link to solution below:
https://support.quest.com/spotlight-on-sql-server-enterprise/kb/120616
-
Defect ID
None