Edit custom metric BadImageformatException HRESULT 0x800700B

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Edit custom metric BadImageformatException HRESULT 0x800700B

Postby sean.alexander@ontario.ca » Wed Mar 28, 2012 6:03 pm

Trying to edit any custom metrics, when I press "save changes", I get the following error:

Code: Select all
/Configuration/Custom-Metrics/Edit/5: 500 error
System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
at System.Reflection.MetadataImport._GetDefaultValue(IntPtr scope, SkipAddresses& skipAddresses, Int32 mdToken, Int64& value, Int32& length, Int32& corElementType)
at System.Reflection.MdConstant.GetValue(MetadataImport scope, Int32 token, RuntimeTypeHandle fieldTypeHandle, Boolean raw)
at System.Reflection.RuntimeParameterInfo.GetDefaultValue(Boolean raw)
at System.Reflection.RuntimeParameterInfo.get_RawDefaultValue()
at System.Web.Mvc.ParameterInfoUtil.TryGetDefaultValue(ParameterInfo parameterInfo, Object& value)
at System.Web.Mvc.ReflectedParameterDescriptor.get_DefaultValue()
at System.Web.Mvc.ControllerActionInvoker.GetParameterValue(ControllerContext controllerContext, ParameterDescriptor parameterDescriptor)
at System.Web.Mvc.ControllerActionInvoker.GetParameterValues(ControllerContext controllerContext, ActionDescriptor actionDescriptor)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
at System.Web.Mvc.Controller.ExecuteCore()
at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
at System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext)
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.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


Configuration > About
(Note: I have tried not using a 32-bit application pool as well, it was initially setup as not allowing 32-bit applications)

Windows Version: Windows 2008 R2

Web Server
Version: 3.0.0.1573
Web Server: Microsoft-IIS/7.5
Server Name: http://QRST:31337
Server HOST .NET: .NET 3.5 SP 1
Server Path: D:\\Websites\\DEV\\SQLMonitor-Port-31337
Hosted Environment: 32Bit
User: ABCD\\WXYZ$

Base Monitor
Version: 3.0.0.1573
Base Monitor: localhost:31338
Install Location: D:\\Program Files\\Red Gate\\SQL Monitor 3\\BaseMonitor
Host Environment: 64Bit
User: ABCD\\EFGH
Domain: ABCD
Database: (local) *** RedGateMonitor


This happens on all custom metrics.
sean.alexander@ontario.ca
 
Posts: 6
Joined: Wed Mar 28, 2012 5:54 pm

Postby fionag » Thu Mar 29, 2012 9:55 am

Sean
Sorry to hear you are having problems. We have already raised a bug for this (SRP-6398) and believe we have a fix. We only have 1 machine here where we see this same issue, so once we have confirmed the fix we will aim to get a release out with this in.
I will update again when we have something more concrete.
Thanks, Fiona
fionag
 
Posts: 32
Joined: Thu Jan 05, 2012 5:40 pm
Location: Red Gate

Postby fionag » Fri Mar 30, 2012 12:03 pm

Sean
We are trying to further understand the cause of this issue and have a couple of questions:
1) What versions of .NET do you have installed on the machine(s).
2) Assuming the web and base monitors are on different machines are they both on Windows 2008 R2 (specifically the R2 part)?
Many thanks
Fiona
fionag
 
Posts: 32
Joined: Thu Jan 05, 2012 5:40 pm
Location: Red Gate

Postby fionag » Tue Apr 03, 2012 10:11 am

Hi Sean
We have released a bug-fix release that will hopefully resolve this issue. You can download it here
http://www.red-gate.com/products/dba/sql-monitor/download
Please let us know if this doesn't resolve your issue.
Best regards
Fiona
fionag
 
Posts: 32
Joined: Thu Jan 05, 2012 5:40 pm
Location: Red Gate

Re:

Postby sean.alexander@ontario.ca » Wed Apr 11, 2012 6:06 pm

fionag wrote:Sean
We are trying to further understand the cause of this issue and have a couple of questions:
1) What versions of .NET do you have installed on the machine(s).
2) Assuming the web and base monitors are on different machines are they both on Windows 2008 R2 (specifically the R2 part)?
Many thanks
Fiona


Sorry I missed this question,

32-bit:
v2.0.50727
3.5
v4.0.30319

64-bit:
v2.0.50727
3.5
v4.0.30319

The Web/Base monitor are on the same machine with IIS 7.5, and SQL Server 2008 R2.

The latest update resolved this issue, and in addition the "custom email over ride not working" is also resolved.

Great work!
sean.alexander@ontario.ca
 
Posts: 6
Joined: Wed Mar 28, 2012 5:54 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests