Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > 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

Tags

Classifications

Public