This article is for Time to SLA Data Center.
Symptoms
Upgraded from Time to SLA v10.2.1 to v10.14.1.
After upgrading the version, the app stopped working.
The error as in the following log:
2023-11-10 22:32:00,975-0300 timetosla-migration-pool-1 ERROR ServiceRunner [c.s.j.p.timetosla.service.G] [Time to SLA Plugin for JIRA] Unexpected error while migrating SLAs at java.base/java.lang.Thread.run(Unknown Source)
All SLA panels are missing when tried to regenerate or recalculate the SLA.
Resolution Steps
Disable the Time to SLA 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 until it finishes the migration.
If the issue persists, please go to the "AO_C5D949_TTS_SLA" table and look at the "PROXIED_SLA_ID" column.
In that column, search for the value that is equal to "null". You'll be able to see the problematic SLA.