CITASys Automation Posted December 6, 2022 Share Posted December 6, 2022 I got error message "Query timeout expired" when load data from cloud database, it work fine in local database.. how to fixed this case? Quote Link to comment Share on other sites More sharing options...
Sherzod Posted December 6, 2022 Share Posted December 6, 2022 2 minutes ago, CITASys Automation said: I got error message "Query timeout expired" when load data from cloud database, it work fine in local database.. How long does it take to complete the request? Quote Link to comment Share on other sites More sharing options...
CITASys Automation Posted December 6, 2022 Author Share Posted December 6, 2022 with local database its instantly complete, but with cloud database its always fail at that query timeout expired.. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted December 6, 2022 Share Posted December 6, 2022 Try increase AjaxTimeout value (default 30 sec) Quote Link to comment Share on other sites More sharing options...
CITASys Automation Posted December 6, 2022 Author Share Posted December 6, 2022 ok thanks sherzod! Quote Link to comment Share on other sites More sharing options...
CITASys Automation Posted December 6, 2022 Author Share Posted December 6, 2022 I try with 300000 ajax timeout value, but still appear Query timeout expired.. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted December 6, 2022 Share Posted December 6, 2022 Just now, CITASys Automation said: I try with 300000 ajax timeout value, but still appear Query timeout expired.. What do you see in the browser console, is there an error? Quote Link to comment Share on other sites More sharing options...
CITASys Automation Posted December 6, 2022 Author Share Posted December 6, 2022 thiss error message appear Quote Link to comment Share on other sites More sharing options...
Sherzod Posted December 6, 2022 Share Posted December 6, 2022 1 hour ago, CITASys Automation said: when load data from cloud database Are you sure you are doing this correctly? Quote Link to comment Share on other sites More sharing options...
Sherzod Posted December 6, 2022 Share Posted December 6, 2022 503 service unavailable 401 Unauthorized Quote Link to comment Share on other sites More sharing options...
irigsoft Posted December 6, 2022 Share Posted December 6, 2022 1 hour ago, CITASys Automation said: I got error message "Query timeout expired" when load data from cloud database, it work fine in local database.. how to fixed this case? Hello, what kind of Query You use (ADO or else). in my practice i use ADO and there is connection timeout, ADoConnection too. Maybe you should extend this time! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.