Error when running DB maintenance plan

Question

I am receiving the message below when trying to run a maintenance plan for transaction log and full backup. Any thoughts on why?

Message
Executed as user: WFCSAPPRD01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 11.0.3513.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 12:45:01 PM Error: 2022-03-23 12:45:01.94 Code: 0xC0024104 Source: {A68C481D-02D7-4330-84CF-7635D7EBC5E6} Description: The Execute method on the task returned error code 0x80131621 (Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Warning: 2022-03-23 12:45:01.94 Code: 0x80019002 Source: OnPreExecute 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 Warning: 2022-03-23 12:45:01.94 Code: 0x80019002 Source: Subplan_1 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 Error: 2022-03-23 12:45:02.16 Code: 0xC0024104 Source: Back Up Database (Transaction Log) Description: The Execute method on the task returned error code 0x80131621 (Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Error: 2022-03-23 12:45:02.17 Code: 0xC0024104 Source: {CA24F323-DD2C-4265-BF62-6F29E69E57A4} 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: 2022-03-23 12:45:02.17 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:45:01 PM Finished: 12:45:02 PM Elapsed: 1.094 seconds. The package execution failed. The step failed.

Answer 1

Hi @Varughese, Nisha

Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed

It seems that the error thrown at SSIS side, are you running a package via agent job?

You may need to set the number to higher value in the SSIS package, you can set at the package level.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.