SQL Server Data Quality Client Application keep raising exception

Marek Mądrawski 5 Reputation points
2024-03-18T09:12:38.65+00:00

Hello

While creating matching policy with Data Quality Services Client application I have encountered the following error message: 

User's image

As the log says it's related to type serialization issue

Microsoft.Ssdqs.Infra.Utilities.BlockedTypeException: Deserialization of type System.UnitySerializationHolder, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 is blocked due to NotInAllow.;
   w Microsoft.Ssdqs.Studio.ViewModels.Data.Common.Paging.CachedPage`1.WaitForLoad();
   w Microsoft.Ssdqs.Studio.ViewModels.Data.Common.Paging.PagedItemsCollection`1.get_Item(Int32 index);
   w Microsoft.Ssdqs.Studio.ViewModels.Data.Common.Paging.PagedItemsCollection`1.Enumerator.get_Current();
   w Microsoft.Ssdqs.Studio.ViewModels.Data.Common.Paging.PagedItemsCollection`1.Enumerator.System.Collections.IEnumerator.get_Current();
   w System.Windows.Data.CollectionView.<>c__DisplayClass1_0.<.ctor>b__0();
   w MS.Internal.Data.SynchronizationInfo.AccessCollection(IEnumerable collection, Action accessMethod, Boolean writeAccess);
   w System.Windows.Data.BindingOperations.AccessCollection(IEnumerable collection, Action accessMethod, Boolean writeAccess);
   w System.Windows.Data.CollectionView..ctor(IEnumerable collection, Int32 moveToFirst);
   w System.Windows.Data.ListCollectionView..ctor(IList list);
   w MS.Internal.Data.ViewManager.GetViewRecord(Object collection, CollectionViewSource cvs, Type collectionViewType, Boolean createView, Func`2 GetSourceItem);
   w MS.Internal.Data.DataBindEngine.GetViewRecord(Object collection, CollectionViewSource key, Type collectionViewType, Boolean createView, Func`2 GetSourceItem);
   w System.Windows.Data.CollectionViewSource.GetDefaultCollectionView(Object source, Boolean createView, Func`2 GetSourceItem);
   w System.Windows.Data.CollectionViewSource.GetDefaultCollectionView(Object source, DependencyObject d, Func`2 GetSourceItem);
   w System.Windows.Controls.ItemCollection.SetItemsSource(IEnumerable value, Func`2 GetSourceItem);
   w System.Windows.Controls.ItemsControl.OnItemsSourceChanged(DependencyObject d, DependencyPropertyChangedEventArgs e);
   w System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e);
   w System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e);
   w System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args);
   w System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType);
   w System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal);
   w System.Windows.Data.BindingOperations.SetBinding(DependencyObject target, DependencyProperty dp, BindingBase binding);
   w Microsoft.Ssdqs.Studio.Views.Pages.MatchingPolicy.MatchingPolicyRuleView.MatchingRuleResultsColumnsChanged();
   w Microsoft.Ssdqs.Studio.Views.Pages.Common.MatchingResultsControl.MatchingRuleResultsColumnsValueChanged(DependencyObject target, DependencyPropertyChangedEventArgs e);
   w System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e);
   w System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e);
   w System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args);
   w System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType);
   w System.Windows.DependencyObject.InvalidateProperty(DependencyProperty dp, Boolean preserveCurrentValue);
   w System.Windows.Data.BindingExpressionBase.Invalidate(Boolean isASubPropertyChange);
   w System.Windows.Data.BindingExpression.TransferValue(Object newValue, Boolean isASubPropertyChange);
   w System.Windows.Data.BindingExpression.Activate(Object item);
   w System.Windows.Data.BindingExpression.OnDataContextChanged(DependencyObject contextElement);
   w System.Windows.Data.BindingExpression.HandlePropertyInvalidation(DependencyObject d, DependencyPropertyChangedEventArgs args);
   w System.Windows.Data.BindingExpressionBase.OnPropertyInvalidation(DependencyObject d, DependencyPropertyChangedEventArgs args);
   w System.Windows.Data.BindingExpression.OnPropertyInvalidation(DependencyObject d, DependencyPropertyChangedEventArgs args);
   w System.Windows.DependentList.InvalidateDependents(DependencyObject source, DependencyPropertyChangedEventArgs sourceArgs);
   w System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args);
   w System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType);
   w System.Windows.DependencyObject.InvalidateProperty(DependencyProperty dp, Boolean preserveCurrentValue);
   w System.Windows.Data.BindingExpressionBase.Invalidate(Boolean isASubPropertyChange);
   w System.Windows.Data.BindingExpression.TransferValue(Object newValue, Boolean isASubPropertyChange);
   w System.Windows.Data.BindingExpression.Activate(Object item);
   w System.Windows.Data.BindingExpression.AttachToContext(AttachAttempt attempt);
   w System.Windows.Data.BindingExpression.MS.Internal.Data.IDataBindEngineClient.AttachToContext(Boolean lastChance);
   w MS.Internal.Data.DataBindEngine.Task.Run(Boolean lastChance);
   w MS.Internal.Data.DataBindEngine.Run(Object arg);
   w MS.Internal.Data.DataBindEngine.OnLayoutUpdated(Object sender, EventArgs e);
   w System.Windows.ContextLayoutManager.fireLayoutUpdateEvent();
   w System.Windows.ContextLayoutManager.UpdateLayout();
   w System.Windows.ContextLayoutManager.UpdateLayoutCallback(Object arg);
   w System.Windows.Media.MediaContext.InvokeOnRenderCallback.DoWork();
   w System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks();
   w System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget);
   w System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget);
   w System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs);
   w System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)

How to fix this issue?

Is there a workaround? (as the log says that the type System.Unity.SerializationHolder is not allowed for deserialization) - is there a way to force deserialization of this type?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,472 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. LiHongMSFT-4306 30,671 Reputation points
    2024-03-19T03:06:59.57+00:00

    Hi @Marek Mądrawski

    Have you check if the permission issue and also the prerequisites?

    See this doc: Create a Matching Policy.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.