Hi all. After a year or so without it, we regained the ability to once again upload documents in the Research tab of constituent records with the latest update, in February of this year. Our interns successfully uploaded dozens of documents to constituent records at that time. Now, when I am attempting to do the same thing, I receive an error message about half of the time:
“String or binary data would be truncated. The statement has been terminated”
This happens without discernible rhyme or reason - I thought it had to do with special characters in the name of the document, or the type (pdf vs doc vs .msg), but there's no clear rule for when it will reject a document. It may block uploads to entire constituents for some reason, but I don't know why it should - we successfully uploaded documents in this new tab for constituents for which the action is failing now.
Has anybody else encountered this? Thanks for your help!
I've seen this error when the name of the document is too long (can't remember offhand how many characters it will allow).
I had just figured this out and came here to say so. :) Yep, it's that the description I was writing is too long. With short Descriptions and detailed notes, I'm meeting with no trouble.
Thank you anyway! :)
Hi there! I'm glad you got this working again. I just wanted to note that we have this issue on our defect list, which means it's reported to the developers so they can look at fixing it. Thanks!