Emailing may report an error 'String or binary ...' in some cases

Problem

When emailing from Jiwa (e.g. emailing debtor statements) the following error may occur:

'String or binary would be truncated ...'

Open

The error refers to the EmailDebtorFromAddress.  But the issue is actually with the EmailTo address in EM_Main.

We also made a change in 7.02.00 SR2 to add SourceDisplayNo in Email Maintenance results in this error.  The SourceDisplayNo is a combination of debtor account number and debtor account name so the error will occur on long customer names.

Solution

The emails are actually sent via email provider.  It's the save to Email Maintenance that is the problem

Workaround:

Run these scripts against the database to expand the field:

ALTER TABLE EM_Main ALTER COLUMN EmailTo VARCHAR(2000) NULL

ALTER TABLE EM_Main ALTER COLUMN SourceDisplayNo VARCHAR(255) NULL

Related articles