Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-19719

description field when creating dashboard does not check for maximum length of 255 chars and can cause System Errors

    XMLWordPrintable

Details

    • Bug
    • Resolution: Timed out
    • Low
    • None
    • 3.13.2
    • Issue - Fields
    • 3.13
    • Severity 3 - Minor
    • Hide
      Atlassian Update – 16 November 2017

      Hi everyone,

      The issue has not collected enough votes, watches, comments or support cases during it's lifetime. In this sense overal interest in the reported problem is low.
      Jira team is focusing on bigger and more impactful issues at the moment and we are not likely to look at the current bug soon. Therefore I'm resolving the issue as Timed Out.

      Atlassian will continue to watch issue for the further updates, so please don't hesitate to share your feedback in the issue comments.

      Cheers,
      Ignat Alexeyenko
      Jira bugmaster.

      Show
      Atlassian Update – 16 November 2017 Hi everyone, The issue has not collected enough votes, watches, comments or support cases during it's lifetime. In this sense overal interest in the reported problem is low. Jira team is focusing on bigger and more impactful issues at the moment and we are not likely to look at the current bug soon. Therefore I'm resolving the issue as Timed Out . Atlassian will continue to watch issue for the further updates, so please don't hesitate to share your feedback in the issue comments. Cheers, Ignat Alexeyenko Jira bugmaster.

    Description

      copied from / also see https://support.atlassian.com/browse/JSP-47192

      When a user goes to "Manage Dashboard" and adds a new dashboard, the form field "description" allows a user to input a lot of text. On save it is not validated how many chars are in that field. If there are more than 255 chars in it, JIRA throws a System Error, because the according database field seems to be text(255).

      INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1))

      the error is:

      "Data too long for column 'DESCRIPTION' at row 1"

      after:

      INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT)...

      The table portalpage looks like this:

      mysql> describe portalpage;
+-------------+---------------+------+-----+---------+-------+
| Field       | Type          | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| ID          | decimal(18,0) | NO   | PRI |         |       |
| USERNAME    | varchar(255)  | YES  |     | NULL    |       |
| PAGENAME    | varchar(255)  | YES  |     | NULL    |       |
| DESCRIPTION | varchar(255)  | YES  |     | NULL    |       |
| SEQUENCE    | decimal(18,0) | YES  |     | NULL    |       |
| FAV_COUNT   | decimal(18,0) | YES  |     | NULL    |       |
+-------------+---------------+------+-----+---------+-------+

      so, "DESCRIPTION" is varchar(255). (max. 255 chars)

      I can confirm inserting 254 chars into the description field does not cause the error, while 256 chars does.

      The problem is just that the formfield does not check if the user inserts more characters.

      We dont even need a workaround, see it just as a bug report, so you can fix it in a future version

      It would be better if either the database field would allow more than 255 chars (if possible), or the form would be validated and tell the user something like "your description text is too long" instead.

      This is more for your information than expecting a work-around right now, i have already informed our user to use only up to 254 chars to avoid this.

      System Error

      A system error has occurred.

      Please try submitting this problem via the Support Request Page

      Otherwise, please create a support issue on our support system at http://support.atlassian.com with the following information:

      1. a description of your problem
      2. cut & paste the error and system information found below
      3. attach the application server log file ( /home/jira/atlassian-jira.log )

      Cause:
      com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1))

      Stack Trace: [hide]

      com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1))
      at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:333)
      at com.atlassian.jira.portal.OfBizPortalPageStore.create(OfBizPortalPageStore.java:199)
      at com.atlassian.jira.portal.CachingPortalPageStore.create(CachingPortalPageStore.java:208)
      at com.atlassian.jira.portal.DefaultPortalPageManager.create(DefaultPortalPageManager.java:195)
      at com.atlassian.jira.bc.portal.AbstractPortalPageService.createPortalPage(AbstractPortalPageService.java:214)
      at com.atlassian.jira.web.action.user.AddPortalPage.createBlankPortalPage(AddPortalPage.java:332)
      at com.atlassian.jira.web.action.user.AddPortalPage.doExecute(AddPortalPage.java:146)
      at webwork.action.ActionSupport.execute(ActionSupport.java:153)
      at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54)
      at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
      at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:178)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
      at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:125)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:75)
      at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:39)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Unknown Source)
      Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1))
      at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123)
      at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
      at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
      at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:480)
      at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:460)
      at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
      at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
      at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:329)
      ... 66 more

      Referer URL: http://jira.ligatus.local/jira/secure/AddPortalPage!default.jspa

      Attachments

        Activity

          People

            Unassigned Unassigned
            cd909f4bab1c Daniel Zahn
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: