Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
Updated June 9, 2016
This article goes over an error that can occur during the configuration wizard or any other database update where it fails with the following error:
2016-05-24 08:07:10,216  ERROR DBConfigProcessor - Error while executing script - Warning: Fatal error 824 occurred at May 24 2016 8:07AM. Note the error and time, and contact your system administrator..
Error details: System.Data.SqlClient.SqlException (0x80131904): Warning: Fatal error 824 occurred at May 24 2016 8:07AM. Note the error and time, and contact your system administrator.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.ExecuteSqlBatch(IDbConnection connection, String sqlQuery, ConfigurationLogDelegate configLog)
Failing Sql command:
The issue is caused by the SQL server where it is at a point where it cannot process or read\write data to and from the disk it is utilizing. This means that either there is something specifically wrong in the SQL itself or more likely, there is something wrong with the disk where the data is being written.
Please note that this issue is specific to the SQL database and not with the Orion application or any of its modules. We may utilize SQL as many other vendors do, but for actual issues with SQL, it's deployment and environment, the support on that resides with Microsoft.
This issue is specifically with the SQL database, so there may be other possible ways to resolve this issue. One such method is this:
What you can do is the following: