I am having an issue with constituent merges. When I run AP_MERGE_CUSTOMER2, the Duplicate Merge Report is showing the following error for all attempted merges --
Merge (Kept Constituent 269595, Delete Constituent 1172649) failed : Error 8152, Severity 16, State 2, Procedure LTX_CUST_ENT_TU, Line 6, String or binary data would be truncated.
Any advice?
LTX_CUST_ENT_TU looks like a trigger on a local table (probably named LTX_CUST_ENT), which must be getting called from LP_CONST_MERGE. That indicates the problem is with some database customizations your organization has done on your end. Your DBA should be able to figure it out!
Thanks, Nick! Let's say hypothetically that the person who would have figured that out has left the organization... Any tips for how I would troubleshoot?
Well, I listed the database objects that I would go looking for in my other post. So you'd need to crack open SSMS and start looking through the code of your local procedures and table triggers.
Feel free to send me a private message if you're brand new at that and want some guiding resources (https://tessituracoders.bitbucket.io).