As reported by Ms. Sally they are running the CSR report for almost 3hrs. As per checking in Mysql there are process in the background that has been locked.

Resolution:
Killed the process that has been locked in Mysql
Assist on generating the CSR report for Jan - Jun 2018 - Ms.Sally Leria