Error: The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row." when runnin an ETL Refresh""

When running an ETL Refresh, a user may receive the below error:

2014-01-15 18:16:45.74
Code: 0xC002F210
Source: Maintain Constituent Primary Address Execute SQL Task
Description: Executing the query "merge BBDW.[DIM_CONSTITUENT] as t
using BBDW.[v_FA..." failed with the following error: "The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
End Error
This issue was caused by a data conversion problem.  If you are experiencing a similar issue, review  How to identify data conversion issues in Blackbaud CRM for more information. 

Environment

 3.0.1524.13

Was this article helpful?