Home Dashboard Directory Help
Search

SQL Server 2008R2 Maintenance Plan Fails with: Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). by Hacky_J


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Bug
ID: 679371
Opened: 7/13/2011 11:24:50 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Backup Maintenance Plan fails with:
Date        7/13/2011 11:07:03 AM
Log        Job History (Backup Day 2.Full Backup Day 2)

Step ID        1
Server        Server\Instance
Job Name        Backup Day 2.Full Backup Day 2
Step Name        Full Backup Day 2
Duration        00:00:13
Sql Severity        0
Sql Message ID        0
Operator Emailed        
Operator Net sent        
Operator Paged        
Retries Attempted        0

Message
Executed as user: Domain\User. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started: 11:07:03 AM Error: 2011-07-13 11:07:13.81     Code: 0xC0024104     Source: Execute SQL Server Agent Job Task     Description: The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:07:03 AM Finished: 11:07:14 AM Elapsed: 11.016 seconds. The package execution failed. The step failed.
Details
Sign in to post a comment.
Posted by Microsoft on 10/16/2011 at 4:27 AM
Hi

Greetings from the SQL Server Manageability team.

Thanks for writing in to Microsoft. We greatly value your feedback.

However, given the work that would be involved in implementing this work, and triaging against our current set of deliverables, we do not think, we would be able to get to this in the near future.

Having said that, we value your suggestions, and would like to assure you that, we would keep these ideas in mind, when we do revisit this feature in the future.

Thanks again for providing feedback and making SQL Server the greatest Database server.

Regards
Manish
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Attachment.txt 7/13/2011 2 KB