Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-37377

Jira log audit fails due to ERROR: value too long for type character varying(255)

    XMLWordPrintable

    Details

      Description

      Jira will throw an ugly set of exceptions if you try to edit a long custom field description.

      Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:AuditLog][id,10009][summary,Custom field updated][category,fields][authorType,1][created,2014-03-06 21:13:36.634][remoteAddress,127.0.0.1][objectName,Bill Balance][objectId,customfield_10048][authorKey,sorin][objectParentName,null][objectParentId,null][searchField,sorin sbârnea 127.0.0.1 custom field updated fields bill balance auto calculated as: bill_amount - (bill_paid + adjustment_amt)
      <!-- @@formula: 222
      -->
      <!-- formula: issue.get("customfield_10015") ( issue.get("customfield_10926") issue.get("customfield_10922") issue.get("customfield_11101") issue.get("customfield_11102") issue.get("customfield_10016") issue.get("customfield_10805") )
      -->][objectType,CUSTOM_FIELD] (SQL Exception while executing the following:INSERT INTO public.audit_log (ID, REMOTE_ADDRESS, CREATED, AUTHOR_KEY, SUMMARY, CATEGORY, OBJECT_TYPE, OBJECT_ID, OBJECT_NAME, OBJECT_PARENT_ID, OBJECT_PARENT_NAME, AUTHOR_TYPE, SEARCH_FIELD) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(255)))
      	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200)
      	at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83)
      	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:526)
      	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:513)
      	at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98)
      	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:390)
      	... 195 more
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                ssbarnea Sorin Sbarnea (Citrix)
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: