Nov
5
2011

SQL 2005 Maintenance plan multiple errors: System.MissingMethodException: Method not found: ‘Boolean Microsoft.SqlServer.

Today while fixing SQL 2005 SP2 (9.00.3042) maintenance plan issues, came across three errors, first error is due to dts dll not registered properly, whereas second one is occuring when trying to create/edit schedule or creating a maintenance plan thorugh Wizard mode. Read below to understand the issue and how it is fixed.


1. While trying to open maintenance plan, recieved following error,

To fix this error, I have used the technique which I have described in one of my earlier post available at following link.

Above link says, you need to register the dts.dll file using following command: regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”


2. Once above error is fixed, maintenance plan were opening fine and jobs started working perfectly, but another error started coming while changing schedule, please find error screenshot below,

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.MissingMethodException: Method not found: ‘Boolean Microsoft.SqlServer.Management.SqlMgmt.JobScheduleData.UpdateSourceSchedule()’.
at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.ChangeShedule()
at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.grid_MouseButtonClicked(Object sender, MouseButtonClickedEventArgs args)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.OnMouseButtonClicked(Int64 nRowIndex, Int32 nColIndex, Rectangle rCellRect, MouseButtons btn)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.HandleButtonLBtnUp(Int32 X, Int32 Y)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.ProcessLeftButtonUp(Int32 x, Int32 y)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3620 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
—————————————-
AppIDPackage
Assembly Version: 9.0.242.0
Win32 Version: 9.00.2047.00
CodeBase: file:///D:/MSSQLSRV2K5/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
—————————————-
.
.
.
.
.
.
..

—————————————-
msddslmp
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/msddslmp/8.0.0.0__b03f5f7f11d50a3a/msddslmp.dll
—————————————-
DdsShapesLib
Assembly Version: 9.0.242.0
Win32 Version: 9.0.242.0
CodeBase: file:///D:/MSSQLSRV2K5/90/Tools/Binn/VSShell/Common7/IDE/DdsShapesLib.DLL
—————————————-
VSLangProj
Assembly Version: 7.0.3300.0
Win32 Version: 7.00.9466
CodeBase: file:///C:/WINDOWS/assembly/GAC/VSLangProj/7.0.3300.0__b03f5f7f11d50a3a/VSLangProj.dll
—————————————-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:



When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Error Screenshot:

To fix above error, followed following link,
http://www.sqlservercentral.com/Forums/Topic541955-146-1.aspx

Issue and resolution was: Database and client tools are not on same version, this problem can occur when you will upgrade only database version while leaving client tools intact, best possible solution is to apply Sp2 for client tools, otherwise to fix other maintenance plan issues which started occuring since SP2, apply SQL Server 2005 SP2 CU6 or upgrade it to latest service pack which is SP4 (at the time of writing this post). Once you upgrade both server and client tools, this problem will stand solved.

A very good article provided by microsoft which tells how to check Client and Server versions: http://support.microsoft.com/kb/321185 i.e. for server version execute select @@version and for client tools, go to SSMS and go to Help>About > it will list version details.

In my case:
Server version was: 9.00.3042
Client version was: 9.00.2047


3. Along with above error, there was third error which was occuring when creating a new maintenance plan using wizard mode, error was,

Error Screenshot:

To fix above error, followed following link,
http://www.sqlservercentral.com/Forums/Topic541955-146-1.aspx

Issue and resolution was: Database and client tools are not on same version, this problem can occur when you will upgrade only database version while leaving client tools intact, best possible solution is to apply Sp2 for client tools, otherwise to fix other maintenance plan issues which started occuring since SP2, apply SQL Server 2005 SP2 CU6 or upgrade it to latest service pack which is SP4 (at the time of writing this post). Once you upgrade both server and client tools, this problem will stand solved.

A very good article provided by microsoft which tells how to check Client and Server versions: http://support.microsoft.com/kb/321185 i.e. for server version execute select @@version and for client tools, go to SSMS and go to Help>About > it will list version details.

In my case:
Server version was: 9.00.3042
Client version was: 9.00.2047


Final verdict: When I connected to SQL server remotely from correct client version, everything worked like a charm! 🙂 so you now know what to do!

Download PDF

Related Posts

About the Author: Nitin Garg

Indian born, trekker, biker, photographer, lover of monsoons... I love to blog the topics I research and find useful for self or online community to save time and energy :) Everything you read on my blog is my own personal opinion!

1 Comment + Add Comment

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 184 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

July 2019
M T W T F S S
« Nov    
1234567
891011121314
15161718192021
22232425262728
293031  

View Post by Categories

%d bloggers like this: