Uploaded image for project: 'Development'
  1. Development
  2. DEV-7377

SourceDisplayNo address in EM_Main is too short

    XMLWordPrintable

    Details

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                scottp@jiwa.com.au Scott Pearce
                Reporter:
                julieh@jiwa.com.au Julie Hanlon
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: