Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-310

Mail Template size is limited to 255 characters

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Fixed
    • 2.0
    • Core features, Database
    • None
    • Standalone Version, JDK 1.5.0_08, MSSQL 2005 SP2

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      When i try to update the mail template with a slightly longer version i get a java exception:

      00:34:58,164 ERROR 500ErrorPage: Exception caught in 500 page Hibernate operation: could not update: com.atlassian.crowd.model.property.Property#15; uncategorized SQLException for SQL [update [SERVERPROPERTY] set [NAME]=?, [VALUE]=? where [ID]=?]; SQL state [01004]; error code [0]; Data truncation; nested exception is java.sql.DataTruncation: Data truncation
      org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: com.atlassian.crowd.model.property.Property#15; uncategorized SQLException for SQL [update [SERVERPROPERTY] set [NAME]=?, [VALUE]=? where [ID]=?]; SQL state [01004]; error code [0]; Data truncation; nested exception is java.sql.DataTruncation: Data truncation
      java.sql.DataTruncation: Data truncation
      ...

      I looked at the SERVERPROPERTY table, and the column VALUE is set to varchar(255), and my template is longer than 255 chars.
      255 chars is a harsh limit for a e-mail template.

      Could you please increase the varchar size to something more usable?

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CWD-1149 After updating mail template - an ORA-12899 value too large for column is trown

          • Medium - Medium priority issues
          • Closed

          Suggestion - CWD-1635 Mail template message field should be bigger

          • Closed
          is incorporated by

          Suggestion - CWD-1507 Crowd Schema + Domain Model update to improve performance and cross-database compliance

          • Closed

          Activity

            People

              justin@atlassian.com Justin Koke
              c5e1f1874f20 Toni Birrer
              Votes:
              12 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: