• Become a portal pro
• Print
• My Downloads ()

• Support
• Knowledge Base
• Spotlight on SQL Server Enterprise

Error :"Repository Error: Updating the Spotlight Statistics Repository failed: Operation failed. The index entry of length bytes for index IX_cover_spotlight_stat_keys exceeds the maximum length bytes" (4299635)

×

Return

Feedback Submitted

Did this article solve an issue for you?

  Select Rating

• Title

  Error :"Repository Error: Updating the Spotlight Statistics Repository failed: Operation failed. The index entry of length bytes for index IX_cover_spotlight_stat_keys exceeds the maximum length bytes"

• Description

  Application error: "Repository Error: Updating the Spotlight Statistics Repository failed: Operation failed. The index entry of length bytes for index IX_cover_spotlight_stat_keys exceeds the maximum length bytes"

• Resolution

  Drop the index with the following command:
  
  DROP INDEX spotlight_stat_keys.IX_cover_spotlight_stat_keys 

  This index in not needed.

Feedback Submitted

Did this article solve an issue for you?

  Select Rating

Request a KB Article

×

Request a topic for a future Knowledge Base Article

Request a topic for a future Knowledge Base Article

Products

------ Please Select ------ Active Administrator Active Roles Active Roles Sync Service ApexSQL Analyze ApexSQL Audit ApexSQL Backup ApexSQL BI Monitor ApexSQL Build ApexSQL Compare ApexSQL Compare and Sync Toolkit Bundle ApexSQL Compare and Sync Toolkit Subscription ApexSQL Complete ApexSQL Data Diff ApexSQL Data Diff for MySQL ApexSQL Database Power Tools for VS Code ApexSQL Decrypt ApexSQL Defrag ApexSQL Devops Plus Toolkit Bundle ApexSQL DevOps Plus Toolkit Subscription ApexSQL DevOps Toolkit ApexSQL Devops Toolkit Bundle ApexSQL DevOps Toolkit Subscription ApexSQL Diff ApexSQL Diff for MySQL ApexSQL Discover ApexSQL Doc ApexSQL Doc for MySQL ApexSQL Doc Subscription ApexSQL Enforce ApexSQL Fundamentals Toolkit Bundle ApexSQL Fundamentals Toolkit for MySQL ApexSQL Fundamentals Toolkit Subscription ApexSQL Generate ApexSQL Job ApexSQL Log ApexSQL Manage ApexSQL Mask ApexSQL Model ApexSQL Monitor ApexSQL Operations Plus Toolkit Bundle ApexSQL Operations Toolkit Bundle ApexSQL Plan ApexSQL Propagate ApexSQL Pump ApexSQL Recover ApexSQL Refactor ApexSQL Script ApexSQL Search ApexSQL Source Control ApexSQL Source Control Subscription ApexSQL Trigger ApexSQL Unit Test ApexSQL VM Monitor Archive Manager Archive Manager for Exchange Archive Manager for Files Archive Shuttle Benchmark Factory for Database Change Auditor Code Tester for Oracle Coexistence Manager for Notes Collaboration Services Content Matrix ControlPoint Defender Directory Sync Pro for Active Directory Disaster Recovery for Identity Enterprise Reporter erwin Data Intelligence Cloud erwin Data Intelligence Suite erwin Data Modeler erwin Data Transformation erwin Enterprise Architect Agile erwin ER360 On Cloud erwin Evolve erwin Mart On Cloud erwin Sequence Essentials for Office 365 Foglight Foglight Cloud Foglight Evolve Foglight for Databases GoPlex NC-Access GPOADmin Identity Manager Identity Manager Data Governance Edition Identity Manager On Demand Identity Manager On Demand - Starling Edition InTrust IT Security Search KACE as a Service KACE Asset Management Appliance KACE Cloud KACE Desktop Authority KACE Service Desk KACE Systems Deployment Appliance KACE Systems Management Appliance KACE Unified Endpoint Manager LiteSpeed for SQL Server Live-Reorg MessageStats Migration Manager for AD Migration Manager for Exchange Migrator for Notes to Exchange Migrator for Notes to SharePoint Migrator Pro for Active Directory Migrator Pro for Exchange Multsess NC-Access NC-NIM NC-Pass NC-Pass Radius NC-Syncom Command NC-Syncom Password NCI NetVault NetVault Plus NetVault SmartDisk Nova On Demand Audit On Demand Migration On Demand Recovery One Identity Safeguard for Privileged Passwords One Identity Safeguard for Privileged Sessions ONELOGIN PAM Essentials Password Manager Privilege Manager for Unix Privileged Access Suite for Unix PST Flight Deck QoreStor Quick Connect for Active Directory Quick Connect for AS400 Quick Connect for Base Systems Quick Connect for Cloud Services Quick Connect for RACF Quick Connect Management Shell Quick Connect Sync Engine Rapid Recovery Recovery Manager for AD Recovery Manager for AD Disaster Recovery Edition Recovery Manager for AD Forest Edition Recovery Manager for Exchange Recovery Manager for Exchange - Data Protection Edition RemoteScan CheckCapture RemoteScan Enterprise RemoteScan Enterprise User Edition RemoteScan for LAN RemoteScan Terminal Services-Citrix RemoteScan Universal RemoteScan Universal User Edition Safeguard Authentication Services Safeguard for Privileged Passwords On Demand Safeguard for Privileged Sessions On Demand Safeguard for Sudo Safeguard On Demand Safeguard Privilege Manager for Windows Safeguard Remote Access Secure Copy Security Explorer Security Guardian Sensitive Content Manager SharePlex SharePlex Manager Space Manager with LiveReorg Spotlight on DB2 Spotlight on Oracle Spotlight on RAC Spotlight on SAP ASE Spotlight on SQL Server Enterprise Spotlight on Unix SQL Navigator for Oracle SQL Optimizer for DB2 LUW SQL Optimizer for DB2 ZOS SQL Optimizer for Oracle SQL Optimizer for SAP ASE SQL Optimizer for SQL Server Starling Cloud Assistant Starling Connect Stat StoragePoint syslog-ng Premium Edition syslog-ng Store Box Toad Data Modeler Toad Data Point Toad Data Point Subscription Toad Data Studio Toad Data Studio Subscription Toad DevOps Toolkit Toad Edge Toad for DB2 Toad for DB2 Subscription Toad for Oracle Toad for Oracle on Mac Toad for Oracle on Mac Subscription Toad for Oracle Subscription Toad for SAP Solutions Toad for SQL Server Toad for SQL Server Subscription Toad Intelligence Central TPAM Unified Communications Analytics Unified Communications Diagnostics vRanger

Topic

------ Please Select ------ Best Practices Policy and Procedures Configuration How To Installation Licensing Troubleshooting

Title

Description

Email Address

Submit

Leave a Comment

Send CommentMust select 1 to 5 star rating above in order to send comments

Thank you for your feedback for Topic Request

Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.

OK

×

Recommended Content

Product(s):

Spotlight on SQL Server Enterprise
13.1

Topic(s):

Troubleshooting

Article History:

Created on: 4/2/2020
Last Update on: 5/7/2023

Thank you for your feedback for Topic Request

Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.

OK

×

 Welcome to Quest Support

You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.

Search All Articles

© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center