Error: Cannot create a task from XML for task "", type "" due to error 0x80070057 "The parameter is incorrect.".

Question

Hi Team,

I am facing the below error while creating maintenance plan for full backups.

Version: Microsoft SQL Server 2014 (SP3-GDR) (KB4583463) - 12.0.6164.21 (X64) Nov 1 2020 04:25:14
Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )

Error:

Maintenance Plan Wizard Progress

• Creating maintenance plan "SQL_Fullbackups" (Error)
  Messages
  • Create maintenance plan failed.

---

ADDITIONAL INFORMATION:

Cannot create a task from XML for task "", type "" due to error 0x80070057 "The parameter is incorrect.".
(OnPreExecute)

---

Cannot create a task from XML for task "", type "" due to error 0x80070057 "The parameter is incorrect.".
(OnPreExecute)

• Adding tasks to the maintenance plan (Stopped)
• Adding scheduling options (Stopped)
• Adding reporting options (Stopped)
• Saving maintenance plan "SQL_Fullbackups" (Stopped)

Can someone please help me to resolve this issue.

I have seen the below article to fix the issue:
https://support.microsoft.com/en-us/help/4583463

Can I install this fix in my production server?

Answer 1

Hi @Sai ,

> Cannot create a task from XML for task "", type "" due to error 0x80070057 "The parameter is incorrect.".
>(OnPreExecute)

This is a common error. Suggest you using the latest version SSMS 18.10. If it does not work, download and install “SQL Server Data Tools in Visual Studio 2015”. This is also called as SSDT. https://msdn.microsoft.com/en-us/mt186501. This helps many people resolved this error.

Refer to the blog SQL SERVER – Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute).

---

If the answer is helpful, 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.

Answer 2

I have seen the below article to fix the issue:

https://support.microsoft.com/en-us/help/4583463

Did you paste the wrong link? That is about a security GDR, which has no relation to your issue. Also, you are running exactly that version introduced in this KB article.

I don't know the answer to your question. However, you maybe interested in checking out http://ola.hallengren.com. Ola's maintenance solution is by many considered to be superior to the maintenance plans that ship with SQL Server.