November 9, 2010 at 7:56 am
I'm using SQL Server 2005 with SQL Server 2005 Service Pack 3. I developed a Maint Plan which runs fine and does not show any error messages when I look at its history. But when I look at the associated Job history it shows the red icon indicating failure. Anyone know how to resolve this?Below is the job error message:
Message
Executed as user: 04H-SPARTA\SYSTEM. ... 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:48:44 PM Error: 2010-11-08 14:48:44.92 Code: 0xC0024104 Source: Reporting Task for subplan-{C9D87747-C7F7-468E-8562-9BCB17DFCC0B} Description: The Execute method on the task returned error code 0x80131904 (Conversion failed when converting from a character string to uniqueidentifier.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Warning: 2010-11-08 14:48:44.92 Code: 0x80019002 Source: User Database Maintenance Plan Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warn... The package execution fa... The step failed.
November 9, 2010 at 10:04 am
I went back and deleted the Maint Plan and recreated it from scratch. Now both the Maint Plan History and associated Job History look fine...no errors:crazy:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply