The number of values in collection 'LiteSpeed Activity' has exceeded the limit.
说明
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
原因
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.
解决办法
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:
