SLA reports are failing to load and are causing a stoppage.

Issue :

The customer complains the “SLA Reports" within Time to SLA are not loading. The core Jira page loads with its header & sidebar, but the reports never load, and they just get four spinning dots.

Open

Findings :

1. Refers to the wiki on how to generate SLA Report

2. Performs same SLA Report using own Self Hosted instances and Time to SLA plugins (I've used 10.13.0 )
   Manages to export the intended report.

Open

Solution :

1. Ask the customer to provide the necessary log file.

2. Ask the customer to check his Saved Report DB Content. The customer can run the below query.
   
   Tips: If they face null values on the query's result, they must delete it and try again to reach the report page.
   select * from AO_C5D949_TTS_SAVED_REPORT
   
   

The customer performs this and finds that six rows in that table have null values for all columns (except the ID column), but most of the rows look OK with associated details. After deleting the six wrong rows, the SLA Report page loads fine.