Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot delete issues after script creation

Deleted user March 20, 2019

Hey guys,

 

I have a workflow Transition to create subtasks via script runner. The action is on the third position (before "update change history").

The script works fine, I can do everything I need with the subtasks, except from deleting.

That's my script:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.customfields.manager.OptionsManager
import com.atlassian.jira.issue.comments.CommentManager
import com.atlassian.jira.ComponentManager
import com.atlassian.jira.workflow.WorkflowTransitionUtil;
import com.atlassian.jira.workflow.WorkflowTransitionUtilImpl;
import com.atlassian.jira.util.JiraUtils;

def constantManager = ComponentAccessor.getConstantsManager()
def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()
def issueFactory = ComponentAccessor.getIssueFactory()
def subTaskManager = ComponentAccessor.getSubTaskManager()
def issueManager = ComponentAccessor.getIssueManager()
CommentManager commentManager = (CommentManager) ComponentManager.getComponentInstanceOfType(CommentManager.class);
WorkflowTransitionUtil workflowTransitionUtil = ( WorkflowTransitionUtil ) JiraUtils.loadComponent( WorkflowTransitionUtilImpl.class );

Issue parentIssue = issue
String issueSummary = issue.summary
String parentStatus = parentIssue.getStatus()
if (parentIssue.getIssueType().getName() == 'Sub-task')
 return

def summariesList = ["DE "+issueSummary,
                     "FR "+issueSummary,
                     "ES "+issueSummary,
                     "UK "+issueSummary,
                     "DIV "+issueSummary]

summariesList.each {
 MutableIssue newSubTask = issueFactory.getIssue()
 newSubTask.setAssigneeId(parentIssue.assigneeId)
 newSubTask.setSummary(it)
 newSubTask.setParentObject(parentIssue)
 newSubTask.setProjectObject(parentIssue.getProjectObject())
 newSubTask.setIssueTypeId(constantManager.getAllIssueTypeObjects().find{it.getName() == "Sub-task"}.id)

 def newIssueParams = ["issue" : newSubTask] as Map<String,Object>
 
 issueManager.createIssueObject(user, newIssueParams)
 subTaskManager.createSubTaskIssueLink(parentIssue, newSubTask, user)

 log.info "Issue with summary ${newSubTask.summary} created"
 commentManager.create(newSubTask, user, "Moved to implemented status as a result of the master merge action being applied to the parent.", true);
  
}

 

The error is:

Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CG.ID, CG.issueid, CG.AUTHOR, CG.CREATED, CI.ID, CI.groupid, CI.FIELDTYPE, CI.FIELD, CI.OLDVALUE, CI.OLDSTRING, CI.NEWVALUE, CI.NEWSTRING FROM public.changegroup CG INNER JOIN public.changeitem CI ON CG.ID = CI.groupid WHERE CG.issueid=? AND CI.FIELD=? ORDER BY CG.CREATED ASC, CI.ID ASC (ERROR: current transaction is aborted, commands ignored until end of transaction block)

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events