-
Type:
Bug
-
Status: Done
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: 07.02.00.00 SR2
-
Fix Version/s: 07.02.02.00
-
Component/s: Debtor Statements, Email Maintenance
-
Labels:
When emailing from Jiwa (eg. emailing debtor statements) the following error may occur:
'String or binary would be truncated ...'
The error refers to the SourceDisplayNo column in the table EM_Main being too short. This is the Debtor Account No - Debtor Name when emailing debtor statements.
The emails are actually sent via email provider, it's just the save to Email Maintenance that is the problem
Workaround:
Run this script against the database to expand the field:
ALTER TABLE EM_Main ALTER COLUMN SourceDisplayNo VARCHAR(500) NULL