Hi all,
I'm getting an error like this 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user . The statement has been terminated. '
Below I'm attaching the image. Please may I know how to overcome this issue.
Dorine Boudry Removed image because it had an unprotected URL in it
Thanks
Bhuvaneshwari
Hi ,
Please increase the Timeout of that particular module see below image.
Hi @Chandra Vikas
I increased the timeout .But again same error is coming.
@Chandra Vikas ,
this error message is not related to the timeout for a server call from the client, so changing that value will not help.
Hi Bhuvaneshwari Reddy,
Are you retrieving this information from a Web service?
Notice that you don't have pagination as well, you could try to return less records and use pagination to access the other records.
Regards,
Hi @Bhuvaneshwari Reddy ,
just a few remarks on what you are sharing here
I just removed the image you shared for your protection
Hi @Dorine Boudry
Thank you so much for removing the image .I given authorization .
Ok, I checked, I can no longer access your screens.
So you can add that image again, but maybe make the url unreadable
Below I attached the image for reference .May I know how to overcome this error.
you are showing an image of a screen, how could we possibly know what is going on or why you are getting an error. On the screen as shown, there isn't even an error.
This is normally a timeout between your server logic and the database.
you need to share
@Bhuvaneshwari Reddy I suggest to read this article once on 'Timeouts under the hood'
Hi,
The error message indicates that the query execution is taking too long and exceeding the timeout period. Here are some steps to help you overcome this issue:
1. Increase the timeout value: you can increase the timeout value for the query/aggregate , set a higher value for "Timeout" (in seconds).
2. Optimize the query: Analyze the query and optimize it for better performance. Check for:
- Inefficient joins or subqueries
- Lack of indexing on columns used in WHERE or JOIN clauses
- High data volumes being processed
3. If you are processing the high volume of data then you must use the pagination mechanism to return the limited set of data.