DQS exception when cleaning data

Question

Hi

I'm trying to cleanse some addresses data using 3rd party data provider (Melissa Data).

After creating a KB and a new project that's using it I mapped the columns to the provider columns and just before started cleansing I stated to get the following errors. Since this is my first time using DQS I'm not sure if this error is related to the fact that I'm using a 3rd party or a general error.

SQL Server Data Quality Services
--------------------------------------------------------------------------------

Message Id: ApplicationUnhandledException
An unhandled exception has occurred. For more details, see the Data Quality Services client log.

--------------------------------------------------------------------------------
System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.Ssdqs.Studio.Infra.DataObjects.ElementCollection`1.Contains(T item)
   at Microsoft.Ssdqs.Studio.Infra.DataObjects.ElementCollection`1.System.Collections.IList.Contains(Object value)
   at System.Windows.Data.ListCollectionView.InternalContains(Object item)
   at System.Windows.Data.ListCollectionView.Contains(Object item)
   at System.Windows.Controls.ItemCollection.Contains(Object containItem)
   at System.Windows.Controls.Primitives.Selector.SelectionChanger.Select(ItemInfo info, Boolean assumeInItemsCollection)
   at System.Windows.Controls.Primitives.Selector.SelectionChanger.SelectJustThisItem(ItemInfo info, Boolean assumeInItemsCollection)
   at System.Windows.Controls.Primitives.Selector.OnSelectedItemChanged(DependencyObject d, DependencyPropertyChangedEventArgs e)
   at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
   at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
   at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
   at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
   at System.Windows.DependencyObject.InvalidateProperty(DependencyProperty dp, Boolean preserveCurrentValue)
   at System.Windows.Data.BindingExpressionBase.Invalidate(Boolean isASubPropertyChange)
   at System.Windows.Data.BindingExpression.TransferValue(Object newValue, Boolean isASubPropertyChange)
   at System.Windows.Data.BindingExpression.ScheduleTransfer(Boolean isASubPropertyChange)
   at MS.Internal.Data.ClrBindingWorker.NewValueAvailable(Boolean dependencySourcesChanged, Boolean initialValue, Boolean isASubPropertyChange)
   at MS.Internal.Data.PropertyPathWorker.UpdateSourceValueState(Int32 k, ICollectionView collectionView, Object newValue, Boolean isASubPropertyChange)
   at MS.Internal.Data.ClrBindingWorker.OnSourcePropertyChanged(Object o, String propName)
   at MS.Internal.Data.PropertyPathWorker.OnPropertyChanged(Object sender, PropertyChangedEventArgs e)
   at System.Windows.WeakEventManager.ListenerList`1.DeliverEvent(Object sender, EventArgs e, Type managerType)
   at System.ComponentModel.PropertyChangedEventManager.OnPropertyChanged(Object sender, PropertyChangedEventArgs args)
   at Microsoft.Ssdqs.Studio.Infra.DataObjects.DataObjectBase.InvokePropertyChanged(DataProperty dataProperty, Object oldValue, Object newValue)
   at Microsoft.Ssdqs.Studio.Infra.DataObjects.DataObjectBase.InternalSetValue(DataProperty dataProperty, Object value, Boolean updateBinding)
   at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.Common.DataSourceMappingsViewModel.LeaveTaskOverride(Object obj)
   at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.DQProject.CorrectionDataSourceMappingsViewModel.LeaveTaskOverride(Object obj)
   at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.Abstract.WizardTaskViewModel.LeaveTask(Object obj)
   at Microsoft.Ssdqs.Studio.ViewModels.Utilities.UICommand.Execute(Object parameter)
   at Microsoft.Ssdqs.Studio.Views.Controls.TasksWizard.LeaveCurrentTask()
   at Microsoft.Ssdqs.Studio.Views.Controls.TasksWizard.NextButtonClick(Object sender, RoutedEventArgs e)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   at System.Windows.UIElement.RaiseEvent(RoutedEventArgs e)
   at System.Windows.Controls.Primitives.ButtonBase.OnClick()
   at System.Windows.Controls.Button.OnClick()
   at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
   at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
   at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
   at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
   at System.Windows.Input.InputManager.ProcessStagingArea()
   at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
   at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
   at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
   at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)

Your help is highly appreciated as we need this working ASAP for one of our customers..

10x in advance

Gilroze

Answer 1

We managed to reproduce these exceptions when installing on another machine. Running the DQS installer again, both in install and upgrade modes did not solve this.

Finally, we downloaded SP1 for SQLSERVER 2012 and followed the instructions described in:

http://blogs.msdn.com/b/dqs/archive/2012/11/29/upgrading-dqs-to-sql-server-2012-service-pack-1-sp1-release.aspx

This finally solved these exceptions.