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:673
Anyone else have issue with this add-on?