April 28, 2014 at 1:55 pm
Hello,
I have created a database backup maintenance plan on my new SQL 2012 Instance and they are failing with the below error message. I don't have much clue on the error message. Any help would be greatly appreciated.
I have tried to delete one of my maintenance plans and recreate them and it works fine, but i would like to know the work around if any without recreating the database backup maintenance plans
Error:
Executed as user: XXXX\XXXXX. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 12:21:58 PM Error: 2014-04-28 12:21:59.42 Code: 0xC002F210 Source: {77F4104A-83E4-474A-A8C1-FE54EE24B763} Execute SQL Task Description: Executing the query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp..." failed with the following error: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_sysmaintplan_log_subplan_id". The conflict occurred in database "msdb", table "dbo.sysmaintplan_subplans", column 'subplan_id'. The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Warning: 2014-04-28 12:21:59.42 Code: 0x80019002 Source: OnPreExecute Description: 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 Progress: 2014-04-28 12:21:59.89 Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 0,N'T:\MNTBACKUP...".: 100% complete End Progress Error: 2014-04-28 12:22:00.05 Code: 0xC0024104 Source: Maintenance Cleanup Task Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Warning: 2014-04-28 12:22:00.05 Code: 0x80019002 Source: Full_backups 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 Warning Error: 2014-04-28 12:22:00.37 Code: 0xC0024104 Source: {1F23C295-3CA5-49E4-9E7A-88152941C66E} Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Warning: 2014-04-28 12:22:00.37 Code: 0x80019002 Source: OnPostExecute 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 Warning DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:21:58 PM Finished: 12:22:00 PM Elapsed: 1.841 seconds. The package execution failed. The step failed.
Thanks for your time !!.
April 29, 2014 at 12:00 am
http://www.sqlservercentral.com/Forums/Topic644825-146-1.aspx
can you please refer the above Link for some hints for your issue..?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply