Collections:
"Execution Timeout Expired" Error on Azure Portal
Why am I getting the "Execution Timeout Expired" error when using the "Query Editor" on Azure Portal?
✍: FYIcenter.com
If you are running a query or a script that runs more than 5 minutes in the Query Editor on Azure Portal, you will get the "Execution Timeout Expired" error, because Query Editor has 5-minute timeout setting. And this not configure.
For example, if you run the script, fyi_block_insert.sql, in the Query Editor with @Count = 100000, you will get the following error message after 5 minutes:
Failed to execute query. Error: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
You can ignore this error, because the query will continue to run to the end. But you will get any output generated at the end of the execution. The Web page is disconnected with the execution session.
If you know the script will be executed more than 5 minutes, you can consider the following alternatives:
⇒ "Your services were disabled" Error
⇐ Performance Impact of Higher Azure Service Tier
2019-07-21, 3177🔥, 0💬
Popular Posts:
How to update hidden input value field value with WebDriver in Python? Normally, a hidden input valu...
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
Where to find test data generators? FYIcenter.com has prepared a number of test data generators for ...
How to generate IP Addresses? To help you to obtain some IP addresses for testing purpose, FYIcenter...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...