Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Performance Monitor (NPM) > The Orion database is corrupted

The Orion database is corrupted

Updated April 10, 2017

Overview

You experience different errors in SolarWinds Orion products, such as 

  • The nightly database maintenance does not complete. 
  • Database maintenance tasks access excessive numbers of Orion database structures to consolidate statistical data, defragment indexes, etc.
  • The product does not start or crashes.

Additionally, an error message asking to run DBCC CHECKDB command appears in the SQL server logs.

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.

 

Environment

  • Any Orion Platform product

Cause

The cause of these problems can vary from file system corruption, underlying hardware system issues, driver issues, corrupted pages in memory, or problems with the SQL Server Engine.

 

Resolution

Ask your database administrator to investigate the issue and perform a full database consistency check, such as running the DBCC CHECKDB command with appropriate options.

 

 

Last modified
15:40, 10 Apr 2017

Tags

Classifications

Public