I am currently having problem on analyzing a HR report that stuck when processing.
Trying to debug step by steps, however couldn't find the problem.
Seems to be like the report is randomly hang somewhere.
Is there any tools on SAP that allow me in better and more accurately diagnose what is happening on the system that make this report stuck in the middle of processing?
Well, it is very unlikely that the report is randomly hanging somewhere
What I would do:
1) Check SM50/SM66. Is the work process processing my report still there? What is it doing (what status)? Does the report name or database table change?
2) Most probably the work process will be there. Then you can trace it with SE30/SAT/ST12 transactions. I personally would recommend ST12 (http://scn.sap.com/community/abap/testing-and-troubleshooting/blog/2009/09/08/single-transaction-analysis-st12-getting-started).
3) When you traced long enough, look at the ABAP trace, sort by net time and see what took so long.