none
DQS Error when try to create or open any knwoledgebase RRS feed

  • Question

  • I have an error in DQS client.  When i try to create or modify any knowledgebase from DQS have this error:

    SQL Server Data Quality Services<u5:p></u5:p>

    --------------------------------------------------------------------------------<u5:p></u5:p>

     

    Message Id: ApplicationUnhandledException<u5:p></u5:p>

    An unhandled exception has occurred. For more details, see the Data Quality Services client log.<u5:p></u5:p>

     

    --------------------------------------------------------------------------------<u5:p></u5:p>

    System.InvalidOperationException: Sequence contains no elements<u5:p></u5:p>

       at System.Linq.Enumerable.Max[TSource](IEnumerable`1 source)<u5:p></u5:p>

       at Microsoft.Ssdqs.Studio.ViewModels.Data.Process.ProcessProvider.GetExecutionStatus(ProcessType[] processType)<u5:p></u5:p>

       at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.DomainManagement.DomainManagementViewModel.InitializeDomainManagement()<u5:p></u5:p>

       at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.DomainManagement.DomainManagementViewModel.ValueChanged(DataProperty property, Object oldValue, Object newValue)<u5:p></u5:p>

       at Microsoft.Ssdqs.Studio.Infra.DataObjects.DataObjectBase.InvokePropertyChanged(DataProperty dataProperty, Object oldValue, Object newValue)<u5:p></u5:p>

       at Microsoft.Ssdqs.Studio.Infra.DataObjects.DataObjectBase.InternalSetValue(DataProperty dataProperty, Object value, Boolean updateBinding)<u5:p></u5:p>

       at Microsoft.Ssdqs.Studio.Views.Pages.Application.StartPageView.OpenKnowledgebase(Knowledgebase knowledgebase)<u5:p></u5:p>

       at Microsoft.Ssdqs.Studio.Views.Pages.Application.StartPageView.OpenRecentKnowledgebase(Knowledgebase knowledgebase, KnowledgebaseActivity openActivity)<u5:p></u5:p>

       at Microsoft.Ssdqs.Studio.Views.Pages.Application.StartPageView.OpenRecentItem(Object sender, ExecutedRoutedEventArgs e)<u5:p></u5:p>

       at System.Windows.Input.CommandBinding.OnExecuted(Object sender, ExecutedRoutedEventArgs e)<u5:p></u5:p>

       at System.Windows.Input.CommandManager.ExecuteCommandBinding(Object sender, ExecutedRoutedEventArgs e, CommandBinding commandBinding)<u5:p></u5:p>

       at System.Windows.Input.CommandManager.FindCommandBinding(CommandBindingCollection commandBindings, Object sender, RoutedEventArgs e, ICommand command, Boolean execute)<u5:p></u5:p>

       at System.Windows.Input.CommandManager.FindCommandBinding(Object sender, RoutedEventArgs e, ICommand command, Boolean execute)<u5:p></u5:p>

       at System.Windows.Input.CommandManager.OnExecuted(Object sender, ExecutedRoutedEventArgs e)<u5:p></u5:p>

       at System.Windows.UIElement.OnExecutedThunk(Object sender, ExecutedRoutedEventArgs e)<u5:p></u5:p>

       at System.Windows.Input.ExecutedRoutedEventArgs.InvokeEventHandler(Delegate genericHandler, Object target)<u5:p></u5:p>

       at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)<u5:p></u5:p>

       at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)<u5:p></u5:p>

       at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)<u5:p></u5:p>

       at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)<u5:p></u5:p>

       at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)<u5:p></u5:p>

       at System.Windows.Input.RoutedCommand.ExecuteImpl(Object parameter, IInputElement target, Boolean userInitiated)<u5:p></u5:p>

       at System.Windows.Input.RoutedCommand.ExecuteCore(Object parameter, IInputElement target, Boolean userInitiated)<u5:p></u5:p>

       at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)<u5:p></u5:p>

       at System.Windows.Controls.Primitives.ButtonBase.OnClick()<u5:p></u5:p>

       at System.Windows.Controls.Button.OnClick()<u5:p></u5:p>

       at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)<u5:p></u5:p>

       at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)<u5:p></u5:p>

       at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)<u5:p></u5:p>

       at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)<u5:p></u5:p>

       at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)<u5:p></u5:p>

       at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)<u5:p></u5:p>

       at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)<u5:p></u5:p>

       at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)<u5:p></u5:p>

       at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)<u5:p></u5:p>

       at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)<u5:p></u5:p>

       at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)<u5:p></u5:p>

       at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)<u5:p></u5:p>

       at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)<u5:p></u5:p>

       at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)<u5:p></u5:p>

       at System.Windows.Input.InputManager.ProcessStagingArea()<u5:p></u5:p>

       at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)<u5:p></u5:p>

       at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)<u5:p></u5:p>

       at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)<u5:p></u5:p>

       at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)<u5:p></u5:p>

       at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)<u5:p></u5:p>

       at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)<u5:p></u5:p>

       at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)<u5:p></u5:p>

       at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)<u5:p></u5:p>

       at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)<u5:p></u5:p>

    <u5:p></u5:p>

    Already check del SQL Server and it's up and running.  Also the DQS databases is online.  Also try to access from differents pc's and have the same error. Also try with differentes users and have the same problem.

    It's a SQL Server 2014 without any service pack.

    Anyone saw this error before or know how to fix it?

    Thanks for any help

    Juan Alvarado


    Juan Alvarado - MVP SQL SERVER

    Friday, February 24, 2017 2:33 PM

All replies

  • I have the same error, but using SQL 2012 SP2.

    The knowledgebase is being used successfully by a couple of SSIS packages, but I cannot modify the knowledgebase.

    I have tried launching the client on different machines to no avail....

    Friday, March 31, 2017 10:10 AM
  • I have exactly same issue on it. Anynone have solution to fix this?
    Thursday, July 19, 2018 3:14 AM
  • I have exactly same issue on it. But im using SQL 2017 CU9. Anynone have solution to fix this? Need urgently to fix.

    Thank you in advance


    Thursday, July 19, 2018 3:16 AM
  • I'm having the same issue as well. Has anyone found a fix for it yet?
    Friday, January 11, 2019 12:43 AM