Network Management

Database maintenance stops with index errors

This article provides details regarding database maintenance not completing due to a "index entry error".

First published date

11/16/2018 5:13 PM

Last published date

3/4/2025 4:19 PM

Overview

Database maintenance shows the following issue in swdebugMaintenance.log and the rest of the procedures do not run:

System.Data.SqlClient.SqlException (0x80131904): Unable to find index entry in index...The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.

Product section

Orion Platform

Cause

This could be due to a Microsoft SQL Server bug:
- https://support.microsoft.com/en-us/help/2878968/fix-nonclustered-index-corruption-may-occur-when-you-run-a-complex-upd
Some sort of database corruption, either in-memory or on disk.

Resolution

The particular procedure that resulted in the error may be: apm_dbm_APM_ApplicationStatus_DetailToHourly. However, this can also happen with other procedures in Database Maintenance.

Please note that this issue is specific to the SQL database and not to the SolarWinds Platform application or any of its modules. We may utilize SQL as many other vendors do, but Microsoft provides support for actual issues with SQL, its deployment, and its environment.

If you have an SQL DBA, contact them regarding this error and have them confirm the database is healthy and that the disk(s) the database is stored on is fine. If you have no DBAs, SolarWinds strongly recommends contacting Microsoft for assistance with correcting or repairing the database.

Please, be aware that SolarWinds Technical Support does not include the development of custom scripts, reports, templates, SQL queries, perform analysis of or troubleshoot performance problems related to third-party products, or SQL or Operating System issues…

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.