How to check and delete summarizer thread on the GMS 9.3 VA/Windows

Reports are not seen or shown on GMS 9.3 due to stuck syslog threads. 

Login to database using any SQL browser like Heidi SQL or MySQL query browser of your choice.

Once logged in run the following command to identify the stuck threads 

This shows the currently running threads that are stuck.

select * from perf_summarizer_thread;

Based on above query from the column thread_id run the below command to delete the stuck thread.

delete from perf_summarizer_thread where thread_id='x';

x= thread value in numbers ex.0,1,2,3 etc.

id=x will be the thread count that shows up on the database run query select * from perf_summarizer_thread;

Once done, restart the GMS server or just the reports summarizer service from the services window from the appliance page.