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}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.