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 ...'
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
SQL skills required
A working knowledge of SQL Management Studio is required to complete this task
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