November 7, 2008 at 12:49 pm
I have a Maintenance Plan job that takes log backups of the User databases. Most of the time it runs successfully. Every now and then, it sends out a failure notification, however the log for the job shows success for the two tasks and the job has created all the log backup files. This is the message in the job step history:
End Progress Error: 2008-07-26 12:15:41.04 Code: 0xC0024104 Source: Reporting Task for subplan-{08F57368-7039-4250-9BA3-AB97CEE97007} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property cannot be called on Null values.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Error: 2008-07-26 12:15:41.04 Code: 0xC0024104 Source: Reporting Task for subplan-{0921A72F-E46C-4023-847C-B30E1D8382EA} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property ca... The package execution fa... The step failed.
I am running SQL Server 2005 Standard Edition SP2 CU6 (version 9.0.3228) on a 32-bit Windows Server 2003 Standard Edition SP2. The Log Backup Subplan only has 2 tasks: Maintenance Cleanup Task and Back Up Database Task.
Have any of you experienced this before? I don't want the job to send out failure notifications to the support team when it is successfully completing the tasks. What should I do to correct this?
November 10, 2008 at 12:08 pm
Make sure you maintenance plan logs to the file system so you get more details. We can help if you don't understand them.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 10, 2008 at 1:13 pm
My Maintenance Jobs do write out log files to the file system. The log file reports success when the job fails. This is the message in the job:
uted as user: xxxxxxx\xxxxxxxxxxx. ....00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:15:01 PM Progress: 2008-11-07 15:15:06.50 Source: {95299DA7-BA58-4D80-BC40-066F8861E065} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2008-11-07 15:15:07.33 Code: 0xC0024104 Source: Reporting Task for subplan-{08F57368-7039-4250-9BA3-AB97CEE97007} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property cannot be called on Null values.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Error: 2008-11-07 15:15:07.33 Code: 0xC0024104 Source: Reporting Task for subplan-{0921A72F-E46C-4023-847C-B30E1D8382EA} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property can... The package execution fa... The step failed.
This is the message in the log file (not the log backup file - although they are being created successfully as well):
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3228
Report was generated on "TRGAZCPDST02".
Maintenance Plan: User Databases
Duration: 00:00:03
Status: Succeeded.
Details:
Maintenance Cleanup Task (TRGAZCPDST02)
Task start: 2008-11-07T03:15:05.
Task end: 2008-11-07T03:15:06.
Success
Back Up Database Task (TRGAZCPDST02)
Task start: 2008-11-07T03:15:07.
Task end: 2008-11-07T03:15:08.
Success
This happens intermittently on different servers and is a production support issue. It is not a space issue - i have checked on that. I do not want our on-call DBA's to receive failure notifications on jobs that actually run successfully.
Has anyone else have this issue? How did it get fixed?
November 3, 2009 at 8:18 am
I am having a similar issue. The error message is the same. The operation is for index re-org. Any idea anyone?
November 4, 2009 at 7:18 am
Dear Sir,
I have created batch file for daily backup but I am not able to execute the same. Can you please let me know what further I have to insert in my exisiting querry. I request you please check my querry with batch file.
BR
Dinesh
<backup.batch>
BACKUP DATABASE [QCONSULTLTD] TO DISK = N'D:\Backup\Saga pastel bkup\Wednesday\Qconsultltd_Wed.bak' WITH NOFORMAT, NOINIT, NAME = N'QCONSULTLTD-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [QGL] TO DISK = N'D:\Backup\Saga pastel bkup\Wednesday\Qgl_Wed.bak' WITH NOFORMAT, NOINIT, NAME = N'QGL-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [EvolutionCommon] TO DISK = N'D:\Backup\Saga pastel bkup\Wednesday\EvolutionCommon_Wed.bak' WITH NOFORMAT, NOINIT, NAME = N'EvolutionCommon-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
December 8, 2009 at 2:02 pm
I am receiving the same error during log backups. The log file is created but receive Error Code: 0xC0024104. Has anyone found out why this happens?
December 9, 2009 at 9:14 am
d.chhabra (11/4/2009)
Dear Sir,I have created batch file for daily backup but I am not able to execute the same. Can you please let me know what further I have to insert in my exisiting querry. I request you please check my querry with batch file.
BR
Dinesh
You are hijacking this thread with a different problem. You'll get better help if you start a thread specific to your problem.
December 9, 2009 at 9:27 am
As for answers to the original post and my reply posted yesterday, it looks like my problem had to do with a Raid controller failure. I was told that rebooting the server would resolve my original issue, but when the server was rebooted it would not come up again. Now we need to order a new raid controller to get it back up again. So check your hardware and see if that is causing your errors.
July 13, 2010 at 3:58 am
I am receiving the same error during log backups.
It was on Windows 2003 Server' with 'Microsoft SQL Server Enterprise Edition (64-bit)' version '9.00.4053.00'.
In EventLog are next records:
Event Type: Error
Event Source: McLogEvent
Event Category: None
Event ID: 5051
Date: 13.07.10
Time: 00:41:48
User: NT AUTHORITY\SYSTEM
Computer: AMPSV02806PRD
Description:
A thread in process C:\Program Files (x86)\McAfee\VirusScan Enterprise\x64\mcshield.exe took longer than 90000 ms to complete a request.
The process will be terminated. Thread id : 53608 (0xd168)
Thread address : 0x0000000077EF0D1A
Thread message :
Build VSCORE.13.3.2.137 / 5400.1158
Object being scanned = \Device\HarddiskVolume1\Program Files (x86)\IBM\Director\cimom\logs\SmartInterface.log
by C:\Program Files (x86)\Common Files\IBM\icc\cimom\bin\wmippa.exe
17018(281)(0)
17017(0)(1)
7007(0)(0)
5006(0)(0)
5004(0)(0)
5003(0)(0)
5002(0)(1)
15002(0)(0)
Event Type: Error
Event Source: McLogEvent
Event Category: None
Event ID: 1008
Date: 13.07.10
Time: 00:42:11
User: N/A
Computer: AMPSV02806PRD
Description:
The McShield service terminated unexpectedly.
Please review event 5019 or 5051 for details. The McShield service will be restarted in 60 seconds;
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12291
Date: 13.07.10
Time: 00:42:12
User: NT AUTHORITY\SYSTEM
Computer: AMPSV02806PRD
Description:
Package "Backup TLOG BWP" failed.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Source:McLogEvent = 'McAfee VirusScan' (Enterprise + AntiSpyware Enterprise v8.5i).
So I suspect 'McAfee VirusScan' as root cause of this issue.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply