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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.