Simptomi
Decimalnu vrstu podataka možete postaviti koja sadrži barem jednu vrijednost null u svojstvima domene projekta servisa za kvalitetu podataka (DQS). Kada izvezete rezultate čišćenja u bazu podataka sustava Microsoft SQL Server, prikazat će vam se poruka o pogrešci slična ovoj:
Napomena
ID poruke: ExportFailedToCreateNewTable
Nije uspjelo stvaranje nove tablice table_name u bazi podataka database_name. Provjerite postoji li tablica te neka administrator baze podataka provjeri ima li servis DQS prava CREATE TABLE u odredišnoj bazi podataka te može li umetnuti u odredišnu tablicu.
Microsoft.Ssdqs.Infra.Exceptions.EntryPointException: Nije uspjelo stvaranje nove tablice "MyTable" u bazi podataka "Test". Provjerite postoji li tablica te neka administrator baze podataka provjeri ima li servis DQS prava CREATE TABLE u odredišnoj bazi podataka te može li umetnuti u odredišnu tablicu.
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(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(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(Izvor objekta, RoutedEventArgs args, Boolean ponovno podignuto)
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)
u 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(Izvor objekta, RoutedEventArgs args, Boolean ponovno podignuto)
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(Izvor objekta, RoutedEventArgs args, Boolean ponovno podignuto)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
Rješenje
Kumulativni podaci o ažuriranju
Taj je problem riješen u sljedećim ažuriranjima:
- Kumulativno ažuriranje 13 za SQL Server 2014
- Kumulativno ažuriranje 6 za SQL Server 2014 Service Pack 1 (SP1)
- Kumulativno ažuriranje 11 za SQL Server 2012 Service Pack 2 (SP2)
- Kumulativno ažuriranje 3 za SQL Server 2012 SP3
- Kumulativno ažuriranje 1 za SQL Server 2016
Preporuka: instalirajte najnovije kumulativno ažuriranje za SQL Server
Svako novo kumulativno ažuriranje za SQL Server sadrži sve hitne popravke i sigurnosne popravke koji su obuhvaćeni prethodnim kumulativnim ažuriranjem. Pogledajte najnovija kumulativna ažuriranja za SQL Server:
- Najnovije kumulativno ažuriranje za SQL Server 2014
- Najnovije kumulativno ažuriranje za SQL Server 2014 SP1
- Najnovije kumulativno ažuriranje za SQL Server 2012 SP2
- Najnovije kumulativno ažuriranje za SQL Server 2012 SP3
- Najnovije kumulativno ažuriranje za SQL Server 2016
Status
Microsoft je potvrdio da je to problem u Microsoftovim proizvodima koji su navedeni u odjeljku „Odnosi se na“.
Reference
Saznajte više o terminologiji koju Microsoft upotrebljava za opisivanje softverskih ažuriranja.