Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-2235

Error initializing workflow in Service Desk request due to exceeding character limit

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Low
    • None
    • None
    • Customer Portal
    • None

    Description

      NOTE: This bug report is for JIRA Service Desk Server. Using JIRA Service Desk Cloud? See the corresponding bug report.

      Summary

      When entering data into a single line text field in a Service Desk request, and this data exceeds the limit, you receive a message There was an error initialising the workflow

      Environment

      • JIRA 7.0.0
      • Service Desk 2.6.0

      Steps to Reproduce

      1. Create a custom text field (single line)
      2. Add this field on the Create Issue screen for a JIRA Project that is associated with a Service Desk.
      3. Update the Service Desk customer portal to request this field.
      4. Create a request on that Service Desk, while pasting the following paragraph into the custom field:

        Integer sagittis nisi vel rhoncus molestie. Aenean vehicula, ipsum id hendrerit sollicitudin, leo risus porttitor odio, eget ullamcorper dui tellus et magna. Mauris vitae justo ac neque pellentesque ultricies non sed libero. Maecenas sit amet neque ac arcu tristique elementum. Integer diam sapien, vestibulum eget accumsan nec, ultricies sit amet nisl. Vivamus et nisi nec risus laoreet suscipit at et erat. Ut a nisl a nibh imperdiet molestie vulputate id libero. Ut tincidunt sagittis ultricies. Praesent sit amet magna sagittis, volutpat magna ut, convallis orci. Mauris quam quam, gravida id quam non, accumsan finibus risus. Aenean diam neque, varius a neque non, auctor congue dui. Maecenas placerat lectus velit, in tincidunt nunc rutrum eu. Curabitur mollis ipsum ac nisi convallis vestibulum. Maecenas porta ex non enim dignissim, eget ultricies arcu finibus. Etiam commodo, turpis nec scelerisque volutpat, dolor magna aliquam nisl, non elementum mauris purus sit amet urna. Vivamus vel odio sed mauris vestibulum tincidunt rhoncus ut tortuur.

      5. Submit.

      Expected Results

      Error should say that it exceeds the character limit.

      Actual Results

      Error displays at top of Service Desk request:

      In logs: 

      @4000000055d448b90638a4cc 2015-08-19 12:13:19,084 ajp-nio-127.0.0.104-8009-exec-1 ERROR ####### 733x26422x1 wid9cd 109.186.171.142,104.192.140.178 /servicedesk/customer/portal/2/create/5 [c.a.s.i.f.customer.request.ServiceDeskWorkflowInitializationManager] Error initializing workflow
@4000000055d448b90638b084 com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][parentkey,null][customfield,10033][issue,10307][stringvalue,Since the introduction of AutoCAD in 1982, Autodesk has become a leader in 3D design, engineering, and entertainment software. Today, Autodesk’s product portfolio spans more than 100 products, available in 18 different languages.  The company employs over 2,000 software engineers, plus product and project managers who rely on JIRA to plan, collaborate, and ship great products.][id,10518] (SQL Exception while executing the following:INSERT INTO public.customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(255)))
@4000000055d448b90638eb1c 	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:398)
@4000000055d448b90638eb1c 	at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219)
@4000000055d448b90638ef04 	at com.atlassian.jira.issue.customfields.persistence.OfBizCustomFieldValuePersister.createValuesInt(OfBizCustomFieldValuePersister.java:128)
@4000000055d448b90638ef04 	at com.atlassian.jira.issue.customfields.persistence.OfBizCustomFieldValuePersister.updateValues(OfBizCustomFieldValuePersister.java:148)
...
@4000000055d448b9063af2a4 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
@4000000055d448b9063af2a4 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
@4000000055d448b9063af68c 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
@4000000055d448b9063afa74 	at java.lang.Thread.run(Thread.java:745)
@4000000055d448b9063afa74 Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][parentkey,null][customfield,10033][issue,10307][stringvalue,Since the introduction of AutoCAD in 1982, Autodesk has become a leader in 3D design, engineering, and entertainment software. Today, Autodesk’s product portfolio spans more than 100 products, available in 18 different languages.  The company employs over 2,000 software engineers, plus product and project managers who rely on JIRA to plan, collaborate, and ship great products.][id,10518] (SQL Exception while executing the following:INSERT INTO public.customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(255)))
@4000000055d448b9063b0dfc 	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:213)
@4000000055d448b9063b11e4 	at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:178)
...
@4000000055d448b9063b15cc 	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:393)
@4000000055d448b9063b1d9c 	... 388 more
@4000000055d448b9063b1d9c Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(255))
@4000000055d448b9063b2954 	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:684)
@4000000055d448b9063b2954 	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:205)
@4000000055d448b9063b2d3c 	... 394 more
@4000000055d448b9063b3124 Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
@4000000055d448b9063b3124 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2077)
...
@4000000055d448b9063b4894 	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
@4000000055d448b9063b5064 	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:674)
@4000000055d448b9063b544c 	... 395 more

      Workaround

      Reduce the length of the data in the custom text fields.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-42470 Updating a Text Field (single line) custom field with more than 255 characters looses contents

          • High - High priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JSDCLOUD-2235 Error initializing workflow in Service Desk request due to exceeding character limit

          • Low - Low priority issues
          • Closed
          was cloned as

          DESK-4308 Loading...

          Activity

            People

              Unassigned Unassigned
              smackie@atlassian.com Shannon S
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync