Question
"Status fail : Message There has been an issue; please consult your system administrator" Error thrown for a report with Long Running Database Query
Error Description:
A Report is trying to pull data from few big tables and was running for more than 7-8 Mins. This case is randomly throwing below error to the users
Status fail : Message There has been an issue; please consult your system administrator
Operator ID Unauthenticated or not available
Requestor ID No ID available
Impact:
User Screen is frozen. User had to close the IE Browser and re-open everything.
System:
Production
Where:
This is only happening with Load-Balanced URL.
Based on the symptoms that you have described, the most likely cause is that your Load balancer / WebServer is timing out the underlying TCP socket connection.
The following are some next steps you can try.
Followup with your load balancer / Webserver admin to check the TCP Connection timeout. Try to tune the SQL query by executing an explain plan and finding the associated cost to see if adding or modifying indexes can improve the query execution time. If SQL query is tuned and there are no options to improve the query execution time, then increase the TCP Connection timeout in Load balancer/Webserver to a higher value. The timeout value should be at least 20% above the max/worst SQL query execution times.