ERROR RedGate.Response.UI.Website.Controllers [(null)]

zidvbelju

We have been experiencing the following error for months. Can anyone shed any light on this?

Event: '2013-07-10 18:01:57,601 [11] ERROR

RedGate.Response.UI.Website.Controllers [(null)] - Executed:

AlertDetails returned System.Web'
Cleared by: 'admin'
At: 2013/08/28 15:24:24.000
Device: ********
Component: SQL Monitor 3
Severity: Error
Message:
2013-07-10 18:01:57,601 [11] ERROR

RedGate.Response.UI.Website.Controllers [(null)] - Executed:

AlertDetails returned System.Web.Mvc.EmptyResult threw unhandled

exception System.ArgumentException: The parameters dictionary

contains a null entry for parameter 'range' of non-nullable type

'System.Int32' for method 'System.Web.Mvc.JsonResult AlertDetails

(System.String, System.DateTime, Int32)' in

'RedGate.Response.UI.Website.Controllers.TopQueriesController'. An

optional parameter must be a reference type, a nullable type, or be

declared as an optional parameter.
Parameter name: parameters
at System.Web.Mvc.ActionDescriptor.ExtractParameterFromDictionary

(ParameterInfo parameterInfo, IDictionary`2 parameters, MethodInfo

methodInfo)
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
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.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)

chriskelly

Unfortunately, there isn't much information in the error message.

Please can you send the SQL Monitor error logs, as described in this document, to support@red-gate.com and quote the ticket number #9612 in the subject line. Can you also describe how the error manifests itself?

http://documentation.red-gate.com/pages ... d=17270678

chriskelly

Thank you for sending me your log files. First, can I recommend that you upgrade to the latest version of the tool. The log files indicate that you are using version 3.4. I have included the download link for version 3.5 below. Once installed can you test it to see if you get the same behaviour.

ftp://support.red-gate.com/patches/SqlM ... .0.497.zip