I also tried to run the same table by a simple query: select * from tbl_Product from SQL server management studio, I can not get the result, the window is keeping running without any result. I even try it to run it in top 10 records without any result returned.
I searched a lot posts from internet, no good solution found so far, can anybody help? thanks in advance.
Member
335 Points
2086 Posts
{"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or...
Feb 11, 2019 02:34 PM|Peter Cong|LINK
My mvc web app was running well last Friday, there is no design changes at all,
but I got this error today (Monday) when I launch it. the error appears on one table before the data is loaded to a webgrid,
I also tried to run the same table by a simple query: select * from tbl_Product from SQL server management studio, I can not get the result, the window is keeping running without any result. I even try it to run it in top 10 records without any result returned.
I searched a lot posts from internet, no good solution found so far, can anybody help? thanks in advance.
All-Star
42581 Points
18109 Posts
Re: {"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation...
Feb 11, 2019 03:01 PM|mgebhard|LINK
Perhaps there is an uncommitted transaction?
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-opentran-transact-sql?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/kill-transact-sql?view=sql-server-2017
Contact your DBA for assistance.
Member
335 Points
2086 Posts
Re: {"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation...
Feb 11, 2019 03:52 PM|Peter Cong|LINK
Thanks, the problem is resolved by itself, weird, I didn't ask DBA though, not sure if they did something without my asking, any way, thanks a lot