This article contains information about the issues that you might encounter while using Data Quality Services (DQS), and how to resolve them. Please let us know if you encounter any other issues (not documented here) while using DQS by posting it on Data Quality Services MSDN Forum.

If you want to contribute to this article, use the Edit tab at the top (require sign-in). This article will be updated as and when we come across new issues, or resolve existing issues.

While working with DQS, you might encounter any of the following issues:

• Unable to connect to Data Quality Server
• Unable to connect to Data Quality Server after installing cumulative update or patch
• Unable to connect to Data Quality Server after attaching the DQS databases
• Unable to connect to Data Quality Server after installing .NET Framework Updates
• Error: The context.DQSession argument cannot be null
• All options are unavailable/dimmed in Data Quality Client
• Source/destination database is not available in Data Quality Client for DQS operations
• Some activities are unavailable for a knowledge base
• Limitation with cleansing data columns of NVARCHAR(MAX) and VARCHAR(MAX) data types in the DQS Cleansing component in Integration Services
• Error when Data Quality Client is left idle for an extended period
• Error during mapping in Data Quality Client when source data table contains columns of certain data types
• Error while exporting the results during the cleansing or matching activity to an Excel sheet
• Error while running an SSIS package containing a DQS Cleansing component
• Error while running an SSIS package containing a DQS Cleansing component targeting another Data Quality Server
• Can't see any knowledge bases in the drop-down list of the DQS Cleansing connection manager in SSIS
• Error: The attempt to update or delete a DAO object of type 'AKnowledgebase' with id <ID> has failed because the object is not up to date or is being deleted from the database

Unable to connect to Data Quality Server

If you try to connect to a Data Quality Server by using Data Quality Client, you receive the following error message:

“Cannot connect to the <DataQualityServer_Name>”
Message Id: LogOnWindowFailedToConnect

This occurs if any of the following three is true:

• You have not completed the Data Quality Server installation by running the DQSInstaller.exe after completing the SQL Server setup. The following is displayed in the error message details:
  
  “Cannot open database "DQS_MAIN" requested by the login. The login failed. Login failed for user.”
  
  To fix this issue, complete the Data Quality Server installation, and then connect to the Data Quality Server using the Data Quality Client. For more information, see Run DQSInstaller.exe to Complete Data Quality Server Installation.
• Data Quality Server is installed in a named instance, and you have not specified the SQL Server instance name along with computer name in the Connect to Server dialog box in the Data Quality Client application, or have specified an incorrect instance name. As with database engine in SQL Server, multiple instances of Data Quality Server can be installed on a single computer, one per database engine instance. The following is displayed in the error message details:
  
  “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessllation, and then connect to the Data Quality Server using the Data Quality Client. For more information, see Run DQSInstaller.exe to Complete Data Quality Server Installation.
• Data Quality Server is installed in a named instance,ible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.”
  
  To fix this issue, specify the correct instance name along with the computer name to connect to. For example: “(LOCAL)\<Instance_Name>” if Data Quality Server is on the same computer, and “<Computer_Name>\<Instance_Name>” if Data Quality Server is on remote computer.
• Data Quality Server is installed on remote computer, and the TCP/IP protocol is not enabled for the SQL Server instance on the remote computer where Data Quality Server is installed. The following is displayed in the error message details:
  
  “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.”
  
  To fix this issue, enable the TCP/IP protocol for the SQL Server instance on the remote computer where Data Quality Server is installed, and then connect to the server using the Data Quality Client application. For more information, see Enable TCP/IP Network Protocol for SQL Server.

Unable to connect to Data Quality Server after installing cumulative update or patch

If you installed a cumulative update or patch to update DQS, you might receive the following error while trying to connect to Data Quality Server using your Data Quality Client:

To fix this issue, follow the instructions available at Upgrade DQS: Installing Cumulative Updates or Hotfix Patches on Data Quality Services (en-US).

Unable to connect to Data Quality Server after attaching the DQS databases

After attaching the DQS databases to the same or a different SQL Server instance containing Data Quality Server, you might receive the following error while trying to connect to Data Quality Server on the particular server using your Data Quality Client:

To fix this issue, you must run some Transact-SQL statements after attaching the DQS databases. To do so:

1. Using SQL Server Management Studio, connect to the SQL Server instance where you attached the DQS databases.
2. In Object Explorer, right-click the server, and then click New Query.
3. In the Query Editor window, copy the following SQL statements:
   ALTER DATABASE [DQS_MAIN] SET TRUSTWORTHY ON;
   EXEC sp_configure 'clr enabled', 1;
   RECONFIGURE WITH OVERRIDE
   ALTER DATABASE [DQS_MAIN] SET ENABLE_BROKER
   ALTER AUTHORIZATION ON DATABASE::[DQS_MAIN] TO [##MS_dqs_db_owner_login##]
   ALTER AUTHORIZATION ON DATABASE::[DQS_PROJECTS] TO [##MS_dqs_db_owner_login##]
   
4. Press F5 to execute the statements. Check the Results pane to verify that the statements have executed successfully. You will see the following message: Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
5. Connect to the Data Quality Server using the Data Quality Client to verify if you can connect successfully.

Unable to connect to Data Quality Server after installing .NET Framework Updates

After installing .NET Framework updates on your Data Quality Server computer, you might receive any of the following thr/> ALTER AUTHORIZATION ON DATABASE::[DQS_PROJECTS] TO [##MS_dqs_db_owner_login##]

To fix this issue, you must run dqsinstaller.exe at the command prompt with the -upgradedlls command line parameter. For detailed information, see Upgrade SQLCLR Assemblies After .NET Framework Update.

Error: The context.DQSession argument cannot be null

When you try to connect to a Data Quality Server using the Data Quality Client application, you might receive the following error:

“The context.DQSession argument cannot be null."
Message Id: InfArgumentCannotBeNull

To fix this issue:

1. Restart the SQL Server service for the instance where Data Quality Server is installed.
2. Connect to the Data Quality Server using the Data Quality Client application.

All options are unavailable/dimmed in Data Quality Client

When you log on to the Data Quality Client application, all the options in the Data Quality Client home screen are unavailable/dimmed.

To fix this issue, ensure that the user account with which you logged on to the Data Quality Client is assigned one of the three dqs roles (dqs_administrator, dqs_kb_editor, and dqs_kb_operator) on the DQS_MAIN database. For information about doing so, see Grant DQS Roles to Users.

Source/destination database is not available in Data Quality Client for DQS operations

Your source/destination database will not be available in the DQS client for any of the DQS operations (knowledge discovery, cleansing, matching, and data export) if the source/destination database is not in the same SQL Server instance as the Data Quality Server.

To fix this issue, ensure that your source/destination database is in the same SQL Server instance as the Data Quality Server you are connected to.

Some activities are unavailable for a knowledge base

While opening a knowledge base in the Open knowledge base screen to perform some activity, you might notice that only a single activity out of the three activities (Domain Management, Knowledge Discovery, and Matching Policy) is available. This happens because the knowledge base is in the middle of an activity, and you can continue with only that activity on that knowledge base. The State field displays the granular level of the activity that is currently active for the knowledge base. Even if you unlock the knowledge base, other activities are still not available, and you have to continue with the currently active activity.

To perform any other activity on the knowledge base, you can do either of the following:

• Open the knowledge base, complete the current activity, and then publish it.
• Open the knowledge base, and click Cancel to end current activity. If you do this, all your work on the knowledge base pertaining to the current activity will be lost.

Limitation with cleansing data columns of NVARCHAR(MAX) and VARCHAR(MAX) data types in the DQS Cleansing component in Integration Services

Data columns of the NVARCHAR(MAX) and VARCHAR(MAX) data types are not supported in the DQS Cleansing component in Integration Services. As such, these data columns are unavailable for mapping in the Mapping tab of DQS Cleansing Transformation Editor, and hence cannot be cleansed.

To fix this issue, before processing these data columns using the DQS Cleansing component, you must convert them to DT_STR or DT_WSTR data type using the Data Conversion transform.

Error when Data Quality Client is left idle for an extended period

The following error might appear if the Data Quality Client application is left idle for an extended period of time:

This however does not lead to loss of work. Click OK in the error message to close it, and continue with your work. If Data Quality Client does not respond after closing the error message, restart your Data Quality Client application.

Error during mapping in Data Quality Client when source data table contains columns of certain data types

The following error might appear when you click Next in the Map stage of the knowledge discovery, data cleansing, or data matching activities:

This error occurs because your source table contains columns of certain data types such as geography, geometry, image, and hierarchyid.

Options to fix this issue;
1. Remove the columns of these data types from your source table, and map your source table columns again with DQS domains in the Data Quality Client application.
2. Import the data into an Excel spreadsheet and use DQS to analyze the data from there.  Note that if you insert the data from a database source, you may find that DQS analyzes the empty rows if the complete spreadsheet has a linked datasource e.g. SQL table.  This will cause the task to take much longer than required, so save the file without the linked data by copying the data to a new file and saving.

Error while exporting the results during the cleansing or matching activity to an Excel sheet

The following error message might appear while exporting the cleansed data to an Excel file during the cleansing activity:

Similarly, on exporting the matching data to an Excel file during the matching activity, the following error message might appear:

This error occurs because DQS does not allow export of the cleansing or matching results to an Excel file if you are using 64-bit version of Excel. You can export the results only to a SQL Server database or to a .csv file.

To workaround this issue, export the results to a SQL Server database or to a .csv file if you are using 64-bit version of Excel.

Error while running an SSIS package containing a DQS Cleansing component

One of the following two error messages might appear while running a SSIS package that contains a DQS Cleansing component:

ERROR MESSAGE 1:

ERROR MESSAGE 2:

This error occurs because the length of the name of the data quality project created as a result of running the SSIS package is more than the maximum allowed number of characters (128) in DQS. Whenever, you run an SSIS package containing a DQS Cleansing component, a data quality project is automatically created in DQS with the following naming convention:

<SSIS Package Name>.<DQS Cleansing component name>_DateTimeStamp_{GUID}_GUID.

For example: MyPackage.DQSCleansingExample_6/9/2012 1:43:48 PM_{0E27D092-5153-4F4C-848D-7D78AC3BB672}_cf0aa4f5-3cac-431d-9a71-32e124322e3c

To resolve this issue, shorten the names of your package and the DQS Cleansing component to ensure that the length of the automatically generated data quality project name is less than 128 characters.

Error while running an SSIS package containing a DQS Cleansing component targeting another Data Quality Server

You might receive the following error when running an SSIS package containing DQS Cleansing component:

This error occurs if the SSIS package is run against a Data Quality Server installation, which is different from the one against which the SSIS package was created. The Data Cleansing component in the SSIS package internally stores the "ID" of the knowledge base against which it is mapped instead of storing the "name" of the knowledge base. The Knowledge Base ID for the same knowledge bases is different in diffferent Data Quality Server installations. Hence, the DQS cleansing component is unable to locate the Knowledge Base ID for the same knowledge base on another Data Quality Server installation, and throws this error.

To resolve this issue, before running the SSIS package against the new Data Quality Server installation, edit the package to change the connection string to point to the new Data Quality Server. This changes the Knowledge Base ID in the package accordingly, and you will be able run the package succesfully against the new Data Quality Server installation.

Can't see any knowledge bases in the drop-down list of the DQS Cleansing connection manager in SSIS

While trying to set up a connection to the Data Quality Server on the local computer using the DQS Cleansing component in SSIS, you cannot see any of the knowledge bases in the drop-down list in the DQS Cleansing connection manage.

This occurs if you specified local as the server name in the connection manager. In this case, the knowledge base drop-down list will be empty:

To resolve this issue, specify the local server name as (local):

Error: The attempt to update or delete a DAO object of type 'AKnowledgebase' with id <ID> has failed because the object is not up to date or is being deleted from the database

You might receive this error while running a cleansing operation either from the Data Quality Client or DQS Cleansing component in SSIS.

This primarily occurs if you are running out of space on your computer, and also if you running a version of SQL Server 2012 prior to SP1. You can find detailed information about this issue here.

To resolve this issue, we recommend that you install the SQL Server 2012 SP1 release or later as space optimization for DQS was included in this update to fix the above issue. Also, consider regularly deleting the projects created while running the SSIS package containing the DQS Cleansing component that you do not require anymore to ensure you have enough space.

See Also

• Data Quality Services Features and Tasks
• Troubleshoot Installation and Configuration Issues in Data Quality Services (DQS)
• DQS Resources on TechNet Wiki