February 15, 2011 at 3:05 pm
PLEASE, someone help me out here. I've been having this error since i upgrade my SQL 2000 server to SQL 2008 server. I created a new maintenance plan to check database integrity and backup daily and i continue to have this error. I'm pulling my hair out here!
Date15/02/2011 5:04:16 PM
LogJob History (MaintenancePlan.Subplan_1)
Step ID1
ServerT2SERVER\MSSQLSERVER2K8
Job NameMaintenancePlan.Subplan_1
Step NameSubplan_1
Duration00:00:01
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: T2SERVER\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.4000.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:04:16 PM Error: 2011-02-15 17:04:16.92 Code: 0xC0010018 Source: Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">Local server connection</DTS:Property> <DTS:Property DTS:Name="DTSID">{441E8404-C727-472B-8" from node "DTS:ConnectionManager". End Error Could not load package "Maintenance Plans\MaintenancePlan" because of error 0xC0010014. Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors. Source: Started: 5:04:16 PM Finished: 5:04:16 PM Elapsed: 0.641 seconds. The package could not be loaded. The step failed.
February 15, 2011 at 5:18 pm
This article has description of this bug in SQL 2005. May be it will be helpful to you as well.
February 15, 2011 at 11:39 pm
Did you see the M.Plan history error?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 15, 2011 at 11:47 pm
Is the latest service pack installed?
M&M
February 16, 2011 at 7:15 am
10.0.4000.0 SP2 Enterprise is the version that's running, i think it's the most up to date. I had this problem before upgrading to SP2 and it remains so i don't think it's a version issue.
February 16, 2011 at 4:17 pm
gchaimovitz (2/16/2011)
10.0.4000.0 SP2 Enterprise is the version that's running, i think it's the most up to date. I had this problem before upgrading to SP2 and it remains so i don't think it's a version issue.
First thing to check is the version of your client tools you are using to create the maintenance plan. If that version has not been upgraded to the same (or greater) level as the server you are accessing it could lead to problems with the maintenance plans.
Second thing to do is check your maintenance plan history to find out what task is actually failing and why it is failing. To do this, right-click on the maintenance plan (Management\Maintenance in Object Explorer) and View History from here - this is not the same history that you are viewing in the job.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 17, 2011 at 6:06 am
Thanks for the reply... I'm using the SQL Server Management studio on the server. The history log for the maintenance plan has nothing in it. It seems the job fails before it even loads the plan which leads me to believe perhaps an issue with the sql server agent?
February 17, 2011 at 6:28 am
Can you run package from command line using dtexec?
February 17, 2011 at 7:04 am
I haven't tried. I'm not sure how as I'm still pretty new at this. I'll give it a go and report back.
February 18, 2011 at 8:05 am
Still not working. I've created a new USER on the system and applied all the SQL groups that were created when I installed SQL Server 2008. I've set that as the USER logon account for all SQL services. Now i get this error instead:
Message
Executed as user: SERVER\USR_SQLSERVER. Microsoft (R) SQL Server Execute Package Utility Version 10.0.4000.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:00:44 AM Could not load package "Maintenance Plans\MaintenancePlan" because of error 0x800401F3. Description: Invalid class string Source: Started: 10:00:44 AM Finished: 10:00:44 AM Elapsed: 0.031 seconds. The package could not be loaded. The step failed.
Any thoughts?
February 18, 2011 at 8:14 am
Go to your Job and edit the step then in Genaral Tab , go to Execution Option and their is option Use 32 bit runtime , enable this option and give a try to run the job ,
HTH...
February 18, 2011 at 8:19 am
Try couple of things. First just execute it see weather its giving the same error message? if its a different error message then you have an issue with the permission.
Change the package owner to sa and category: Uncategorized and give it a try.
February 18, 2011 at 8:52 am
If I try to just execute the maintenance plan it tells me there's an error, check job history for details. I changed to owner sa, uncategorized and still get error:
Message
Executed as user: SERVER\USR_SQLSERVER. Microsoft (R) SQL Server Execute Package Utility Version 10.0.4000.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:50:06 AM Could not load package "Maintenance Plans\MaintenancePlan" because of error 0x800401F3. Description: Invalid class string Source: Started: 10:50:06 AM Finished: 10:50:06 AM Elapsed: 0.031 seconds. The package could not be loaded. The step failed.
USR_SQLSERVER is the new user I set up with all the SQL server group memberships.
February 18, 2011 at 9:03 am
OK, here's an update. I ran the plan from the command prompt suggested by magasvs using:
DTEXEC /SQL "Maintenance Plans\MaintenancePlan" /SERVER "T2SERVER\MSSQLSERVER2K8" /USER sa /PASSWORD /X86 /CHECKPOINTING OFF /SET "\Package\Subplan_1.Disable";false /REPORTING E
This worked! What could be the issue?
I could set this up as a scheduled task but seems silly to have to do it that way.
March 2, 2011 at 12:32 pm
No ideas? Anyone?
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply