Skip to content

Latest commit

 

History

History
73 lines (48 loc) · 5.38 KB

manage-dqs-log-files.md

File metadata and controls

73 lines (48 loc) · 5.38 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Manage DQS Log Files
Manage DQS Log Files
swinarko
sawinark
03/01/2017
sql
data-quality-services
conceptual
logging
log files
dqs log files

Manage DQS Log Files

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDEssDQSnoversion] (DQS) log files help you in diagnosing and troubleshooting issue with [!INCLUDEssDQSServer], [!INCLUDEssDQSClient], and the [!INCLUDEssDQSCleansingLong]. Separate log files are generated for [!INCLUDEssDQSServer], [!INCLUDEssDQSClient], and the [!INCLUDEssDQSCleansing].

You can use [!INCLUDEssDQSClient] to configure the log severity setting for [!INCLUDEssDQSServer] features and modules. Additionally, you can also configure some other (advanced) settings for the DQS log files by manually changing the DQS log configuration settings in the DQS_MAIN database and an XML file on the [!INCLUDEssDQSClient] computer.

Data Quality Server Log File

The [!INCLUDEssDQSServer] log file, DQServerLog.DQS_MAIN.log, includes logs of activities that are run on [!INCLUDEssDQSServer]. If you installed the default instance of SQL Server, the DQServerLog.DQS_MAIN.log file is available at C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log. The [!INCLUDEssDQSServer] log file contains the following pieces of information, each delimited by a pipe (|):

  • Date and time

  • Thread name

  • Thread ID

  • Log severity (FATAL, ERROR, WARN, INFO, and DEBUG)

    [!NOTE]
    The DEBUG logging severity is same as Verbose.

  • UID (internal DQS infrastructure ID)

  • Namespace

  • Class and method

  • Message

Along with these, the log file also displays information about the application version, computer name, user name, and operating system.

A sample entry in the [!INCLUDEssDQSServer] log file looks like the following:

23-08-2013 01:45:29|[]|4|INFO|PUID|InfInfoModuleStarting|Microsoft.Ssdqs.Core.Startup.ServerInit|Starting DQS ServerInit: version [12.0.0.0], machine name [DQS-TEST], user name [NT Service\MSSQLSERVER], operating system [Microsoft Windows NT 6.1.7600.0]...

The DQServerLog.DQS_MAIN.log file is a rolling file, and a new log file is created once the existing log file exceeds the rolling file size limit specified in the [!INCLUDEssDQSServer] log configuration settings. For more information, see Configure Advanced Settings for DQS Log Files.

Data Quality Client Log File

The [!INCLUDEssDQSClient] log file, DQClientLog.log, includes the client side logs. The [!INCLUDEssDQSClient] log file is available at %APPDATA%\SSDQS\Log. The [!INCLUDEssDQSClient] log file contains similar set of information as in the server log file, but for the client side.

As with the [!INCLUDEssDQSServer] log file, the [!INCLUDEssDQSClient] log file is also a rolling file, and a new log file is created once the existing log file exceeds the rolling file size limit specified in the [!INCLUDEssDQSClient] log configuration settings. For more information, see Configure Advanced Settings for DQS Log Files.

DQS Cleansing Component Log File

The [!INCLUDEssDQSCleansing] log file, DQSSSISLog.log, includes logs of activities performed using the [!INCLUDEssDQSCleansingLong]. The [!INCLUDEssDQSCleansing] component log file is available at %APPDATA%\SSDQS\Log. The [!INCLUDEssDQSCleansing] log file contains similar set of information as in the server log file, but for the [!INCLUDEssDQSCleansing].

Related Tasks

Task Description Topic
Describes how to configure log severity settings for DQS log files using [!INCLUDEssDQSClient]. Configure Severity Levels for DQS Log Files
Describes how to manually configure advanced settings for DQS log files. Configure Advanced Settings for DQS Log Files

See Also

DQS Administration