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? 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? 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.. 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) 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! 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.. 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? 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 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? 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 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! Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now