Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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":

...{"timeline":{"events":[{"date":1561552301307,"types":["START"]}]},"ongoingSLAData":
{"goalId":116,"startTime":1561552301307,"paused":false,"thresholdData":{"calculatedAt.....

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

...{"timeline":{"events":[{"date":1561616106021,"types":["START"]},{"date":1561616266930,"types":["PAUSE"]}]},"ongoingSLAData":{"goalId":111,"startTime":1561616106021,"paused":true,"thresholdData...

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

SELECT ji.[ID]

,ji.[pkey]

,ji.[issuenum]

,ji.[RESOLUTION]

,ji.[issuestatus]

,ji.[CREATED]

,ji.[UPDATED]

,ji.[RESOLUTIONDATE]

,cv.textvalue

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

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

on cv.issue = ji.id 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

1 vote
Iago Docando Community Leader Jun 27, 2019

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

http://YOUR.JIRA.ADDRESS/servicedesk/admin/YOUR.PROJECT.KEY/sla/custom

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.

Iago Docando Community Leader Jun 27, 2019

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

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

Iago Docando Community Leader Jun 27, 2019

The language is a barrier for me, sorry.

I translated this.
Is this information sufficient?
pic16334.gifpic21001.gif

Iago Docando Community Leader Jun 27, 2019

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
pic25981.gif
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:
{"timeline":{"events":[{"date":1560915462173,"types":["START"]},{"date":1560934807067,"types":["PAUSE"]},{"date":1561392280510,"types":["STOP","UNPAUSE"]}]},"ongoingSLAData":null,"completeSLAData":[{"succeeded":true,"goalTime":28800000,"goalTimeUnits":{"weeks":0,"remainingDaysWithinWeek":4,"remainingMillisWithinDay":16192933,"breached":false}

Iago Docando Community Leader Jun 28, 2019

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.

Iago Docando Community Leader Jun 28, 2019

Not change, but ADD.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June ask me anything (AMA)

Hello Community members! We’re wrapping up the end of JSM June with an Ask Me Anything (AMA) with the Jira Service Management product team. This is your chance to ask all your ITSM questions to o...

157 views 9 10
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