none
error message when export data and cleansing info

    Question

  • Hi all,

    I am trying to export my cleansed dataset into a database that is on the same instance as the dqs_main. If I choose "data only", the export opration works. But if I choose "Data and cleansing info", I got an exception as below. My DQS instance is running on 11.0.3339 build. I do not know what is casue the problem and do know a fix. Please help!

    thanks!

    Error Message:

    SQL Server Data Quality Services
    --------------------------------------------------------------------------------
    2/14/2013 1:44:31 PM
    Message Id: ExportFailedToCreateNewTable
    Failed to create a new table 'y1' in database 'SHIData'. 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 'y1' in database 'SHIData'. 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)
       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)


    hyang

    Thursday, February 14, 2013 6:53 PM

All replies

  • Hi

    Please check if there is any table with same name does already exists in database .

    Error :Failed to create a new table 'y1' in database 'SHIData'. 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.

    --------------> Please also check wether you have ddl_admin role on database 'SHIData'. You can check same by manually creating table using ssms 

    Thanks

    Saurabh Sinha

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Thursday, February 14, 2013 7:19 PM
  • Hi,

    I am pretty sure that the table does exist.

    thank for your reply.

    Hua


    hyang

    Thursday, February 14, 2013 7:22 PM