Getting Exception when accessing Exception Report

I am getting below error when accessing Exceptions page under Tools. Looks like some sqlconnection issue. I am able to access all the pages without any issue but only exception page i ma getting the error. Is anyother connectionstring avaibale for exception report alone?

 

[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]

   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +392

   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +815

   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515

   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61

   System.Data.SqlClient.SqlDataReader.get_MetaData() +138

   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6738869

   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +6741487

   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +586

   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +107

   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288

   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +237

   Telligent.Evolution.Data.SqlCommonDataProvider.GetExceptions(Int32 exceptionType, Int32 minFrequency, Int32 sortOrder, Boolean includeUnknown) +672

   Telligent.Evolution.Components.CSException.GetExceptions(Int32 exceptionType, Int32 minFrequency, Int32 sortOrder, Boolean includeUnknown) +48

   Telligent.Evolution.ControlPanel.Tools.ExceptionsReport.Bind() +2340

   System.EventHandler.Invoke(Object sender, EventArgs e) +0

   Telligent.Common.Diagnostics.Tracing.Web.TraceablePage.OnLoadComplete(EventArgs e) +116

   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4018

Thanks,

Puvi

  • We got this error in the past when we had over 2 million exceptions in the exceptions table (we have been running since 2007).  We had to login to Sql Management Studio and purge the exception table in order to not have it time out.

Related