Time To SLA gives error "Could not get SLA information for SLA Cards" and stopped working after upgrade

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 :

1. Automatic Legacy SLA Migration
   Your Legacy SLAs are migrating, please wait..

2. Error !
   Could not get SLA information for SLA Cards

3. HAR 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

1. Disable app

2. Execute following SQL query(change according to DB that is being used)
   DELETE FROM "AO_C5D949_SLA_MIGRATION_RESULT" WHERE "ENTRY_TYPE" = 'MIGRATION_STATUS'

3. Re-enable the add-on and wait for it to finish migration.

4. Re-calculate SLA

5. The legacy SLA had “Open” in both the start and finish conditions. Removed “Open” from the finish conditions.
   

   

\uD83D\uDCCE Related articles