com.atlassian.jira.exception.DataAccessException: Error occurred while storing issue.

Atlassian JIRA | Bogdan Dziedzic [Atlassian] | 9 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    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). {noformat} 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) {noformat}

    Atlassian JIRA | 9 years ago | Bogdan Dziedzic [Atlassian]
    com.atlassian.jira.exception.DataAccessException: Error occurred while storing issue.
  2. 0

    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). {noformat} 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) {noformat}

    Atlassian JIRA | 9 years ago | Bogdan Dziedzic [Atlassian]
    com.atlassian.jira.exception.DataAccessException: Error occurred while storing issue.

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      Error occurred while storing issue.

      at com.atlassian.jira.issue.IssueImpl.store()
    2. com.atlassian.jira
      IssueCreateFunction.execute
      1. com.atlassian.jira.issue.IssueImpl.store(IssueImpl.java:944)
      2. com.atlassian.jira.workflow.function.issue.IssueCreateFunction.execute(IssueCreateFunction.java:72)
      2 frames
    3. com.opensymphony.workflow
      AbstractWorkflow.initialize
      1. com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWorkflow.java:869)
      2. com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1265)
      3. com.opensymphony.workflow.AbstractWorkflow.initialize(AbstractWorkflow.java:618)
      3 frames