Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-2152

Error reporting of Oracle Text Field Size limitations

XMLWordPrintable

    • 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.

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      On Oracle, we have a size limitation for issue Description and Comment fields of 4000 characters.

      So, if you add a description or a comment that is greater than that, you get an error:

      Exception: com.opensymphony.workflow.InternalWorkflowException: An unknown exception occured while executing FunctionProvider: com.atlassian.jira.workflow.function.issue.UpdateIssueFieldFieldFunction
      at com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWorkflow.java:934)
      at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1107)
      at com.opensymphony.workflow.AbstractWorkflow.initialize(AbstractWorkflow.java:366)
      at com.atlassian.jira.issue.IssueUtils.createIssue(IssueUtils.java:80)
      at com.atlassian.jira.issue.IssueUtils.createIssue(IssueUtils.java:65)

      The problem here is that there is no hint as to what caused the error. It would be better to be able to give an error:

      "Your comment is too large. Consider creating an attachment."

      Its practically impossible from the Entity Engine exception, to programmatically work out what happened (even the error message depends on what version of oracle)
      The only other thing to do is to make it part of the Web Action validation - thereby forcing a limit on everyone.

      This would actually be a good thing, because they might otherwise end up hitting this limitation when changing databases (as we did). Especially since HSQLDB in the stand-alone version doesnt have any limit....

        1. Sample.htm
          2 kB
          Fi Ho

              Unassigned Unassigned
              3b1ae0ec93c9 Nick Minutello
              Votes:
              11 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: