I did a migration from jira 7.35 to jira 7.35
MySQL 5.62(Mira-db) to Postgres 9.5
Java version 1.8.0_201
I was able to get all of the data to the new instance. I receive this error :
Error occurred while storing issue.It seems that you have tried to perform an illegal workflow operation.If you think this message is wrong, please contact your JIRA administrators.
In the logs:
<plugin>
<key>net.seibertmedia.jira.plugins.collective-issue-view</key>
<name>Collective Issue View</name>
<version>2.0.3</version>
<vendor>//SEIBERT/MEDIA GmbH</vendor> <status>ENABLED</status>
<vendor-url>http://www.seibert-media.net</vendor-url> <framework-version>2</framework-version>
<user-installed>true</user-installed>
<bundled>User installed</bundled>
</plugin>I have uninstall the add-on and re-indexed but still getting this error.
I can create new tickets but I can't transition those tickets either.
Full error in the log:
2019-09-25 10:25:31,558 http-nio-8080-exec-24 url:/secure/CommentAssignIssue.jspa username:ca.admin2 ERROR ca.admin2 625x60289x1 1nnpuh0 10.23.20.72 /secure/CommentAssignIssue.jspa [c.a.jira.workflow.OSWorkflowManager] Caught exception while attempting to perform action 761 from workflow 639226 on issue 'HD-51145'
com.atlassian.jira.exception.DataAccessException: Error occurred while storing issue.
at com.atlassian.jira.issue.IssueImpl.store(IssueImpl.java:1163)
at com.atlassian.jira.workflow.OSWorkflowManager.doWorkflowActionInsideTxn(OSWorkflowManager.java:833)
at com.atlassian.jira.workflow.OSWorkflowManager.doWorkflowAction(OSWorkflowManager.java:786)
at com.atlassian.jira.bc.issue.DefaultIssueService.transition(DefaultIssueService.java:492)
at com.atlassian.jira.web.action.issue.CommentAssignIssue.doExecute(CommentAssignIssue.java:162)
... 1 filtered
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
... 7 filtered
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
... 19 filtered
at net.seibertmedia.jira.plugins.servletfilter.JsLoggingServletFilter.doFilter(JsLoggingServletFilter.java:37)
... 36 filtered
at com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)
at com.atlassian.ams.shipit.servlet.filter.AbstractThreadFilter.runWithChangedThreadName(AbstractThreadFilter.java:69)
at com.atlassian.ams.shipit.servlet.filter.AbstractThreadFilter.doFilter(AbstractThreadFilter.java:53)
at com.atlassian.ams.shipit.servlet.filter.AbstractThreadFilter.doFilter(AbstractThreadFilter.java:37)
... 3 filtered
at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
... 29 filtered
at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
... 28 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Issue][timespent,null][timeoriginalestimate,null][project,12100][description,*Barjinder,*
Today, Evercom experienced very slow PULS.
Thanks.
{color:black}{color}
!image001.png|thumbnail!{color:black}{color}
{color:black} {color}
*{color:#00B0F0} *Donald Chia*{color}*
{color:black}Supplier Quality Engineering Manager{color}
{color:black} {color}
{color:black}1401 North Rice Ave{color}
{color:black}Oxnard, CA 93030 USA{color}
*{color:#00B0F0} *M*{color}*{color:#1F497D} {color} {color:black}+86 135 8085 2561 (China){color}
{color:#00B0F0} +{color}[{color:#00B0F0}{color}{color:#00B0F0} + dchia@calamp.com+{color}{color:#00B0F0} {color}|mailto:dchia@calamp.com]{color:#00B0F0} {color}+{color:#00B0F0}{color} {color:black}/{color}{color:#00B0F0} +calamp.com+{color}
][type,10300][resolution,8][number,51145][security,null][resolutiondate,2019-09-25 10:25:30.745][fixfor,null][id,533326][key,null][summary,PULS Very Slow....][watches,1][creator,dchia@calamp.com][created,2019-08-28 01:24:58.0][reporter,dchia@calamp.com][priority,14][environment,null][component,null][timeestimate,null][duedate,null][votes,0][assignee,ca.admin2][updated,2019-09-25 10:25:30.784][workflowId,639226][status,6] (SQL Exception while executing the following:UPDATE public.jiraissue SET pkey=?, issuenum=?, PROJECT=?, REPORTER=?, ASSIGNEE=?, CREATOR=?, issuetype=?, SUMMARY=?, DESCRIPTION=?, ENVIRONMENT=?, PRIORITY=?, RESOLUTION=?, issuestatus=?, CREATED=?, UPDATED=?, DUEDATE=?, RESOLUTIONDATE=?, VOTES=?, WATCHES=?, TIMEORIGINALESTIMATE=?, TIMEESTIMATE=?, TIMESPENT=?, WORKFLOW_ID=?, SECURITY=?, FIXFOR=?, COMPONENT=? WHERE ID=? (ERROR: current transaction is aborted, commands ignored until end of transaction block))
at org.ofbiz.core.entity.GenericDAO.singleUpdate(GenericDAO.java:369)
at org.ofbiz.core.entity.GenericDAO.customUpdate(GenericDAO.java:291)
at org.ofbiz.core.entity.GenericDAO.update(GenericDAO.java:270)
at org.ofbiz.core.entity.GenericDAO.update(GenericDAO.java:239)
at org.ofbiz.core.entity.GenericHelperDAO.store(GenericHelperDAO.java:232)
at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1734)
at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1715)
at org.ofbiz.core.entity.GenericValue.store(GenericValue.java:101)
at com.atlassian.jira.issue.IssueImpl.store(IssueImpl.java:1160)
... 291 more
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE public.jiraissue SET pkey=?, issuenum=?, PROJECT=?, REPORTER=?, ASSIGNEE=?, CREATOR=?, issuetype=?, SUMMARY=?, DESCRIPTION=?, ENVIRONMENT=?, PRIORITY=?, RESOLUTION=?, issuestatus=?, CREATED=?, UPDATED=?, DUEDATE=?, RESOLUTIONDATE=?, VOTES=?, WATCHES=?, TIMEORIGINALESTIMATE=?, TIMEESTIMATE=?, TIMESPENT=?, WORKFLOW_ID=?, SECURITY=?, FIXFOR=?, COMPONENT=? WHERE ID=? (ERROR: current transaction is aborted, commands ignored until end of transaction block)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:683)
at org.ofbiz.core.entity.GenericDAO.singleUpdate(GenericDAO.java:363)
... 299 more
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:332)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:673Anyone else have issue with this add-on?
