Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

This bug was not fixed... the hotfix was denied for SQL Server 2012 RTM
SQL VSTS Hotfix 886436 = DQS/Discovery/Discovery activity counts and considers values that are of wrong data type data

Support Incident Number

Provide the SYMPTOMS/SUMMARY of the issue

When using SQL Server 2012 Data Quality Services, in the Data Quality Client window, as you run the Data Discovery activity, the Profiler tab show statistics about the source records that have been processed by the discovery.

If the data type of the source value does not match the data type of the domain, such as in the case of a .csv or Excel file where individual values may vary, then the Profiler tab may give misleading statistics about the source data.

For example, if you have a set of 4 values detected by the Discovery activity, but one of the values in invalid, the Profiler tab will display statistics that are inconsistent. There are 4 unique values, and 3 of the values are potentially accepted into the domain as New Values, but the invalid value is still counted in the Unique Values, and Valid in Domain Values, which is not possible to include the value into the domain.

Records: 4

Total Values: 4

New Values: 3

Unique Values: 4

New Unique Values: 3

Valid in Domain Values: 4

What CAUSES of the symptoms
A bug in Data Quality Services causes the issue.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!