none
DQS client not able connect to DQS server RRS feed

  • Question

  • I am trying to set-up logging in DQS as per the following article:

    https://docs.microsoft.com/en-us/sql/data-quality-services/configure-advanced-settings-for-dqs-log-files

    I modified the XML configuration file and executed the query as suggested in step 3, 4.

    <configuration>
      <configSections>
        <section name="loggingConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=e44a2bc38ed2c13c" />
      </configSections>
      <loggingConfiguration name="Logging Application Block" tracingEnabled="true" defaultCategory="" logWarningsWhenNoCategoriesMatch="true">
        <listeners>
          <add fileName="C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\DQServerLog.DQS_MAIN.log" footer="" formatter="Custom Text Formatter" header="" rollFileExistsBehavior="Increment" rollInterval="None" rollSizeKB="25000" timeStampPattern="yyyy-MM-dd" listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.RollingFlatFileTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=e44a2bc38ed2c13c" traceOutputOptions="None" filter="All" type="Microsoft.Practices.EnterpriseLibrary.Logging.TraceListeners.RollingFlatFileTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=e44a2bc38ed2c13c" name="Rolling Flat File Trace Listener" />
        </listeners>
        <formatters>
          <add template="{timestamp(local)}|[{threadName}]|{dictionary({value}|)}{message}" type="Microsoft.Practices.EnterpriseLibrary.Logging.Formatters.TextFormatter, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=e44a2bc38ed2c13c" name="Custom Text Formatter" />
        </formatters>
        <logFilters>
          <add enabled="true" type="Microsoft.Practices.EnterpriseLibrary.Logging.Filters.LogEnabledFilter, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=e44a2bc38ed2c13c" name="LogEnabled Filter" />
        </logFilters>
        <categorySources />
        <specialSources>
          <allEvents switchValue="All" name="All Events" />
          <notProcessed switchValue="All" name="Unprocessed Category" />
          <errors switchValue="All" name="Logging Errors &amp; Warnings">
            <listeners>
              <add name="Rolling Flat File Trace Listener" />
            </listeners>
          </errors>
        </specialSources>
      </loggingConfiguration>
    </configuration>


    But in the next step, I found that the stored procedure [internal_core].[RefreshLogSettings] doesn't exist

    Now, when I try to open SQL Server 2016 Data Quality Client, I get the following error:

    SQL Server Data Quality Services
    --------------------------------------------------------------------------------
    
    Message Id: LogOnWindowFailedToConnect
    Cannot connect to (LOCAL).
    
    A .NET Framework error occurred during execution of user-defined routine or aggregate "SetDataQualitySession": 
    System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user-defined routine or aggregate "SetDataQualitySessionPhaseTwo": 
    System.TypeInitializationException: The type initializer for 'Microsoft.Ssdqs.Core.Startup.ServerInit' threw an exception. ---> Microsoft.Ssdqs.Infra.Exceptions.ServerException: Failed to initialize configuration. ---> Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: Failed to init log configuration. ---> Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: No logger could be found. Add Root logger to configuration file.
    Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: 
       at Microsoft.Ssdqs.Infra.Log.LLogger.GetClassLoggingCategory(String className)
       at Microsoft.Ssdqs.Infra.Log.LLogger.GetLogger(Type loggerType)
       at Microsoft.Ssdqs.Infra.Database.DBUtility.InitLogger()
       at Microsoft.Ssdqs.Infra.Log.LLogger.InitConfiguration()
    Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: 
       at Microsoft.Ssdqs.Infra.Log.LLogger.InitConfiguration()
       at Microsoft.Ssdqs.Infra.Log.LLogger.GetLogger(Type loggerType)
       at Microsoft.Ssdqs.Core.Startup.ServerInit..cctor()
    Microsoft.Ssdqs.Infra.Exceptions.ServerException: 
       at Microsoft.Ssdqs.Core.Startup.ServerInit..cctor()
    System.TypeInitializationException: 
       at Microsoft.Ssdqs.Core.Startup.ServerInit.Init()
    .
    System.Data.SqlClient.SqlException: 
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
      ...
    
    --------------------------------------------------------------------------------
    System.Data.SqlClient.SqlException (0x80131904): A .NET Framework error occurred during execution of user-defined routine or aggregate "SetDataQualitySession": 
    System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user-defined routine or aggregate "SetDataQualitySessionPhaseTwo": 
    System.TypeInitializationException: The type initializer for 'Microsoft.Ssdqs.Core.Startup.ServerInit' threw an exception. ---> Microsoft.Ssdqs.Infra.Exceptions.ServerException: Failed to initialize configuration. ---> Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: Failed to init log configuration. ---> Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: No logger could be found. Add Root logger to configuration file.
    Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: 
       at Microsoft.Ssdqs.Infra.Log.LLogger.GetClassLoggingCategory(String className)
       at Microsoft.Ssdqs.Infra.Log.LLogger.GetLogger(Type loggerType)
       at Microsoft.Ssdqs.Infra.Database.DBUtility.InitLogger()
       at Microsoft.Ssdqs.Infra.Log.LLogger.InitConfiguration()
    Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: 
       at Microsoft.Ssdqs.Infra.Log.LLogger.InitConfiguration()
       at Microsoft.Ssdqs.Infra.Log.LLogger.GetLogger(Type loggerType)
       at Microsoft.Ssdqs.Core.Startup.ServerInit..cctor()
    Microsoft.Ssdqs.Infra.Exceptions.ServerException: 
       at Microsoft.Ssdqs.Core.Startup.ServerInit..cctor()
    System.TypeInitializationException: 
       at Microsoft.Ssdqs.Core.Startup.ServerInit.Init()
    .
    System.Data.SqlClient.SqlException: 
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
      ...
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecCommand()
       at Microsoft.Ssdqs.Proxy.Database.DBAccessClient.Exec()
       at Microsoft.Ssdqs.Proxy.EntryPoint.BaseEntryPointClient.SetDataQualitySession(Nullable`1 clientId, Nullable`1 knowledgebaseId)
       at Microsoft.Ssdqs.Proxy.EntryPoint.BaseEntryPointClient..ctor(String serverName, String databaseName, Nullable`1 clientId, Nullable`1 knowledgebaseId)
       at Microsoft.Ssdqs.Proxy.EntryPoint.NotificationEntryPointClient..ctor(String serverName, String databaseName)
       at Microsoft.Ssdqs.Studio.ViewModels.Data.Common.DataManager.ConnectToDatabase(String instance, String database, Boolean useEncryption)
       at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.Application.LogOnWindowViewModel.ConnectToServer()
       at Microsoft.Ssdqs.Studio.ViewModels.Utilities.UIAsynchronousRelayAction.Action()
       at Microsoft.Ssdqs.Studio.ViewModels.Utilities.UIAsynchronousAction.ActionExecuter()
    ClientConnectionId:3e42340e-2ff3-467c-a4db-8d59941ed595
    Error Number:6522,State:1,Class:16

    Any help is highly appreciated.

    Saturday, January 26, 2019 6:39 AM