The statement has been terminated. (logging error) <== String or binary data would be truncated.

[lesley-w]

We are getting occasional errors when sending emails.

The error is "The statement has been terminated. (logging error) <== String or binary data would be truncated." and occurs at PerplexMail.Email.SendEmail():586

As far as I can tell, the emails are still being sent, however, the details are not being logged.

Looking at the perplexMailLog table, I noticed that the to/from/replyTo/cc/bcc fields are limited to 255 characters. Is it possible for the Security.Encrypt function to return more than 255 characters?

[PerplexWouter]

Hi @lesley-w ,

The encrypt method has no limit on the input or output. The error you are seeing should be purely a database matter: I suggest simply setting all nvarchar columns to MAX. Can you let me know if that solves the problem?