February 18, 2010 at 10:39 am
Team,
My Maintenanceplan had failed stating the error as
SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) 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 Warning Error: 2010-02-15 02:00:39.88 Code: 0xC0024104 Source: Check Database Integrity Ta... The package execution fa... The step failed.
February 19, 2010 at 1:08 am
Tell me what you are doing in that plan
have you migrated it from other location ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 19, 2010 at 9:46 am
Iam performing the database integrity task and the update statistics task in it
February 19, 2010 at 1:01 pm
Drill down into the specific maintenance task and open the 'View T-SQL' window. If you run the command directly you might get a more descriptive error message.
February 19, 2010 at 8:10 pm
Right-click on the maintenance plan and select View History. This will show you the history for the plan and which task actually failed. Select the failed task and you will be able to see the error message for that task.
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 20, 2010 at 1:23 am
dba_neo (2/18/2010)
Team,My Maintenanceplan had failed stating the error as
SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) 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 Warning Error: 2010-02-15 02:00:39.88 Code: 0xC0024104 Source: Check Database Integrity Ta... The package execution fa... The step failed.
What is this maintenance plan doing? Backups? Defrag\Rebuild Index?
EnjoY!
February 20, 2010 at 3:13 am
Hi,
The reason you are unable to determine the root cause of your error is because an incomplete error message is being returned from the job history i.e. it is truncated.
In order to view the full details of any error messages that you may receive you should modify the SQL Server Agent job that executes your maintenance plan to generate an output file on failure.
Take a look at the following article that explains how you can do this in step by step detail.
http://www.mssqltips.com/tip.asp?tip=1394
Once you have the complete error details, post the results back to this forum and we can help your further.
Cheers,
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply