It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

script for creating issue in Jira service desk, cause block in database

the query that cause de block in db

(@P0 nvarchar(4000),@P1 nvarchar(4000),@P2 nvarchar(4000))
insert into "dbo"."AO_F1B27B_PROMISE_HISTORY" ("KEY_HASH", "TASK_KEY", "CLASSIFICATION") values ( @P0 , @P1 , @P2 )



here my script, what im doing wrong?

import com.atlassian.jira.ManagerFactory
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.project.Project
import com.atlassian.jira.issue.index.IssueIndexingService
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.IssueInputParameters
import com.atlassian.jira.bc.issue.IssueService
import com.atlassian.jira.util.ImportUtils
import org.apache.log4j.Category

def Category log = Category.getInstance("com.onresolve.jira.groovy.PostFunction")

log.debug ("iniciando clone ")
log.debug ("declarando variables")
def issueManager = ComponentAccessor.issueManager
def issueFactory = ComponentAccessor.getIssueFactory()
def authenticationContext = ComponentAccessor.getJiraAuthenticationContext()
def issueLinkManager = ComponentAccessor.getIssueLinkManager()
def customFieldManager =ComponentAccessor.getCustomFieldManager()
def userUtil = ComponentAccessor.getUserUtil()
def projectMgr = ComponentAccessor.getProjectManager()
def issueLinkTypeManager = ComponentAccessor.getComponentOfType(IssueLinkTypeManager.class)
def issueLinkType = issueLinkTypeManager.getIssueLinkTypesByName('Problem/Incident')[0];
def issueIndexingService = ComponentAccessor.getComponent(IssueIndexingService)
def issueService = ComponentAccessor.getIssueService();

def IssueInputParameters issueInputParameters = issueService.newIssueInputParameters();

log.debug ("Inicializando inputparameters")
issueInputParameters.setProjectId(projectMgr.getProjectObjByKey("CREOSD2").Id); //JSD project

log.debug ("IssueService.ValidateCreate")
IssueService.CreateValidationResult validationResult = issueService.validateCreate(authenticationContext.getLoggedInUser(), issueInputParameters); //issueObject.getReporter()
log.debug("Could not create issue: " + validationResult.getErrorCollection());
// Create new issue
log.debug ("Trying crear issue")
IssueService.IssueResult createResult = issueService.create(authenticationContext.getLoggedInUser(), validationResult);
log.error("Issue Created")
if (!createResult.isValid())
log.error("Issue was not created!")
} else {
log.error("Issue was created. Issue Id: " + createResult.getIssue().getKey())

7 answers


is wrong, should be


You may have other problems but you should at least start with something that will compile.



i used: projectMgr.getProjectObjByKey("CREOSD2").getId()

the error persists

the query that cause de block in db

(@P0 nvarchar(4000),@P1 nvarchar(4000),@P2 nvarchar(4000))
insert into "dbo"."AO_F1B27B_PROMISE_HISTORY" ("KEY_HASH", "TASK_KEY", "CLASSIFICATION") values ( @P0 , @P1 , @P2 )

if i copy/paste the script in Add-ons->SCript Ruhnner->Script Console and change the values of issueInpurtParameteres (hardcode) it works!

i dont understand why in a postfunction inside a workflow it doesnt work

Hi Jamie,

I detected this issue happens only if the target is a JIRA Service Desk Project with SLA configured.

if i delete all SLA definition, all works!

What exactly do you mean by "block in db"? 

What is different when you run it in Script Console, is it the issue that you are copying?

What DMBS are you using?

Hi Jamie,

here the screen of block in database

Sin títulodb1.png

here the detail of SPID 62, the query that causes the "block"

Sin títulodb2.png

Also JIRA screen stucks, and the only way to resolve the problem, is restarting JIRA Service or kill the process (in database)

im using sql server 2008

NOTE: This problem is only with JIRA Service Desk Project with SLA configured

if i delete all SLA definition, all works!

About what is different,
i thing the example of script console is external is separate of any process, while the script in a workflow post function is inside a process of a project maybe a process of an issue, im not sure.
i tried also with Script listeners (trigerred on genericevent) but the same problem =(


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

3,101 views 11 5
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you