Simptomi
Postavili ste decimalni tip podataka koji sadrži najmanje jednu vrednost "null" u svojstvima domena projekta Usluga kvaliteta podataka (DQS). Kada izvezete rezultate čišćenja u Microsoft SQL Server bazu podataka, dobijate poruku o grešci koja je slična sledećoj:
ID poruke: ExportFailedToCreateNewTableFailed za kreiranje nove tabele table_name u database_name. Proverite da li tabela već postoji i neka se administrator baze podataka uveri da DQS usluga ima prava CREATE TABLE u odredišnoj bazi podataka i da li može da je umetne u odredišnu tabelu. Microsoft.Ssdqs.Infra.Exceptions.EntryPointException: kreiranje nove tabele "MyTable" u bazi podataka "Test". Proverite da li tabela već postoji i neka se administrator baze podataka uveri da DQS usluga ima prava CREATE TABLE u odredišnoj bazi podataka i da li može da je umetne u odredišnu tabelu. 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 standardizeOut, Boolean isExportRecordStatus) at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.DQProject.CorrectionDatabaseDestinationViewModel.ExportFields(Int)64 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, Cilj objekta) na lokaciji System.Windows.RoutedEventArgs.InvokeHandler(Delegat 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) System.Windows.UIElement.ReRaiseEventAs(DependencyObject pošiljalac, 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.InvokeEventHandler(Delegate genericHandler, Object genericTarget) at System.Windows.RoutedEventArgs.Invoke Cilj objekta) na lokaciji System.Windows.RoutedEventHandlerInfo.InvokeHandler(Cilj objekta, RoutedEventArgs routedEventArgs) na System.Windows.EventRoute.InvokeHandlersImpl(Objekat source, RoutedEventArgs args, Boolean reRaised) at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
Rešenje
Kumulativne informacije o ažuriranju
Ovaj problem je rešen u sledećim ispravkama:
-
Kumulativna ispravka 13 za SQL Server 2014
-
Kumulativna ispravka 6 za SQL Server 2014 servisni paket 1 (SP1)
-
Kumulativna ispravka 11 za SQL Server 2012 servisni paket 2 (SP2)
Svaka nova kumulativna ispravka za SQL Server sadrži sve hitne ispravke i sve bezbednosne ispravke koje su bile uključene u prethodnu kumulativnu ispravku. Pogledajte najnovije kumulativne ispravke za SQL Server:
Status
Microsoft je potvrdio da je ovo problem u Microsoft proizvodima koji su navedeni u odeljku "Odnosi se na".
Reference
Saznajte više o terminologiji koju Microsoft koristi za opisivanje softverskih ispravki.