com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))

Atlassian JIRA | Ben Sewell | 3 years ago
  1. 0

    h3. Steps to reproduce # Start with JIRA < 6.2-OD-3/icebat-85.0. # Create a custom issue status, which is created with an ID of 10000. # Upgrade to JIRA 6.2-OD-3/icebat-85.0. # Try to create another issue status, and you'll receive a stack trace: {code} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus")) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:395) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) at com.atlassian.jira.config.AbstractIssueConstantsManager.createConstant(AbstractIssueConstantsManager.java:38) at com.atlassian.jira.config.DefaultStatusManager.createStatus(DefaultStatusManager.java:73) at com.atlassian.jira.bc.config.DefaultStatusService.createStatus(DefaultStatusService.java:75) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.addConstant(ViewStatuses.java:196) at com.atlassian.jira.web.action.admin.constants.AbstractViewConstants.doAddConstant(AbstractViewConstants.java:42) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.doAddStatus(ViewStatuses.java:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70) [...] {code} Try to create it a second time and it'll work fine, as the new status is then created with an ID of 10001. The more custom issue statuses already exist in an instance, the more times you have to click Add in order to get past the latest ID. h3. Workaround If on OnDemand contact support, support will: # Shutdown JIRA # Backup the database # Identify the current maximum value of the issuestatus id {noformat} select id::integer from issuestatus order by id desc limit 1; {noformat} # Update the sequence_value_item table to define the Status sequence ID as 1 higher than the value identified in the previous step {noformat} update sequence_value_item set seq_id = <value from above + 1> where seq_name = 'Status'; {noformat} # Start JIRA back up.

    Atlassian JIRA | 3 years ago | Ben Sewell
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))
  2. 0

    h3. Steps to reproduce # Start with JIRA < 6.2-OD-3/icebat-85.0. # Create a custom issue status, which is created with an ID of 10000. # Upgrade to JIRA 6.2-OD-3/icebat-85.0. # Try to create another issue status, and you'll receive a stack trace: {code} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus")) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:395) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) at com.atlassian.jira.config.AbstractIssueConstantsManager.createConstant(AbstractIssueConstantsManager.java:38) at com.atlassian.jira.config.DefaultStatusManager.createStatus(DefaultStatusManager.java:73) at com.atlassian.jira.bc.config.DefaultStatusService.createStatus(DefaultStatusService.java:75) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.addConstant(ViewStatuses.java:196) at com.atlassian.jira.web.action.admin.constants.AbstractViewConstants.doAddConstant(AbstractViewConstants.java:42) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.doAddStatus(ViewStatuses.java:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70) [...] {code} Try to create it a second time and it'll work fine, as the new status is then created with an ID of 10001. The more custom issue statuses already exist in an instance, the more times you have to click Add in order to get past the latest ID. h3. Workaround If on OnDemand contact support, support will: # Shutdown JIRA # Backup the database # Identify the current maximum value of the issuestatus id {noformat} select id::integer from issuestatus order by id desc limit 1; {noformat} # Update the sequence_value_item table to define the Status sequence ID as 1 higher than the value identified in the previous step {noformat} update sequence_value_item set seq_id = <value from above + 1> where seq_name = 'Status'; {noformat} # Start JIRA back up.

    Atlassian JIRA | 3 years ago | Nick Mason
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))
  3. 0

    h3. Steps to reproduce # Start with JIRA < 6.2-OD-3/icebat-85.0. # Create a custom issue status, which is created with an ID of 10000. # Upgrade to JIRA 6.2-OD-3/icebat-85.0. # Try to create another issue status, and you'll receive a stack trace: {code} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus")) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:395) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) at com.atlassian.jira.config.AbstractIssueConstantsManager.createConstant(AbstractIssueConstantsManager.java:38) at com.atlassian.jira.config.DefaultStatusManager.createStatus(DefaultStatusManager.java:73) at com.atlassian.jira.bc.config.DefaultStatusService.createStatus(DefaultStatusService.java:75) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.addConstant(ViewStatuses.java:196) at com.atlassian.jira.web.action.admin.constants.AbstractViewConstants.doAddConstant(AbstractViewConstants.java:42) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.doAddStatus(ViewStatuses.java:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70) [...] {code} Try to create it a second time and it'll work fine, as the new status is then created with an ID of 10001. The more custom issue statuses already exist in an instance, the more times you have to click Add in order to get past the latest ID. h3. Workaround If on OnDemand contact support, support will: # Shutdown JIRA # Backup the database # Identify the current maximum value of the issuestatus id {noformat} select id::integer from issuestatus order by id desc limit 1; {noformat} # Update the sequence_value_item table to define the Status sequence ID as 1 higher than the value identified in the previous step {noformat} update sequence_value_item set seq_id = <value from above + 1> where seq_name = 'Status'; {noformat} # Start JIRA back up.

    Atlassian JIRA | 3 years ago | Nick Mason [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    h3. Steps to reproduce # Start with JIRA < 6.2-OD-3/icebat-85.0. # Create a custom issue status, which is created with an ID of 10000. # Upgrade to JIRA 6.2-OD-3/icebat-85.0. # Try to create another issue status, and you'll receive a stack trace: {code} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus")) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:395) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) at com.atlassian.jira.config.AbstractIssueConstantsManager.createConstant(AbstractIssueConstantsManager.java:38) at com.atlassian.jira.config.DefaultStatusManager.createStatus(DefaultStatusManager.java:73) at com.atlassian.jira.bc.config.DefaultStatusService.createStatus(DefaultStatusService.java:75) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.addConstant(ViewStatuses.java:196) at com.atlassian.jira.web.action.admin.constants.AbstractViewConstants.doAddConstant(AbstractViewConstants.java:42) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.doAddStatus(ViewStatuses.java:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70) [...] {code} Try to create it a second time and it'll work fine, as the new status is then created with an ID of 10001. The more custom issue statuses already exist in an instance, the more times you have to click Add in order to get past the latest ID. h3. Workaround If on OnDemand contact support, support will: # Shutdown JIRA # Backup the database # Identify the current maximum value of the issuestatus id {noformat} select id::integer from issuestatus order by id desc limit 1; {noformat} # Update the sequence_value_item table to define the Status sequence ID as 1 higher than the value identified in the previous step {noformat} update sequence_value_item set seq_id = <value from above + 1> where seq_name = 'Status'; {noformat} # Start JIRA back up.

    Atlassian JIRA | 3 years ago | Ben Sewell
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))
  6. 0

    When trying to import the attached 6.4 backup with 5000 users which data created from multiple data generator runs, this error was encountered. {noformat} [c.a.s.core.upgrade.PluginUpgrader] Upgraded plugin com.pyxis.greenhopper.jira to version 48 - Add reindex required message for Epic Label field searching @4000000055cc3e8d2cc59dd4 2015-08-13 16:51:47,751 localhost-startStop-1 INFO [c.a.s.core.upgrade.PluginUpgrader] Plugin com.pyxis.greenhopper.jira upgrade completed. Current version is: 48 @4000000055cc3e8d2d0ff8fc 2015-08-13 16:51:47,755 localhost-startStop-1 INFO [c.a.s.core.upgrade.PluginUpgrader] Upgrading plugin com.atlassian.studio.theme.jira @4000000055cc3e8d2e881a0c 2015-08-13 16:51:47,775 localhost-startStop-1 ERROR [c.a.s.core.upgrade.PluginUpgrader] Upgrade failed: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][sequence,557][name,Building][iconurl,/images/icons/bamboo.png][description,Source code has been committed, and JIRA is waiting for the code to be built before moving to the next status.][id,400] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus")) @4000000055cc3e8d2e883d34 com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][sequence,557][name,Building][iconurl,/images/icons/bamboo.png][description,Source code has been committed, and JIRA is waiting for the code to be built before moving to the next status.][id,400] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus")) @4000000055cc3e8d2e884cd4 at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:398) @4000000055cc3e8d2e8850bc at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) @4000000055cc3e8d2e8850bc at com.atlassian.jira.entity.EntityUtils.createValue(EntityUtils.java:39) @4000000055cc3e8d2e8854a4 at com.atlassian.studio.jira.upgrade.UpgradeTo_v45.createNewStatus(UpgradeTo_v45.java:69) @4000000055cc3e8d2e8854a4 at com.atlassian.studio.jira.upgrade.UpgradeTo_v45.doUpgrade(UpgradeTo_v45.java:47) @4000000055cc3e8d2e885c74 ... 3 filtered @4000000055cc3e8d2e885c74 at java.lang.reflect.Method.invoke(Method.java:497) @4000000055cc3e8d2e885c74 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) @4000000055cc3e8d2e88605c at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) @4000000055cc3e8d2e88605c at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) @4000000055cc3e8d2e8873e4 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) @4000000055cc3e8d2e887bb4 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) @4000000055cc3e8d2e887f9c at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) @4000000055cc3e8d2e888384 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) @4000000055cc3e8d2e88876c at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) @4000000055cc3e8d2e888b54 at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) @4000000055cc3e8d2e888b54 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) @4000000055cc3e8d2e888f3c at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) @4000000055cc3e8d2e889324 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) @4000000055cc3e8d2e889af4 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) @4000000055cc3e8d2e889edc at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) @4000000055cc3e8d2e889edc at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) @4000000055cc3e8d2e88a6ac at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) @4000000055cc3e8d2e88a6ac at com.sun.proxy.$Proxy732.doUpgrade(Unknown Source) @4000000055cc3e8d2e88aa94 at com.atlassian.sal.core.upgrade.PluginUpgrader.doUpgrade(PluginUpgrader.java:85) @4000000055cc3e8d2e88aa94 at com.atlassian.sal.core.upgrade.PluginUpgrader.upgrade(PluginUpgrader.java:66) @4000000055cc3e8d2e88ae7c at com.atlassian.sal.core.upgrade.DefaultPluginUpgradeManager$1.doInTransaction(DefaultPluginUpgradeManager.java:229) @4000000055cc3e8d2e88b264 at com.atlassian.sal.core.upgrade.DefaultPluginUpgradeManager$1.doInTransaction(DefaultPluginUpgradeManager.java:197) @4000000055cc3e8d2e88b264 at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25) @4000000055cc3e8d2e88be1c at com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:38) @4000000055cc3e8d2e88be1c ... 2 filtered {noformat}

    Atlassian JIRA | 1 year ago | Peter Obara [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][sequence,557][name,Building][iconurl,/images/icons/bamboo.png][description,Source code has been committed, and JIRA is waiting for the code to be built before moving to the next status.][id,400] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus")) @4000000055cc3e8d2e884cd4 at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:398) @4000000055cc3e8d2e8850bc at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) @4000000055cc3e8d2e8850bc at com.atlassian.jira.entity.EntityUtils.createValue(EntityUtils.java:39) @4000000055cc3e8d2e8854a4 at com.atlassian.studio.jira.upgrade.UpgradeTo_v45.createNewStatus(UpgradeTo_v45.java:69) @4000000055cc3e8d2e8854a4 at com.atlassian.studio.jira.upgrade.UpgradeTo_v45.doUpgrade(UpgradeTo_v45.java:47) @4000000055cc3e8d2e885c74 ... 3 filtered @4000000055cc3e8d2e885c74 at java.lang.reflect.Method.invoke(Method.java:497) @4000000055cc3e8d2e885c74 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) @4000000055cc3e8d2e88605c at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) @4000000055cc3e8d2e88605c at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) @4000000055cc3e8d2e8873e4 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) @4000000055cc3e8d2e887bb4 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) @4000000055cc3e8d2e887f9c at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) @4000000055cc3e8d2e888384 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) @4000000055cc3e8d2e88876c at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) @4000000055cc3e8d2e888b54 at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) @4000000055cc3e8d2e888b54 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) @4000000055cc3e8d2e888f3c at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) @4000000055cc3e8d2e889324 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) @4000000055cc3e8d2e889af4 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))

      at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue()
    2. com.atlassian.jira
      ViewStatuses.doAddStatus
      1. com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:395)
      2. com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219)
      3. com.atlassian.jira.config.AbstractIssueConstantsManager.createConstant(AbstractIssueConstantsManager.java:38)
      4. com.atlassian.jira.config.DefaultStatusManager.createStatus(DefaultStatusManager.java:73)
      5. com.atlassian.jira.bc.config.DefaultStatusService.createStatus(DefaultStatusService.java:75)
      6. com.atlassian.jira.web.action.admin.statuses.ViewStatuses.addConstant(ViewStatuses.java:196)
      7. com.atlassian.jira.web.action.admin.constants.AbstractViewConstants.doAddConstant(AbstractViewConstants.java:42)
      8. com.atlassian.jira.web.action.admin.statuses.ViewStatuses.doAddStatus(ViewStatuses.java:134)
      8 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    4. webwork.util
      InjectionUtils$DefaultInjectionImpl.invoke
      1. webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70)
      1 frame