I need to generate a report but while doing so, sometimes the processing stops after 5-7 minutes of starting by itself (no data loading done) & sometimes 50% of the data is loaded & then the processing is stops, so, need to start the process again (in both cases). And this is happening continuously from last 3 day. And this is the reason; I am unable to generate the reports (in these last 3 days only 4 reports had been generated). I tried it in odd hours, when the traffic on the server is zero, but nothing fruitful. Also, I had a look on the SQL query written for this report but its fine, as per my knowledge.
What else is going wrong?
Previously, this process was slow but not so much. Before these 3 days, I could be able to generate same report but for different company, 19-20 times (for different products) in a day (average). Tried many things but nothing worked. Can anybody help me out for this, as this issue is getting more and more critical day by day? I will be grateful for this.
thanks & regards,