FIX: "Failed to create a new table" error when you export the cleansing results of a Data Quality Services domain in SQL Server

Symptoms

You set a decimal data type that contains at least one null value in the domain properties of a Data Quality Services (DQS) project. When you export the cleansing results to a Microsoft SQL Server database, you receive an error message that resembles the following:
Message Id: ExportFailedToCreateNewTable

Failed to create a new table table_name in database database_name. Check whether the table already exists, and have the database administrator make sure the DQS Service has CREATE TABLE rights in the destination database and can INSERT to the destination table.

Microsoft.Ssdqs.Infra.Exceptions.EntryPointException: Failed to create a new table 'MyTable' in database 'Test'. Check whether the table already exists, and have the database administrator make sure the DQS Service has CREATE TABLE rights in the destination database and can INSERT to the destination table.
at Microsoft.Ssdqs.Proxy.Database.DBAccessClient.Exec()
at Microsoft.Ssdqs.Proxy.EntryPoint.InteractiveCleansingEntryPointClient.RecordsExport(RepositoryMetadata repositoryMetadata, ReadOnlyCollection`1 filterCriteriaList, Boolean standardizeOutput, Boolean isExportRecordStatus)
at Microsoft.Ssdqs.Studio.ViewModels.Data.TermCorrections.TermCorrectionProvider.ExportFields(RepositoryMetadata repositoryMetadata, IEnumerable`1 exportedFields, Boolean standardizeOutput, Boolean isExportRecordStatus)
at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.DQProject.CorrectionDatabaseDestinationViewModel.ExportFields(Int64 dataSourceMappingId, IEnumerable`1 exportedFields, KnowledgebaseProject knowledgebaseProject, Boolean standardizeOutput, Boolean isExportRecordStatus)
at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.DQProject.MergeViewModel.ExportFieldsExecute(Object obj)
at Microsoft.Ssdqs.Studio.ViewModels.Utilities.UICommand.Execute(Object parameter)
at Microsoft.Ssdqs.Studio.Views.Pages.DQProject.MergeView.InteractiveCleansingExport(Object sender, ExecutedRoutedEventArgs e)
at System.Windows.Input.CommandBinding.OnExecuted(Object sender, ExecutedRoutedEventArgs e)
at System.Windows.Input.CommandManager.ExecuteCommandBinding(Object sender, ExecutedRoutedEventArgs e, CommandBinding commandBinding)
at System.Windows.Input.CommandManager.FindCommandBinding(CommandBindingCollection commandBindings, Object sender, RoutedEventArgs e, ICommand command, Boolean execute)
at System.Windows.Input.CommandManager.FindCommandBinding(Object sender, RoutedEventArgs e, ICommand command, Boolean execute)
at System.Windows.Input.CommandManager.OnExecuted(Object sender, ExecutedRoutedEventArgs e)
at System.Windows.UIElement.OnExecutedThunk(Object sender, ExecutedRoutedEventArgs e)
at System.Windows.Input.ExecutedRoutedEventArgs.InvokeEventHandler(Delegate genericHandler, Object target)
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.RaiseEvent(RoutedEventArgs args, Boolean trusted)
at System.Windows.Input.RoutedCommand.ExecuteImpl(Object parameter, IInputElement target, Boolean userInitiated)
at System.Windows.Input.RoutedCommand.ExecuteCore(Object parameter, IInputElement target, Boolean userInitiated)
at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)
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)

Resolution

Cumulative update information

This issue is fixed in the following updates:


Recommendation: Install the latest cumulative update for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology that Microsoft uses to describe software updates.
属性

文章 ID:3136205 - 上次审阅时间:2016年7月26日 - 修订版本: 1

反馈