Geeks With Blogs
Nut and Bolts Trials and tribulations recorded.
SQL Agent Jobs Fails - Event ID 208
Monday, May 12, 2008
9:40 AM
 
 
Error when attempting to open a step in a (previously created) SQL Server job definition using SQL Server 2005 Management Studio:
 
 

Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

------------------------------

ADDITIONAL INFORMATION:

 

Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

 
From the additional technical data button on previous dialog:
 
 
 
Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)
 
------------------------------
Program Location:
 
   at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
   at Microsoft.DataTransformationServices.DTSExecUI.Controls.LoggingCtrl..ctor(IDTSExecViewManager treePanel)
   at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.InitializeControls()
   at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition..ctor(CDataContainer dataContainer, IMessageBoxProvider messageProvider)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepSubSystems..ctor(CDataContainer dataContainer, JobStepData data, IMessageBoxProvider messageProvider)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.get_SubSystems()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeStepCombo()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeData()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.OnInitialization()
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node)
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SelectCurrentNode()
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.InitializeUI(ViewSwitcherTreeView treeView, ISqlControlCollection viewsHolder, Panel rightPane)
   at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
   at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(ISqlControlCollection control, IServiceProvider provider)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobSteps.newJob_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.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)
 
 
Manual execution of the job in question:
 
 
  
Execution of job 'FullServerMaintenancePlan.Database Backup Subplan' failed. See the history log for details.
 
Windows eventlog on hosting server:
 
 
 
 
Event Type:        Warning
Event Source:        SQLAgent$TSDMOSS
Event Category:        Job Engine
Event ID:        208
Date:                5/12/2008
Time:                2:00:00 AM
User:                N/A
Computer:        USRES-TSDMOSS03
Description:
SQL Server Scheduled Job 'FullServerMaintenancePlan.Database Backup Subplan' (0xD7B443DA1F81B64FB82E39A7176FA249) - Status: Failed - Invoked on: 2008-05-12 02:00:00 - Message: The job failed. The Job was invoked by Schedule 6 (FullServerMaintenancePlan.Database Backup Subplan). The last step to run was step 1 (Database Backup Subplan).
 
(No Errors found in any SQL Server Logs)
 
 
Actions
 
1.    Ran SQL Server SP2, updates 3152, 3159 against installed SQL Server.
 
After updates, attempted to edit an existing step. Got the following error:
 
 
 
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)). (Microsoft.SqlServer.ManagedDTS)
 
 
 
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)). (Microsoft.SqlServer.ManagedDTS)
 
------------------------------
Program Location:
 
   at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
   at Microsoft.DataTransformationServices.DTSExecUI.Controls.LoggingCtrl..ctor(IDTSExecViewManager treePanel)
   at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.InitializeControls()
   at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition..ctor(CDataContainer dataContainer, IMessageBoxProvider messageProvider)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepSubSystems..ctor(CDataContainer dataContainer, JobStepData data, IMessageBoxProvider messageProvider)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.get_SubSystems()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeStepCombo()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeData()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.OnInitialization()
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node)
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SelectCurrentNode()
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.InitializeUI(ViewSwitcherTreeView treeView, ISqlControlCollection viewsHolder, Panel rightPane)
   at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
   at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(ISqlControlCollection control, IServiceProvider provider)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobSteps.editJob_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.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)
 
2.    Manually register the library in question:
 
a.    Search registry for the GUID entries. Found:
 
Windows Registry Editor Version 5.00
 
[HKEY_CLASSES_ROOT\Interface\{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}]
@="IDTSContainer90"
 
[HKEY_CLASSES_ROOT\Interface\{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}\ProxyStubClsid]
@="{00020424-0000-0000-C000-000000000046}"
 
[HKEY_CLASSES_ROOT\Interface\{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}\ProxyStubClsid32]
@="{00020424-0000-0000-C000-000000000046}"
 
[HKEY_CLASSES_ROOT\Interface\{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}\TypeLib]
@="{D1D9A51E-B4FE-420B-97B1-28A383EF9168}"
"Version"="1.0"
 
=======================================================================
 
Windows Registry Editor Version 5.00
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}]
@="IDTSContainer90"
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}\ProxyStubClsid]
@="{00020424-0000-0000-C000-000000000046}"
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}\ProxyStubClsid32]
@="{00020424-0000-0000-C000-000000000046}"
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}\TypeLib]
@="{D1D9A51E-B4FE-420B-97B1-28A383EF9168}"
"Version"="1.0"
 
 
==========================================================================
 
 
RESOLUTION
 
It turns out that the unregistered COM in dts.dll located in C:\Program Files\Microsoft SQL Server\90\DTS\binn. I ran the following from the command line:
 
REGSVR32.EXE dts.dll
 
in the aforementioned directory.
Posted on Friday, June 6, 2008 12:04 PM SQL Server 2005 | Back to top


Comments on this post: SQL Agent Jobs Fails - Event ID 208

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
Thanks for this excellent solution. Worked perfectly (i did have to restart server, guess I could have just restarted teh services).
Left by Simon Hayes on Sep 27, 2008 5:36 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
Thanks for this excellent solution.
Left by Feedback on Mar 22, 2010 3:47 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
This solution works for SQL 2008 R2 also.
Thanks
Left by Wielligh on May 21, 2010 1:47 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
This solved our problem on SQL Server 2005. We just restarted SQL Agent service instead of rebooting. Thank you! :)
Left by Michelle Ufford on May 26, 2010 9:00 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
Thanks! As with the rest of the comments, this worked perfectly and resolved the issue! This problem occurred on my system after installing SQL Server 2005 workstation components after I already had SQL Server 2008 R2 installed. I should have known better than to install an older version of a product after a newer one! :(
Left by Nathon Dalton on Jul 19, 2010 5:11 PM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
I confirm, the solution works with SQL 2008 RC2, too.

THANK YOU!
Left by Mopsente on Aug 05, 2010 4:58 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
Didn't even have to restart service or reboot. Thank you!
Left by IainG on Aug 19, 2010 4:23 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
Look for this file in this folder on SQL 2008 R2:

C:\Program Files\Microsoft SQL Server\100\DTS\Binn
Left by BillVo on Sep 21, 2010 4:57 PM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
Sorry - no luck here with 2008 R2 , REGSVR32.EXE dts.dll did not solve my error. It keeps cropping up after editing 4-5 jobs.
Left by Tim on Mar 09, 2011 8:26 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
I had the same problem, the fix below worked though for me

Traverse to the C:\Program Files\Microsoft SQL Server\100\DTS\binn directory and run the following from the command:

REGSVR32.EXE dts.dll

THEN RESTART SqlAgent
Left by Names on Apr 01, 2011 12:11 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
This fix worked for my 2008 R2 SSMS installation!!

Thanks for posting a solution!!
Left by flp on Jul 13, 2011 5:52 PM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
Hi,
I disabled UAC (User Account Control) and this error is fixed now. I can create\edit maintenance plans and jobs.
Left by Nishad on Aug 12, 2011 4:08 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
Thanks for your hard work and for sharing this! It fixed our issues!
Sincerely,
Brian
Left by Brian on May 09, 2012 9:09 AM

# re: SQL Agent Jobs Fails - Event ID 208
Requesting Gravatar...
It worked like .......
How ever i would like to know the reason for such a case...
My team members did not face this issue, only I faced...
So what could be the reason......
Left by Irfan Basha on Oct 11, 2012 9:33 PM

Your comment:
 (will show your gravatar)


Copyright © NutAndBolts | Powered by: GeeksWithBlogs.net