Error: the maximum system-generated unique value for a duplicate group was exceeded ..." - when running ETL refresh during Conversion Validation

ETL runs for 4.5 hours and then fails with the following messages during Conversion Validatoin:

Error: 2014-08-19 14:46:43.36

   Code: 0xC002F210

   Source: Participated in previous event Execute SQL Task

   Description: Executing the query "update T set

T.[ISPREVIOUSEVENTTEAM] = case when ..." failed with the following error: "The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID 424725525233664. Dropping and re-creating the index may resolve this; otherwise, use another clustering key.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

End Error

Warning: 2014-08-19 14:46:43.36

   Code: 0x80019002

   Source: Update or insert into main table

   Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

End Warning

Warning: 2014-08-19 14:46:43.36

   Code: 0x80019002

   Source: BBDW_DIM_FUNDRAISERTEAM

   Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

End Warning

Warning: 2014-08-19 14:46:43.46

   Code: 0x80019002

   Source: Sub-Package Processing

   Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

End Warning

DTExec: The package execution returned DTSER_FAILURE (1).

Started:  10:13:30 AM

Finished: 2:46:43 PM

Elapsed:  16393.3 seconds

Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 3.0.516 Patch 41
 3.0.516, Service Pack 9

Was this article helpful?