Time To SLA | 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.

Open

Navigating to a Jira ticket with SLAs defined gives errors in the page elements responsible for loading SLAs.

Open

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}

 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'
   
   Note: It is always a better practise to take the database back up.

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.
   
   

 Related articles