💡 INTERNAL ONLY
Error message : Could not get SLA information for SLA Cards
❓ Overview
After upgrading Jira recently the TTS plug-in has stopped working. Navigating to the SLA Configurations page gives a modal dialogue that does nothing, forever, and cannot be dismissed.
Navigating to a Jira ticket with SLAs defined gives errors in the page elements responsible for loading SLAs.
Error Message :
Automatic Legacy SLA Migration
Your Legacy SLAs are migrating, please wait..Error !
Could not get SLA information for SLA CardsHAR logs error :
{"migrationStatus":"COMPLETED","totalCount":1,"successCount":0,"failCount":1,"migrationUser":null,"migrationDate":"2023-11-10T17:15:12.916+00:00","errorMessages":["There cannot be same Start and End condition. (Entered in 'Open, Reopened' status - Entered in 'Done, Open, Proposal Review, QA Testing, Closed, Ready for Acceptance, In Development, Needs 3rd Party Clarification, Needs Reporter Clarification, Ready For Development, In Analysis, Ready for Analysis, Ready For QA' status)"],"errors":null,"warningMessages":[],"context":null}
\uD83C\uDF31 Solution
Disable app
Execute following SQL query(change according to DB that is being used)
DELETE FROM "AO_C5D949_SLA_MIGRATION_RESULT" WHERE "ENTRY_TYPE" = 'MIGRATION_STATUS'
Re-enable the add-on and wait for it to finish migration.
Re-calculate SLA
The legacy SLA had “Open” in both the start and finish conditions. Removed “Open” from the finish conditions.