We are running the most recent version of SQL 2012 DQS (2011.110.3339.0) and I am running into errors. Unfortunately the errors are not being reported back to the SSIS package so the errors are not resulting in a failure.Background:DQS creates a set of tables for each knowledge base and each project (execution instance). Here is a knowledge base table for CACH. (format = <Database>.<TableName>.<Table>)DQS_MAIN.KnowledgeBase1000001.V_B_DOMAINSHere is a project (execution instance) table for CACH. (format = <Database>.<TableName>.<Table>)DQS_Projects.DQProject1000089.X_DOMAIN_CORRECTION_PROFILINGAfter waiting several hours for a 100K set of rows to load, I checked the DQServer.DQS_MAIN.log file to find that there was a unique key violation happening in two of the project tables involved in the current execution. The SSIS package never failed.2/27/2013 5:03:03 PM|[]|12|ERROR|PUID|Microsoft.Ssdqs.Cleansing.Correction.Service.ProfilingCorrectionNotifications|Failed committing correction profiling data for domain id 1057 in inverted range 1281916-1294447: Violation of UNIQUE KEY constraint 'UNQ_X_RECORD_CORRECTION_PROFILING_RECORD'. Cannot insert duplicate key in object 'DQProject1000089.X_RECORD_CORRECTION_PROFILING'. The duplicate key value is (1024633, 1058).;Violation of UNIQUE KEY constraint 'UNQ_X_DOMAIN_CORRECTION_PROFILING'. Cannot insert duplicate key in object 'DQProject1000089.X_DOMAIN_CORRECTION_PROFILING'. The duplicate key value is (1058, 1294447).;The statement has been terminated.;The statement has been terminated.System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UNQ_X_RECORD_CORRECTION_PROFILING_RECORD'. Cannot insert duplicate key in object 'DQProject1000089.X_RECORD_CORRECTION_PROFILING'. The duplicate key value is (1024633, 1058).;Violation of UNIQUE KEY constraint 'UNQ_X_DOMAIN_CORRECTION_PROFILING'. Cannot insert duplicate key in object 'DQProject1000089.X_DOMAIN_CORRECTION_PROFILING'. The duplicate key value is (1058, 1294447).;The statement has been terminated.;The statement has been terminated.;The domain associated with this error is “ExistingCOBCode”. The rules being applied to this column are:Length is equal to 1Value is numericValue is in 1,2,3,0 99, 104 records were successfully processed before this error appeared. I cannot imagine what I am doing to cause this error. I believe that this is a bug with DQS.
Product Language
Version
Category
Operating System
Operating System Language
Steps to Reproduce
Actual Results
Expected Results
Platform
Virtualization
Please wait...