Can't create and modify a Knowledge Base.

Question

Hi all,

When trying to open an existing knowledge base or when we create a new knowledge base we get the error below (SEE - Error that occurs when trying to create or open an existing knowledge base). 

We have set debug in the administration page to view the errors in the DQS_Main.log file but we don't see any paths we can take on our side to get us up and running (SEE - Error messages from DQS_Main.log) .  Is there any suggestions that can be made to fix our issue based on the errors posted in this thread?  We are using SQL 2012 with CU 2.

Thanks for any help.

Error that occurs when trying to create or open an existing knowledge base:

SQL Server Data Quality Services

--------------------------------------------------------------------------------

Message Id: ApplicationUnhandledException

An unhandled exception has occurred. For more details, see the Data Quality Services client log.

--------------------------------------------------------------------------------

System.InvalidOperationException: Sequence contains no elements

   at System.Linq.Enumerable.Max[TSource](IEnumerable`1 source)

   at Microsoft.Ssdqs.Studio.ViewModels.Data.Process.ProcessProvider.GetExecutionStatus(ProcessType[] processType)

   at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.DomainManagement.DomainManagementViewModel.InitializeDomainManagement()

   at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.DomainManagement.DomainManagementViewModel.ValueChanged(DataProperty property, Object oldValue, Object newValue)

   at Microsoft.Ssdqs.Studio.Infra.DataObjects.DataObjectBase.InvokePropertyChanged(DataProperty dataProperty, Object oldValue, Object newValue)

   at Microsoft.Ssdqs.Studio.Infra.DataObjects.DataObjectBase.InternalSetValue(DataProperty dataProperty, Object value, Boolean updateBinding)

   at Microsoft.Ssdqs.Studio.Views.Pages.Application.StartPageView.OpenKnowledgebase(Knowledgebase knowledgebase)

   at Microsoft.Ssdqs.Studio.Views.Pages.Application.StartPageView.OpenRecentKnowledgebase(Knowledgebase knowledgebase, KnowledgebaseActivity openActivity)

   at Microsoft.Ssdqs.Studio.Views.Pages.Application.StartPageView.OpenRecentItem(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)

Error messages from DQS_Main.log:

8/13/2012 9:33:00 AM|[]|21|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:02 AM|[]|23|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)
8/13/2012 9:33:05 AM|[]|29|ERROR|d5f9eeaa-0327-4d0d-b6a0-2b678a805a02|Microsoft.Ssdqs.Core.Flow.FlowExecuter|Flow ended with an application error.
Microsoft.Ssdqs.Core.Context.ResponseException: Failed to execute calibrator, or an error occurred during calibration. ---> System.Threading.ThreadAbortException: Thread was being aborted.;
   at System.Threading.Thread.SleepInternal(Int32 millisecondsTimeout);
   at Microsoft.Ssdqs.Core.Service.ServiceBroker.ServiceBrokerProxy.Receive(IMasterContext context, Int64 taskId);
   at Microsoft.Ssdqs.Core.Service.ParallelExecution.ParallelExecutionManager.Execute(IMasterContext context, String taskGroupId, ReadOnlyCollection`1 newTaskDataObjects, String flowToken, String initiatorServiceName, String targetServiceName, String requestQueueName);
   at Microsoft.Ssdqs.Core.Service.ParallelExecution.ParallelExecutionManager.Execute(IMasterContext context, String taskGroupId, ReadOnlyCollection`1 newTaskDataObjects, String flowToken);
   at Microsoft.Ssdqs.Cleansing.Correction.Service.CorrectionCalibrator.RunCorrectionOnDomains(IMasterContext context, IEnumerable`1 domains, CorrectionActionFactory factory, SimpleCalibrationRange range, Int64 lastInvertedId, ProfilingDataSourceMappingAnalyzer dataSourceMappingAnalyzer, CorrectionParameters parameters, Boolean isCompositeDomainFlow);
   at Microsoft.Ssdqs.Cleansing.Correction.Service.CorrectionCalibrator.CalibrateRange(IMasterContext masterContext, CorrectionCalibrationRange currentRange, CalibrationMode calibrationMode, ConfigurationDomParameter calibratorConfiguration);
   at Microsoft.Ssdqs.Core.Service.Calibration.Parallel.RangeCalibratorBase`1.Calibrate(IMasterContext masterContext, CalibrationMode calibrationMode, ConfigurationDomParameter calibratorConfiguration);
   at Microsoft.Ssdqs.Core.Service.Calibration.Impl.ExecuteCalibratorFlow.Process(IMasterContext context);
   --- End of inner exception stack trace ---;
   at Microsoft.Ssdqs.Core.Service.Calibration.Impl.ExecuteCalibratorFlow.Process(IMasterContext context);
   at Microsoft.Ssdqs.Core.Flow.FlowExecuter.ExecuteInNonTransaction(IMasterContext context, IFlow flow)
8/13/2012 9:33:06 AM|[]|29|WARN|d5f9eeaa-0327-4d0d-b6a0-2b678a805a02|Microsoft.Ssdqs.Core.Flow.FlowAudit|Auditing flow data for class: Microsoft.Ssdqs.Core.Service.Calibration.Impl.ExecuteCalibratorFlow failed.
System.Threading.ThreadAbortException: Thread was being aborted.;
   at System.Threading.Thread.AbortInternal();
   at System.Threading.Thread.Abort(Object stateInfo);
   at System.Data.SqlServer.Internal.ClrLevelContext.CheckSqlAccessReturnCode(SqlAccessApiReturnCode eRc);
   at System.Data.SqlServer.Internal.ClrLevelContext.TranBegin(Char* pwsName, Int32 cwchName, SmiEventSink sink, EIsoLvl isoLevel);
   at Microsoft.SqlServer.Server.InProcConnection.BeginTransaction(String name, IsolationLevel level, SmiEventSink eventSink);
   at System.Data.SqlClient.SqlInternalConnectionSmi.ExecuteTransaction(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest);
   at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName);
   at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName);
   at Microsoft.Ssdqs.Infra.Database.DBAccess.Begin();
   at Microsoft.Ssdqs.Core.Flow.FlowAudit.AuditAfterExecution(IMasterContext context)
8/13/2012 9:33:06 AM|[]|29|ERROR|d5f9eeaa-0327-4d0d-b6a0-2b678a805a02|Microsoft.Ssdqs.Core.Transformer.Transformer|Fatal Error in Microsoft.Ssdqs.Core.Transformer.Transformer
System.Threading.ThreadAbortException: Thread was being aborted.;
   at Microsoft.Ssdqs.Core.Flow.FlowExecuter.CallFlow(IMasterContext context);
   at Microsoft.Ssdqs.Core.Transformer.Transformer.InTransform(IMasterContext context)
8/13/2012 9:33:06 AM|[]|29|ERROR|d5f9eeaa-0327-4d0d-b6a0-2b678a805a02|Microsoft.Ssdqs.Core.Connector.ConnectorLogic|A fatal error occurred in the Connector.
System.Threading.ThreadAbortException: Thread was being aborted.;
   at Microsoft.Ssdqs.Core.Transformer.Transformer.InTransform(IMasterContext context);
   at Microsoft.Ssdqs.Core.Connector.ConnectorLogic.ProcessMessage(IMasterContext context)
8/13/2012 9:33:06 AM|[]|29|ERROR|8459c606-b066-49ef-83e3-3aeaa81af9fe|Microsoft.Ssdqs.Core.Flow.FlowExecuter|Flow ended with an application error.
Microsoft.Ssdqs.Core.Context.ResponseException: A fatal error occurred during the running of process calibration flow. ---> System.Threading.ThreadAbortException: Thread was being aborted.;
   at System.Threading.Thread.AbortInternal();
   at System.Threading.Thread.Abort(Object stateInfo);
   at System.Data.SqlServer.Internal.ClrLevelContext.CheckSqlAccessReturnCode(SqlAccessApiReturnCode eRc);
   at System.Data.SqlServer.Internal.ClrLevelContext.GetCurrentContext(SmiEventSink sink, Boolean throwIfNotASqlClrThread, Boolean fAllowImpersonation);
   at Microsoft.SqlServer.Server.InProcLink.GetCurrentContext(SmiEventSink eventSink);
   at Microsoft.SqlServer.Server.SmiContextFactory.GetCurrentContext();
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection);
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup);
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection);
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory);
   at System.Data.SqlClient.SqlConnection.Open();
   at Microsoft.Ssdqs.Infra.Database.DBAccess..ctor(Boolean initNewConnection, Boolean useExternalConnection, String applicationName);
   at Microsoft.Ssdqs.Core.Service.Calibration.NoContextConnectionScope.Dispose(Boolean disposing);
   at Microsoft.Ssdqs.Infra.Utilities.DisposableObject.Dispose();
   at Microsoft.Ssdqs.Core.Service.Process.RunManualTriggerFlow.Process(IMasterContext context);
   --- End of inner exception stack trace ---;
   at Microsoft.Ssdqs.Core.Flow.FlowHelper.HandleException(IMasterContext context, Exception exception, ExceptionMessage logMessage, Object[] arguments);
   at Microsoft.Ssdqs.Core.Service.Process.RunManualTriggerFlow.Process(IMasterContext context);
   at Microsoft.Ssdqs.Core.Flow.FlowExecuter.ExecuteInNonTransaction(IMasterContext context, IFlow flow)
8/13/2012 9:33:06 AM|[]|29|WARN|8459c606-b066-49ef-83e3-3aeaa81af9fe|Microsoft.Ssdqs.Core.Flow.FlowAudit|Auditing flow data for class: Microsoft.Ssdqs.Core.Service.Process.RunManualTriggerFlow failed.
System.InvalidOperationException: ExecuteReader: Connection property has not been initialized.;
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async);
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result);
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method);
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method);
   at System.Data.SqlClient.SqlCommand.ExecuteReader();
   at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecCommand();
   at Microsoft.Ssdqs.Infra.Database.Dao.DaoControllerBase`5.Execute();
   at Microsoft.Ssdqs.Core.Flow.FlowAudit.AuditAfterExecution(IMasterContext context)
8/13/2012 9:33:06 AM|[]|29|ERROR|8459c606-b066-49ef-83e3-3aeaa81af9fe|Microsoft.Ssdqs.Core.Transformer.Transformer|Fatal Error in Microsoft.Ssdqs.Core.Transformer.Transformer
System.Threading.ThreadAbortException: Thread was being aborted.;
   at Microsoft.Ssdqs.Core.Flow.FlowExecuter.CallFlow(IMasterContext context);
   at Microsoft.Ssdqs.Core.Transformer.Transformer.InTransform(IMasterContext context)
8/13/2012 9:33:06 AM|[]|29|ERROR|8459c606-b066-49ef-83e3-3aeaa81af9fe|Microsoft.Ssdqs.Core.Connector.ConnectorLogic|A fatal error occurred in the Connector.
System.Threading.ThreadAbortException: Thread was being aborted.;
   at Microsoft.Ssdqs.Core.Transformer.Transformer.InTransform(IMasterContext context);
   at Microsoft.Ssdqs.Core.Connector.ConnectorLogic.ProcessMessage(IMasterContext context)
8/13/2012 9:35:03 AM|[]|14|ERROR|d5f9eeaa-0327-4d0d-b6a0-2b678a805a02|Microsoft.Ssdqs.Core.Flow.FlowExecuter|Flow ended with an application error.
Microsoft.Ssdqs.Core.Context.ResponseException: Process execution was stopped by the user [process id: 0]. ---> Microsoft.Ssdqs.Core.Service.Process.ProcessStoppedException: Process execution was stopped by the user [process id: 0].;
   at Microsoft.Ssdqs.Core.Service.Process.ProcessManager.ThrowProcessStoppedException(Int64 processId);
   at Microsoft.Ssdqs.Cleansing.Correction.Action.CorrectionFlow.Process(IMasterContext context);
   --- End of inner exception stack trace ---;
   at Microsoft.Ssdqs.Cleansing.Correction.Action.CorrectionFlow.Process(IMasterContext context);
   at Microsoft.Ssdqs.Core.Flow.FlowExecuter.ExecuteInNonTransaction(IMasterContext context, IFlow flow)
8/13/2012 9:35:03 AM|[]|14|WARN|d5f9eeaa-0327-4d0d-b6a0-2b678a805a02|Microsoft.Ssdqs.Core.Service.ServiceBroker.ServiceBrokerUtility|Task execution ended with an error.
Microsoft.Ssdqs.Infra.Exceptions.EntryPointException:
---begin---
UID=d5f9eeaa-0327-4d0d-b6a0-2b678a805a02
MessageID=ProcessExecutionStopped
MessageDateTime=8/13/2012 9:35:03 AM
Data=0
Exception=Microsoft.Ssdqs.Core.Service.Process.ProcessStoppedException: Process execution was stopped by the user [process id: 0].;
   at Microsoft.Ssdqs.Core.Service.Process.ProcessManager.ThrowProcessStoppedException(Int64 processId);
   at Microsoft.Ssdqs.Cleansing.Correction.Action.CorrectionFlow.Process(IMasterContext context)
---end---
 ---> Microsoft.Ssdqs.Core.Service.Process.ProcessStoppedException: Process execution was stopped by the user [process id: 0].;
   at Microsoft.Ssdqs.Core.Service.Process.ProcessManager.ThrowProcessStoppedException(Int64 processId);
   at Microsoft.Ssdqs.Cleansing.Correction.Action.CorrectionFlow.Process(IMasterContext context);
   --- End of inner exception stack trace ---;
   at Microsoft.Ssdqs.Core.Service.ServiceBroker.ServiceBrokerUtility.ExecuteTask(IMasterContext basicContextParameters, String flowToken, Object dataObject)
8/13/2012 9:36:51 AM|[]|4|INFO|PUID|Microsoft.Ssdqs.Core.Startup.ServerInit|Starting DQS ServerInit: version [11.0.2325.0], machine name [ABCDB-STAGING], user name [NT Service\MSSQL$WAREHOUSE], operating system [Microsoft Windows NT 6.1.7601 Service Pack 1]...
8/13/2012 9:36:55 AM|[]|4|DEBUG|UID_KEY|Microsoft.Ssdqs.DataValueService.Calibrator.ImportProjectValuesCalibrator|ImportProjectValuesCalibrator::Init --> starts.
8/13/2012 9:36:56 AM|[]|4|DEBUG|UID_KEY|Microsoft.Ssdqs.DataValueService.Calibrator.ImportProjectValuesCalibrator|ImportProjectValuesCalibrator::Init --> ends.
8/13/2012 9:36:56 AM|[]|4|WARN|PUID|Microsoft.Ssdqs.ImportExportManagement.Calibrator.ImportKnowledgebaseCalibrator|The Import KB calibrator configuration could not be received from the configuration service.
8/13/2012 9:36:56 AM|[]|4|WARN|PUID|Microsoft.Ssdqs.ImportExportManagement.Calibrator.ImportDomainCalibrator|The Import domain calibrator configuration could not be received from the configuration service.
8/13/2012 9:36:57 AM|[]|4|INFO|PUID|Microsoft.Ssdqs.Core.Startup.ServerInit|DQS ServerInit started.
8/13/2012 9:37:31 AM|[]|5|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 7 result(s)
8/13/2012 9:37:32 AM|[]|5|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:37:33 AM|[]|5|DEBUG|UID_KEY|Microsoft.Ssdqs.DomainRules.Service.DomainRulesService|DomainRulesService::Execute --> Executing request: context : Operation : IsActiveRulesChanged;
Rules : ;
DomainIds : [1000 , ];
RuleIds : ;
TestStrings : ;
CompositeDomainIds : ;
TestRecords : ;
;

8/13/2012 9:37:33 AM|[]|5|DEBUG|UID_KEY|Microsoft.Ssdqs.DomainRules.Service.DomainRulesService|DomainRulesService::Execute --> Executing request: context : Operation : IsRestoreAvailable;
Rules : ;
DomainIds : [1000 , ];
RuleIds : ;
TestStrings : ;
CompositeDomainIds : ;
TestRecords : ;
;

8/13/2012 9:37:33 AM|[]|5|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 7 result(s)
8/13/2012 9:37:33 AM|[]|5|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:39:06 AM|[]|10|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 7 result(s)
8/13/2012 9:39:06 AM|[]|10|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:39:09 AM|[]|4|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:39:09 AM|[]|9|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:39:12 AM|[]|10|INFO|f40bcfd9-3483-4b69-99c3-0d30470d8a13|Microsoft.Ssdqs.Core.Service.KnowledgebaseManagement.Managers.DBSchemaManager|Dropping DB schema [DQS_MAIN].[KnowledgeBase1001123]
8/13/2012 9:39:12 AM|[]|10|INFO|f40bcfd9-3483-4b69-99c3-0d30470d8a13|Microsoft.Ssdqs.Core.Service.KnowledgebaseManagement.Managers.DBSchemaManager|Dropping contents of DB schema [DQS_MAIN].[KnowledgeBase1001123]
8/13/2012 9:39:13 AM|[]|9|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 9 result(s)
8/13/2012 9:39:13 AM|[]|4|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 0 result(s)
8/13/2012 9:39:14 AM|[]|10|DEBUG|UID_KEY|Microsoft.Ssdqs.DataService.Service.DataServiceConcrete|DataServiceConcrete::Query --> Query found 1 result(s)

Answer 1

I haven't seen this one before...

1. By chance is the DQS_MAIN and DQS_PROJECTS database and tlog online?

Any free space?

exec sp_helpdb 'DQS_MAIN'
exec sp_helpdb 'DQS_PROJECTS'
exec DQS_MAIN.dbo.sp_spaceused
exec DQS_PROJECTS.dbo.sp_spaceused

2. Can you please check the SQL Errorlog for any clues there.

3. Have you renamed the server or anything "changed" lately? Installed any patches?

4. You could run a profiler trace, and see if there is a stored procedure, or TSQL batch failing, and see if there is any Error reported in SQL engine itself.

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 2

Hi

I have the same error doing the same things (trying to access a knowledge base). There are no SQL errors in the profiler , but this one is from DQS log file:

9/27/2012 4:05:00 PM|[]|26|ERROR|20f3dbe9-b4bb-4998-bfb8-1283880a2f81|Microsoft.Ssdqs.Core.Flow.FlowExecuter|Flow ended with an application error.
Microsoft.Ssdqs.Core.Context.ResponseException: The attempt to update or delete a DAO object of type 'AKnowledgebase' with id 1000048 has failed because the object is not up to date or is being deleted from the database. ---> Microsoft.Ssdqs.Infra.Database.Dao.ConcurrencyObjectException: The attempt to update or delete a DAO object of type 'AKnowledgebase' with id 1000048 has failed because the object is not up to date or is being deleted from the database.;
   at Microsoft.Ssdqs.Infra.Database.Dao.Core.AKnowledgebaseController.<>c__DisplayClass2.<PrepareForUpdate>b__0(SqlDataReader reader);
   at Microsoft.Ssdqs.Infra.Database.Dao.DaoControllerBase`5.Execute();
   at Microsoft.Ssdqs.Core.Service.KnowledgebaseManagement.Managers.BaseKnowledgebaseManager.ExitKnowledgebase(IMasterContext context, BaseKnowledgebase knowledgebase, Boolean resetInWorkPhase);
   at Microsoft.Ssdqs.Core.Service.KnowledgebaseManagement.Service.KnowledgebaseServiceConcrete.Execute(IMasterContext context, IServiceRequest request);
   at Microsoft.Ssdqs.Flow.Services.ExecuteServiceFlow.Process(IMasterContext context);
   --- End of inner exception stack trace ---;
   at Microsoft.Ssdqs.Core.Flow.FlowHelper.HandleException(IMasterContext context, Exception exception, ExceptionMessage logMessage, Object[] arguments);
   at Microsoft.Ssdqs.Flow.Services.ExecuteServiceFlow.Process(IMasterContext context);
   at Microsoft.Ssdqs.Core.Flow.FlowExecuter.ExecuteInNewTransaction(IMasterContext context, IFlow flow)

I also found this error in SQL Server logs (didn't happen at the time I was trying to open a knowledge bas, but could be related)

Message
Failed refreshing assembly System.Windows.Forms. Error number: 6218, message: ALTER ASSEMBLY for assembly 'System.Windows.Forms' failed because assembly 'System.Drawing.Design' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
Assembly in host store has a different signature than assembly in GAC.
Assembly in host store has a different signature than assembly in GAC.
Assembly in host store has a different signature than assembly in GAC.
Assembly in host store has a different signature than assembly in GAC.
Assembly in host store has a different signature than assembly in GAC.
Assembly in host store has a different signature than assembly in GAC.
Assembly in host store has a different signature than assembly in GAC.
Assembly in host store has a different signature than assembly in GAC.
Assembly in host store has a different signature than assembly in GAC.
Assembly in host store has a different signature than assembly in GAC.
[ : System.Drawing.Design.DesignerToolboxInfo::.ctor][mdToken=0x600006e] Assembly in host store has a different signature than assembly in GAC.
[ : System.Drawing.Design.DesignerToolboxInfo::get_ToolboxUser][mdToken=0x6000071] Assembly in host store has a different signature than assembly in GAC.
[ : System.Drawing.Design.DesignerToolboxInfo::OnDesignerDisposed][mdToken=0x6000074][offset 0x00000001]System.IO.FileLoadException: Could not load file or assembly 'System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050) Assembly in host store has a different signature than assembly in GAC.
[ : System.Drawing.Design.DesignerToolboxInfo::OnSelectionChanged][mdToken=0x6000075][offset 0x0000000F] Unable to resolve token.
[ : System.Drawing.Design.DesignerToolboxInfo::Update][...

Answer 3

I've run dqsinstaller.exe -upgradedlls and it's resolved SQL Server error message issue. But I still can't open / edit any of the knowledge bases

Answer 4

What's the error in the DQS log now?

C:\Program Files\Microsoft SQL Server\MSSQL11.<instancename>\MSSQL\Log\DQServerLog.DQS_MAIN.log

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 5

Hi

There are no error messages in the log now but I still get an error on the client side, when I try to open/edit a knowledge base.

I tried to run SSIS package with DQS cleansing component in it  - it worked just fine. I also have a lot (probably around a thousand) of "residual" SSIS data cleansing projects , when I open the DQS project tab....

Answer 6

I believe I'm having the same issue.

• I upgraded to the .NET 4.5 framework
• I ran dqsinstaller.exe -upgradedlls
• The Data Quality Client seems to work correctly
• The DQS Cleansing Component does not work correctly

I can add the component and connect to the SQL Server DQS instance; however, none of of my knowledge bases appear in the list.

As far as I can tell there is no way to downgrade DQS back to 4.0 even if I uninstall 4.5. It seems I'm going to have to do a full re-install of SQL Server and Visual Studio.

Are there any other alternative solutions?

Answer 7

The DQS product team is working on making it compatible with .Net 4.5.

There is a fix to be released in SQL 2012 Service Pack 1. However it is not yet out yet.

There is a CTP preview of PCU1 from 9/20/2012, but that current preview release does not include the fixes for this compatibility issue.

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 8

Thanks for the response Jason. Do you have a release date for SQL Server 2012 SP1 yet?

FYI, I was able to get back to a functioning environment by taking the following steps:

• Uninstalled Visual Studio 2012
• Uninstalled .NET Framework 4.5
• Repair Installed Visual Studio 2010
• DQSInstaller.exe -upgradedlls

Answer 9

Was this issue fixed in SP1 or SP1 CU1? I did not see it specifically listed in the fixes.

Answer 10

Yes it was supposed to be fixed. I'm not sure why it missed the docs though.

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 11

SP1 release http://www.microsoft.com/en-us/download/details.aspx?id=35575

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance