Maintenance Plan Creation Failure

All Replies

• Friday, March 22, 2013 10:20 AM

   

   
  

  0

  Follow up:
  A repair installation did not help. I uninstalled Management Tools Basic and Complete and reinstalled them: Did not help.

  Since I am not a .NET expert this may help you (but not me):
  ===================================
  Provide value on 'System.Windows.Markup.StaticExtension' threw an exception. (PresentationFramework)
  ------------------------------
  Program Location:
     at System.Windows.Markup.WpfXamlLoader.Load(XamlReader xamlReader, IXamlObjectWriterFactory writerFactory, Boolean skipJournaledProperties, Object rootObject, XamlObjectWriterSettings settings, Uri baseUri)
     at System.Windows.Markup.WpfXamlLoader.LoadBaml(XamlReader xamlReader, Boolean skipJournaledProperties, Object rootObject, XamlAccessLevel accessLevel, Uri baseUri)
     at System.Windows.Markup.XamlReader.LoadBaml(Stream stream, ParserContext parserContext, Object parent, Boolean closeStream)
     at System.Windows.Application.LoadComponent(Object component, Uri resourceLocator)
     at Microsoft.SqlServer.IntegrationServices.Designer.View.DbMaintControlFlowGraphUserControl.InitializeComponent()
     at Microsoft.DataTransformationServices.Design.DbMaintElementHost..ctor(DtsBasePackageDesigner packageDesigner)
     at Microsoft.DataTransformationServices.Design.DbMaintSequenceDesigner.get_ElementHost()
     at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.get_SelectedSubPlanDesignerHost()
     at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.SelectSubPlan()
     at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.grid_SelectionChanged(Object sender, SelectionChangedEventArgs args)
     at Microsoft.SqlServer.Management.UI.Grid.GridControl.OnSelectionChanged(BlockOfCellsCollection selectedCells)
     at Microsoft.SqlServer.Management.UI.Grid.GridControl.SelectedCellsInternal(BlockOfCellsCollection col, Boolean bSet)
     at Microsoft.SqlServer.Management.UI.Grid.GridControl.set_SelectedCells(BlockOfCellsCollection value)
     at Microsoft.SqlServer.Management.UI.Grid.DlgGridControl.SetSelectedCellInt(Int32 rowIndex, Int32 colIndex)
     at Microsoft.SqlServer.Management.UI.Grid.DlgGridControl.SetSelectedCell(Int32 rowIndex, Int32 colIndex)
     at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.PopulateGrid()
     at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.Initialize(MaintenancePlanData planData)
     at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintView.LoadMaintenancePlan(String connectionString, IManagedConnection connection, String objectUrn)
     at Microsoft.DataTransformationServices.VsIntegration.DtsDesignerService.OpenDesigner(String connectionString, Object connection, String objectUrn)
     at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()
  ===================================
  Exception has been thrown by the target of an invocation. (mscorlib)
  ------------------------------
  Program Location:
     at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
     at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
     at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
     at System.Reflection.RuntimePropertyInfo.GetValue(Object obj, BindingFlags invokeAttr, Binder binder, Object[] index, CultureInfo culture)
     at System.Reflection.RuntimePropertyInfo.GetValue(Object obj, Object[] index)
     at System.Windows.Markup.StaticExtension.GetFieldOrPropertyValue(Type type, String name, Object& value)
     at System.Windows.Markup.StaticExtension.ProvideValue(IServiceProvider serviceProvider)
     at MS.Internal.Xaml.Runtime.ClrObjectRuntime.CallProvideValue(MarkupExtension me, IServiceProvider serviceProvider)
  ===================================
  The type initializer for 'Microsoft.SqlServer.Graph.Extended.HighContrastSupport' threw an exception. (Microsoft.SqlServer.IntegrationServices.Graph)
  ------------------------------
  Program Location:
     at Microsoft.SqlServer.Graph.Extended.HighContrastSupport.get_BlackBrush()
  ===================================
  C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\devenv.exe (System)
  ------------------------------
  Program Location:
     at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName)
     at Microsoft.SqlServer.Graph.Extended.HighContrastSupport..cctor()
  

  • Reply
  • Quote

   
• Friday, March 22, 2013 11:28 AM

  Moderator

   

   
  

  0

  Hello,
  
  Please uninstall Cumulative Update 3 for SQL Server 2012 Service 1. Based on the following thead is creating issues with Integration Services and Maintenance Plans:
  
  http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/94b78c79-e12a-49d2-8153-bba3904ad9a7  
  

  Hope this helps.
  

  Regards,
  Alberto Morillo
  SQLCoffee.com

  • Marked As Answer by Allen Li - MSFTModerator Friday, March 29, 2013 9:07 AM
  •  
  • Reply
  • Quote

   
• Friday, March 22, 2013 11:39 AM

  Moderator

   

   
  

  0

  Hello,
  
  I just created a Microsoft Connect thread for this issue.
  
  https://connect.microsoft.com/SQLServer/feedback/details/781921/ssis-projects-and-maintenance-plans-do-not-work-after-applying-cu3-for-sql-server-2012-sp1
  
  Regards,
  
  Alberto Morillo
  SQLCoffee.com

  • Reply
  • Quote

   
• Friday, March 22, 2013 12:41 PM

   

   
  

  0

  I can confirm this work around:

  Fresh Install SSMS 2012: No problems

  Update SSMS 2012 to CU3: Mentioned problem occurs

  Uninstall of CU3: No problem any more

  Install CU2: Still no problem

  Thank you very much! We really appreciate your help!

  Regards,

  Klaus
  

  • Reply
  • Quote

   
• Friday, March 22, 2013 12:47 PM

  Moderator

   

   
  

  0

  Hello,
  
  I am glad that worked.

  Regards,
  Alberto Morillo
  SQLCoffee.com

  
  

  • Edited by Alberto MorilloMVP, Moderator Friday, March 22, 2013 7:52 PM
  •  
  • Reply
  • Quote

   
• Saturday, March 23, 2013 1:30 AM

  Moderator

   

   
  

  0

  Hello,

  Microsoft has released Hotfix 1232978 for this issue, if anyone needs to reference it with Customer Service & Support.

  Thank you to Guy Bowerman.

  Regards,

  Alberto Morillo

  • Reply
  • Quote

   
• Wednesday, April 03, 2013 12:30 AM

   

   
  

  0

  I can't find any reference to Hotfix 1232978, nor does Microsoft Support seem to know of it. They want a KB article that refers to the problem and the hotfix - do you know whether one exists?

  • Reply
  • Quote

   
• Wednesday, April 03, 2013 10:42 AM

  Moderator

   

   
  

  0

  Hello,

  Please download the hotfix from the following support article:
  
  http://support.microsoft.com/kb/2832017  
  
  Hope this helps.
  
  Regards,

  Alberto Morillo
  SQLCoffee.com

  • Reply
  • Quote