In SQL Server 2012 server (Windows 2008 R2). Maintenance Plans created in LiteSpeed are failing with the following error
Error: 2013-04-08 19:05:00.93 Code: 0xC001F02A Source: Subplan 1 Description: Cannot create a task from XML for task "Back Up Database 1", type "Quest.MaintenancePlan.Tasks.DbMaintenanceLiteSpeedBackupTask, Quest.MaintenancePlan.Tasks.11, Version=5.1.0.11, Culture=neutral, PublicKeyToken=c862883b2ae69822" due to error 0x80070057 "The parameter is incorrect.". End Error Error: 2013-04-08 19:05:00.93 Code: 0xC0010018 Source: Back Up Database 1 Description: Failed to load task "Back Up Database 1", type "". The contact information for this task is "". End Error Error: 2013-04-08 19:05:00.94 Code: 0xC001F02A Source: OnPostExecute Description: Cannot create a task from XML for task "{972A1249-FD70-4983-B869-8376C3DDB609}", type "Quest.MaintenancePlan.Tasks.DbMaintenanceLiteSpeedSubPlanPostExecuteTask, Quest.MaintenancePlan.Tasks.11, Version=5.1.0.11, Culture=neutral, PublicKeyToken=c862883b2ae69822" due to error 0x80070057 "The parameter is incorrect.". End Error Error: 2013-04-08 19:05:00.94 Code: 0xC0010018 Source: {972A1249-FD70-4983-B869-8376C3DDB609} Description: Failed to load task "{972A1249-FD70-4983-B869-8376C3DDB609}", type "". The contact information for this task is "". End Error Error: 2013-04-08 19:05:00.94 Code: 0xC001
Native Maintenance Plans could not be executed either. The error executing a Native plan is "The type initializer for 'Microsoft.SqlServer.Graph.Extended.HighContrastSupport' threw an exception." Problem appears to be caused by applying CU3 on SP1 of SQL 2012: http://support.microsoft.com/kb/2832017.
Apply the following hotfix from Microsoft:
KB: http://support.microsoft.com/kb/2832017 " FIX: SSIS projects or maintenance plans cannot be created or opened after you apply Cumulative Update 3 for SQL Server 2012 SP1". The page contains a link to Hotfix: SQLServer2012_SP1_COD_2832017_11_0_3350_x64.
Additional information from the customer:
After installing the Hotfix, I could create a non-LiteSpeed Maintenance Plan, but the existing LiteSpeed Maintenance Plans still failed (same error 0x80070057 "The parameter is incorrect."). So I uninstalled/reinstalled LiteSpeed and recreated the Maintenance Plans and now they are completing successfully. After all this, it is not clear to me if hotfix solved the problem or the uninstall/reinstall solved the problem or if both were required.
