Dec 23, 2015, 11:20 AM
Timeout if it takes time to retrive data from database.
We are using Ext.Net version 1.3 . There is a AjaxRequestExeception with in Listner in our master to handle any unhandle exception occur in
our application.
The issue is, we are calling SQL store procedure which has some manipulation and takes time. Earlier it get complete within 30 sec and application runs fine. But now the store procedure is taking time more than 30 sec (45 sec) to return data and we get AjaxrequestException.
We are assuming ajax request has time out because of that it happen. If we reduce the data and procedure return the data with 30 sec then app runs fine. Both application and database is on same server.
Code which is giving error is
our application.
The issue is, we are calling SQL store procedure which has some manipulation and takes time. Earlier it get complete within 30 sec and application runs fine. But now the store procedure is taking time more than 30 sec (45 sec) to return data and we get AjaxrequestException.
We are assuming ajax request has time out because of that it happen. If we reduce the data and procedure return the data with 30 sec then app runs fine. Both application and database is on same server.
Code which is giving error is
<ext:ResourceManager ID="ResourceManager1" runat="server" ShowWarningOnAjaxFailure="false" Theme="Slate">
<Listeners>
<AjaxRequestException Handler="
Ext.Msg.alert('Alert','The server can not process the request because the selected data is too large for the server to handle.Please choose less data.');" />
</Listeners>
</ext:ResourceManager>
we want to know if there is way we can increase the time out of retriving data from database so that app should wait for more time for retrieving the data and dont give error.
Last edited by Daniil; Dec 28, 2015 at 2:20 PM.
Reason: Please use [CODE] tags