none
Maintenance Plan Creation Failure

    Question

  • I just tried to create a maintenance plan on a SQL Server 2012 instance (build 11.0.3349), but I receive this error:
    "TITLE: Microsoft SQL Server Management Studio
    ------------------------------
    Provide value on 'System.Windows.Markup.StaticExtension' threw an exception. (PresentationFramework)
    ------------------------------
    ADDITIONAL INFORMATION:
    Exception has been thrown by the target of an invocation. (mscorlib)
    ------------------------------
    The type initializer for 'Microsoft.SqlServer.Graph.Extended.HighContrastSupport' threw an exception. (Microsoft.SqlServer.IntegrationServices.Graph)
    ------------------------------
    C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\devenv.exe (System)"


    This was already working on my system. I recently had to install .NET Framework 4.5 for VS 2012. Maybe it corrupted anything?

    C:\Windows\system32>regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTS.dll" did not help for this issue.

    Does anybody have an idea what's wrong here?

    Thanks, Klaus


    Friday, March 22, 2013 8:44 AM

Answers

All replies

  • 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()

    Friday, March 22, 2013 10:20 AM
  • 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

    Friday, March 22, 2013 11:28 AM
    Moderator
  • Friday, March 22, 2013 11:39 AM
    Moderator
  • 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

    Friday, March 22, 2013 12:41 PM
  • Hello,

    I am glad that worked.

    Regards,
    Alberto Morillo
    SQLCoffee.com


    Friday, March 22, 2013 12:47 PM
    Moderator
  • 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

    Saturday, March 23, 2013 1:30 AM
    Moderator
  • 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?

    Wednesday, April 03, 2013 12:30 AM
  • Hello,

    Please download the hotfix from the following support article:

    http://support.microsoft.com/kb/2832017  

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, April 03, 2013 10:42 AM
    Moderator