Unable to attach Excel file with long Russian filename via email

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: High
    • Component/s: Email - Incoming
    • None
    • Severity 3 - Minor

      Summary

      When sending an email that contains an Excel file with a Russian file name to JSD, the attachment fails to be processed and below message is attached to the Description of the issue instead:

      An error occured while attaching Заявка на организацию командировки по России(гостиница)Жадушкин 1.xlsx: Unable to record temporary attachment in your session. Please reload the page and try again.

      In log(this can be seen on splunk at rate ~29 events/7 days):

      2017-07-07 19:35:55.662650500 2017-07-07 19:35:55,662 Caesium-1-4 WARN asnida.hassan1 [c.a.j.web.util.DefaultWebAttachmentManager] Got exception while adding temporary attachment to attachment monitor. Exception: Caught PSQLException for insert into "public"."tempattachmentsmonitor" ("temporary_attachment_id", "content_type", "file_name", "form_token", "created_time", "file_size")
      2017-07-07 19:35:55.662651500 values (?, ?, ?, ?, ?, ?) caused by: ERROR: value too long for type character varying(255)

      h2. Steps to reproduce 

      1. Enable email request in JSD project
      2. Send an email with Заявка на организацию командировки по России(гостиница)Жадушкин 1.xlsx as attachment to the email request 

      h2. Expected Result

      The email is processed and created as a ticket with the attachment

      h2. Actual Result

      The email is processed and created as a ticket without the attachment

            Assignee:
            Unassigned
            Reporter:
            Nur Asnida Hassan (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: