Network Management
The Orion database is corrupted
You experience different errors in SolarWinds Platform products related to database errors. Additionally, an error message asking to run the DBCC CHECKDB command appears in the SQL server logs.
First published date
Last published date
Overview
You experience different errors in SolarWinds Platform products, such as:
- The nightly database maintenance does not complete.
- Database maintenance tasks access excessive numbers of SolarWinds Platform database structures to consolidate statistical data, defragment indexes, etc.
- The product does not start or crash.
Additionally, an error message asking to run the DBCC CHECKDB command appears in the SQL Server log. Example of error messages seen in the SQL Server log:
Msg 823, Level 24, State 2, Line 2 The operating system returned error 1(Incorrect function.) to SQL Server during a read at offset 0x00001382b14000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\NetPerfMon.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Product section
Cause
Resolution
- Ask your database administrator (DBA) to investigate the issue and perform a full database consistency check, such as running the DBCC CHECKDB command with appropriate options.
- If your DBA cannot repair the database, you need to restore it from the backup before the issue occurred or create a new database from scratch.