Red Gate forums :: View topic - Error Occurred...
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Error Occurred...

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
maddave



Joined: 11 Apr 2013
Posts: 17

PostPosted: Thu Sep 05, 2013 9:05 am    Post subject: Error Occurred... Reply with quote

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:

Code:

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)
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 308
Location: Cambridge, UK

PostPosted: Fri Sep 06, 2013 11:17 am    Post subject: Reply with quote

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?
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
maddave



Joined: 11 Apr 2013
Posts: 17

PostPosted: Fri Sep 06, 2013 11:41 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group