Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Hi everyone!
I have a problem. Some issues have status like done or closed. Also, this issues has a resolution.
But SLA was not stopped.
In database, I see this criterion in table "customfieldvalue":


And issues where SLA was stopped after resolution has this criterion:


I can watch issues where SLA was not stopped by SQL query:










FROM [SQL12DB3_JIRA].[jira].[dbo].[jiraissue] as ji

join [SQL12DB3_JIRA].[jira].[dbo].[customfieldvalue] as cv

on cv.issue = and cv.customfield = 12323 and cv.textvalue like '%,"paused":false,%'

where ji.project = 'MyProject' and ji.issuestatus in (10424,11923)

What could be the problem?

1 answer

Have you double checked your SLA definition?? Maybe the final status is not set to stop the clock.


Of course, i checked this.
This issues has a not final status. But in this status SLA should have paused.
Now, issues have a status "Done", after this status they will be in status "Closed".
Closed - is final status.
We can resave SLA by ur link. But some time after, we have a new issues with status "Done" and sla is not stopped.

Can you provide with screeenshots of your SLA configuration and workflow? 

pic21001.gifpic16334.gifIs the information sufficient or not translatable?

The language is a barrier for me, sorry.

I translated this.
Is this information sufficient?

From the screenshots I can only state that:

  1. you might aswell delete every pause condition and make them stop conditions, since time will never start counting again once paused.
  2. the only issues where the SLA time will be stoped (not paused) will be those in Closed status.
  3. for every issue in Done status the SLA will be paused (not stoped).
  4. I'm not sure what the transitions starting and ending in the same status do. I guess you're counting something or have some sort of postfunction doing something there.

For those issues that you feel haven't managed SLA times proprerly: how do you see them in the UI? does the time just keep counting down?

Can you make a list of every issue (or at least a good number of them) in closed and done status, indicating if they show that "paused":false of "paused":true tag?

I would expect that every Done issue is at true and every Closed issue is at false.

Yes, we can make status "Done" like final status, and SLA will be stopped.
But we need the issue to be reopened if the user is not satisfied, in final status it's impossible.
For example, this isssue:
In database has a paused":false tag
and typical issue, has a "paused":true," tag:pic27967.gif

And i have a problem only with status "Done".
Issues with status "Closed" has this tag:

Looking purely at your workflow and SLA configuration, I think that the only error you have is that once you reopen an issue the SLA timer doesn't start to run again. You should add the status "Assigned" to the start column.

That being said... I see no more suspicious things there. 

The concept of reopening makes sense, of course, but you can't do that (from an SLA time management point of view) once the clock has been stoped. I think you're not trying to do this but I'm not certain since transitions are not 100% clear on the diagram.

What do the transitions "from Done to Done" and "from Closed to Closed" do? I just want to make sure that when you reopen a ticket you are moving from Done to Assigned (judging by the workflow diagram) and you're not doing something like going from Closed to Closed but deleting the resolution...

I'm getting out of ideas.

Thank u, so much.
We will try change status to "Assigned" at start.

Not change, but ADD.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

123 views 1 2
Read article

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