Error: General ODBC Error: [Microsoft][ODBC SQL Driver][SQL Server] Target string size is too small to represent the XML instance Native error:6354 -when running Duplicate Constituent Management Tool

Users may encounter the following error when running the Duplicate Constituent Management Tool in version 7.93 of The Raiser's Edge (the Duplicate Constituent process is currently in use). The report may run without error for Organizations, but when run for Individuals, the error appears.

General ODBC Error: [Microsoft][ODBC SQL Driver][SQL Server] Target string size is too small to represent the XML instance Native error:6354

This error can be caused by constituent records that have a very high number of phone numbers or email addresses. This occurs because each number is compared on constituent record, so when constituents have 50+ phone numbers or emails, it can cause the tool to fail with this error. If any constituents have more than 50 phones or emails, remove any duplicate or unneeded phones/emails. 

If the error still occurs, Contact Support and reference this article so we can assist you with your database.

Environment

 Raiser's Edge
 7.94
 7.93.5782, patch 7

Was this article helpful?