Forums

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

Missing SLA data (Jira Core 8.7)

Luciano Oliveira February 4, 2020

After upgrade Jira Service desk to 4.7.0 and Jira core to 8.7.0 I cant see any more my SLA.
I tried to follow this article but don't resolved the problem
https://confluence.atlassian.com/jirakb/missing-or-corrupted-sla-data-in-jira-service-desk-828790603.html

My configuration:
Database: MySQL 5.7
Jira Core: 8.7.0
JIRA Service Desk: 4.7.0
MySql Connector: mysql-connector-java-5.1.48-bin.jar

How to check the SLA logs ?

This query

SELECT ( p.pkey 
|| '-'
|| i.issuenum ) AS issuekey,
cf.cfname,
cv.textvalue
FROM customfield cf,
customfieldvalue cv,
jiraissue i,
project p
WHERE i.project = p.id
AND cv.issue = i.id
AND cv.customfield = cf.id
AND cf.customfieldtypekey = 'com.atlassian.servicedesk:sd-sla-field'
AND p.pkey = 'TSD'
AND i.issuenum IN (4565);

Return This for all SLA:

{"timeline":{"events":[{"date":1580822582761,"types":["START"]}]},"ongoingSLAData":{"goalId":138,"startTime":1580822582761,"paused":false,"thresholdData":{"calculatedAt":1580822582761,"remainingTime":10800000,"thresholdsConfigChangeDate":1551208796000,"thresholdsConfigChangeMsEpoch":1551208796153}},"completeSLAData":[],"metricId":11,"definitionChangeDate":1552074108000,"definitionChangeMsEpoch":1552074107894,"goalsChangeDate":1551277790000,"goalsChangeMsEpoch":1551277790449,"goalTimeUpdatedDate":1551208796000,"goalTimeUpdatedMsEpoch":1551208796200,"metricCreatedDate":1551208796153,"updatedDate":1580822582933}


{"timeline":{"events":[{"date":1580822583000,"types":["START"]}]},"ongoingSLAData":{"goalId":146,"startTime":1580822583000,"paused":false,"thresholdData":{"calculatedAt":1580823636041,"thresholdsConfigChangeDate":1580814887000,"thresholdsConfigChangeMsEpoch":1580814886821}},"completeSLAData":[],"metricId":14,"definitionChangeDate":1580823510000,"definitionChangeMsEpoch":1580823510167,"goalsChangeDate":0,"goalsChangeMsEpoch":0,"goalTimeUpdatedDate":1580814887000,"goalTimeUpdatedMsEpoch":1580814886907,"metricCreatedDate":1580814886821,"updatedDate":1580823636057}

 

1 answer

0 votes
Luciano Oliveira February 4, 2020

.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events