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) > Basic troubleshooting files are missing in the Orion Diagnostics directory

Basic troubleshooting files are missing in the Orion Diagnostics directory

Updated July 11, 2017

Overview

This article describes an issue where required files for basic troubleshooting such as logs and spreadsheets are missing from their normal location in the Orion Diagnostics directories.

There are error messages similar to the following in the %SolarwindsDiagnostics%\LogFiles\Orion\DiagnosticsswDiagnostics.log file:

 

XXXX-XX-XX XX:XX:XX,XXX [18] ERROR SolarWinds.Diagnostics.DatabaseQueryTask - Failed to query the database (Get collation for Model database).  C:\Program Files (x86)\SolarWinds\Orion\Orion.Diagnostics (line 342)
System.Data.SqlClient.SqlException (0x80131904): The server principal "Solarwinds" is not able to access the database "model" under the current security context.
   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.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at SolarWinds.Diagnostics.DatabaseQueryTask.RunOutputResultset(ZipOutputStream zipStream)
ClientConnectionId:3f58e251-ecae-4637-b612-32791d1f406d
Error Number:916,State:1,Class:14

 

XXXX-XX-XX XX:XX:XX, XXX [16] ERROR SolarWinds.Diagnostics.DatabaseQueryTask - Failed to query the database (Collect SQL Server log files.).  C:\Program Files (x86)\SolarWinds\Orion\Orion.Diagnostics (line 1650)
System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'xp_enumerrorlogs', database 'mssqlsystemresource', schema 'sys'.
   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.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at SolarWinds.Diagnostics.DatabaseQueryTask.RunOutputResultset(ZipOutputStream zipStream)
ClientConnectionId:d3cfc868-f0ec-4698-8e6d-cbbb4a859135
Error Number:229,State:5,Class:14

Environment

All Orion Platform environments and products

Cause 

This issue is caused by improper database collation or database user permissions to the SolarWinds Orion SQL database.

Resolution

See the Fix the required permission to the database issue in configuration wizard article to address the database permission errors that causes Orion Diagnostics to not completely generate data.

See the Supported SQL collations article regarding proper database collation.

 

Last modified
18:44, 10 Jul 2017

Tags

Classifications

Public