runtime error -2147217881 (Query timeout expired)

Areeb Quazi

Hi All,

I am getting runtime error -2147217881 (Query timeout expired) from C# desktop application in the same running application from year without any change and the query will take less that milisecond to execute and after sometime it got corrected automatically without any corrective action. After few days these problem is repeating again.

Database is up and web users are able to access it even I am able to connect and query it from sql client.

Kindly suggest what is the root cause and why am I getting this issue.

Thanks in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Areeb Quazi8y ago
Nilesh, Thanks for your reply.
It's not time specific and query is resulting less than 10 rows. Same table and databases web users are able to access. This issue is related to C# desktop application user.
Nilesh Shah8y ago
this happens in long running queries.

it may happen in some cases only when some input parameter results in fetching big amount of data, which may not be case in every else situation and that's why you see it executes in miliseconds.

Task for you is to identify the user scenario in which case that happens i.e. some particular user login, customer/company selection, etc.

Where is your database is hosted? is this happenning at certain times only? then you have to find out if any other process running at that same time e.g. DB backup or some other data processing job that may consume DB server resources and you see time outs at that time only