Problem
Cannot show requested dialog. (SqlMgmt)
Microsoft SQL Server Management Studio
Cannot show requested dialog.
Additional information:
Cannot show requested dialog. (SqlMgmt)
The type initializer for ‚Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesLanguagePanel‘ threw an exception. (Microsoft.AnalysisServices.SsmsManagementDialogs)
Item has already been added. Key in dictionary: ‚4096‘ Key being added: ‚4096‘ (mscorlib)
Details
Beschreibung
Auf einem Server wurde eine SQL Server Analysis Services (SSAS) Instanz der Version 11.0.2100.60 (RTM) installiert.
Wenn nun versucht wird im Microsoft SQL Server Management Studio (SSMS) die Eigenschaften dieser SSAS Instanz aufzurufen, dann wird folgende Fehlermeldung angezeigt.
Microsoft SQL Server Management Studio
Cannot show requested dialog.
Additional information:
Cannot show requested dialog. (SqlMgmt)
The type initializer for ‚Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesLanguagePanel‘ threw an exception. (Microsoft.AnalysisServices.SsmsManagementDialogs)
Item has already been added. Key in dictionary: ‚4096‘ Key being added: ‚4096‘ (mscorlib)
=================================== Cannot show requested dialog. =================================== Cannot show requested dialog. (SqlMgmt) ------------------------------ Program Location: at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc) at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolMenuItemHelper.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc) at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread() =================================== The type initializer for 'Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesLanguagePanel' threw an exception. (Microsoft.AnalysisServices.SsmsManagementDialogs) ------------------------------ Program Location: at Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesLanguagePanel..ctor(CDataContainer dataContainer) at Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesDialog..ctor(CDataContainer dataContainer) =================================== Item has already been added. Key in dictionary: '4096' Key being added: '4096' (mscorlib) ------------------------------ Program Location: at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at System.Collections.Specialized.StringDictionary.Add(String key, String value) at Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesLanguagePanel..cctor()
Fix
SQL Server Installation aktualisieren
Damit die Fehlermeldung „Cannot show requested dialog“ nicht mehr auftritt, muss die SQL Server Installation aktualisiert werden.
In diesen Updates wurde der Fehler beseitigt:
- Cumulative Update 11 for SQL Server 2012
- Cumulative Update 7 for SQL Server 2012 SP1
- Cumulative Update 14 for SQL Server 2008 SP3
- Cumulative Update 10 for SQL Server 2008 R2 SP2
In unserem Fall wurde der Fehler mit der Installation des SP3 beseitigt.