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

Issue ID is not reused, if JIRA fails to create an issue from an email message.

    XMLWordPrintable

Details

    Description

      In a situation where JIRA fails to create a new issue from an email processed by the mail handler, the issue ID is not reused.

      So for e.g. if your currently available issue ID is TST-10 and JIRA for whatever reason fails to process an email that should use this issue ID, JIRA will try to assign to the next new issue issue ID TST-11.
      The issue ID TST-10 is lost and not reused by the system, which in a busy JIRA installation can generate a thousand issue ID gap .

      On the top of missing issues ID, the following error in the log file helps to identify this issue.

      BTW. This error can be addressed by configuring the system with consistent character encoding (JVM, JDBC and DB). 

      Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue][summary,Zoom: Text][status,1][votes,0][assignee,admin][security,null][type,1][timespent,null][id,21769][reporter,test][project,10022][environment,null][created,2008-06-03 14:49:36.912][updated,2008-06-03 14:49:36.912][priority,3][description,Zoom: Text:
sr02 ? sr03 ? sr04 ? sr05 ? sr06 ? sr07 ? sr08 ? sr09 ? sr10 ? sr11
test test test
][workflowId,21889][timeestimate,null][duedate,null][timeoriginalestimate,null][key,TEST-11512] (SQL Exception while executing the following:INSERT INTO public.jiraissue (ID, pkey, PROJECT, REPORTER, ASSIGNEE, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, VOTES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: character 0xc297 of encoding "UTF8" has no equivalent in "WIN1252"))
	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.issue.IssueImpl.store(IssueImpl.java:927)
	... 20 more
2008-06-03 14:49:36,943 JiraQuartzScheduler_Worker-0 ERROR [service.util.handler.CreateIssueHandler] Could not create issue!
com.atlassian.jira.exception.DataAccessException: Error occurred while storing issue.
	at com.atlassian.jira.issue.IssueImpl.store(IssueImpl.java:944)
	at com.atlassian.jira.workflow.function.issue.IssueCreateFunction.execute(IssueCreateFunction.java:72)
	at com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWorkflow.java:869)
	at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1265)
	at com.opensymphony.workflow.AbstractWorkflow.initialize(AbstractWorkflow.java:618)

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-66153 JIRA increments pcounter when UTF encoding errors occurs

          • Low - Low priority issues
          • Closed

          Activity

            People

              Unassigned Unassigned
              bdziedzic Bogdan Dziedzic [Atlassian]
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: