Add-on Collective lssue view for service desk - giving transition from one status to another status

Pat September 26, 2019

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?

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events