Error Occurred...

maddave

Hi, I am not sure if this is something caused by my setup, or the product.

Throughout the day, whilst the SQL Monitor webpage is open, I get errors when the page auto refreshes. A full F5 refresh of the browser resolves the issue, but this is happening more and more lately. Could anyone assist in what could be causing the problem?

Here is the error from the exception:

An error has occurred. Try refreshing the page: the problem may be temporary. Error details

    /GlobalOverview/GlobalData: 500 Internal Server Error
    #5jv.#mkv: System.Data.SqlClient.SqlException was thrown by method Query on service DataPresenterService:
    System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
    at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
    at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
    at System.Data.SqlClient.TdsParserStateObject.ReadByte()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName)
    at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)
    at #Zfdc.#4fdc.#mFA(IsolationLevel )
    at #I0qb.#8UBc.#5Ev(#Vfdc , IDictionary`2 , #IJv , #Shv , PropertyKind , IEnumerable`1 , #hjv )
    at #I0qb.#8UBc.#eBv(#Vfdc , #hjv , #IJv , #u0B )
    at #I0qb.#8UBc.#z2.#Bwv(#IJv , #u0B )
    at #Phv.#ajv.#y2.#BdR(#IJv , #u0B )
    at #Phv.#ajv.#Pvv(#CJv , #IJv , #hjv , Func`3 )
    at #Phv.#ajv.#Pvv(#CJv , #IJv , #hjv , Func`3 )
    at #Phv.#ajv.#Pvv(#hjv , Func`3 )
    at #I0qb.#8UBc.Query(#Kru , #Aru , #hjv , #hjv )
    at #I0qb.#zov.Query(#Kru , #Aru , #hjv , #hjv )
    at #Ehv.#Dhv.Query(#nxY , #Aru , #hjv , #hjv )
    at #Zmv.#6Jw.Query(#Kru , #Aru , #hjv , #hjv )
    at #Zmv.#6Jw.Query(#Kru , #Aru , #hjv )
    at #Mlv.#bmv.Query(ChannelTreeMessage`1 )
    at #Zjv.#jkv.#cxv(String , MethodInfo , Object[] )
    at RedGate.Response.Common.Networking.Client.RpcSynchronousTcpChannel.#cxv(String , MethodInfo , Object[] )
    at RedGate.Response.Common.Networking.Client.RpcProxyGenerator.#lkv.Intercept(IInvocation )
    at Castle.DynamicProxy.AbstractInvocation.Proceed()
    at Castle.Proxies.IDataPresenterServiceProxy.Query(ChannelTreeMessage`1 rootQueryTreeMessage)
    at #Mlv.#1lv.Query(Unit , IStatusLogger , #hjv )
    at RedGate.Response.UI.Website.Extensions.DataPresenterExtensions.GetChannel(IEnumerable`1 propertyNames, #v0B channelQueryTreeBuilder, IDataPresenter`1 dataPresenter)
    at RedGate.Response.UI.Website.Extensions.DataPresenterExtensions.GetRootChannel(IDataPresenter`1 dataPresenter, #y1B queryRange, IEnumerable`1 propertyNames)
    at RedGate.Response.UI.Website.Controllers.GlobalOverviewController.GlobalData(Nullable`1 date, String groupName)
    at lambda_method(ExecutionScope , ControllerBase , Object[] )
    at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
    at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassd.<InvokeActionMethodWithFilters>b__a()
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
    at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
    at System.Web.Mvc.Controller.ExecuteCore()
    at System.Web.Mvc.MvcHandler.<>c__DisplayClass8.<BeginProcessRequest>b__4()
    at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
    at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
    at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
    at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

chriskelly

Can you confirm the web browser and version you are using? and whether you are using the supplied Mono XSP WebService service or IIS? Have you tried an alternative web browser and does this show the same behaviour?

maddave

Hi,

I am using Firefox 23, but we have a monitoring pc which uses IE 9 and the same thing happens on there.

I am using the supplied XSP webservice.

I cannot pin down how often this happens, roughly 4 or 5 times a day, and it is not a massive problem as just manually refreshing the page solves it. However it would be good to resolve it on the monitoring pc so I dont have to keep logging on to refresh it! (i.e. I'm lazy!)

Thanks.