Uploaded image for project: 'Jira Data Center'
  1. Jira 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

              Unassigned Unassigned
              73f0b2e75f82 Sorin Sbarnea (Citrix)
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: