Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
-
Hello, I have access control application called db digitus which is used SQL server to storing data and retrieving. once i search for access control even report , i am getting this error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". Can anybody help me to fix this issue please? thank you
-
Hello, I have access control application called db digitus which is used SQL server to storing data and retrieving. once i search for access control even report , i am getting this error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". Can anybody help me to fix this issue please? thank you
-
Hello, I have access control application called db digitus which is used SQL server to storing data and retrieving. once i search for access control even report , i am getting this error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". Can anybody help me to fix this issue please? thank you
The lounge isn't for programming questions. Likely your db-query and/or processing of it is taking too long.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
-
The lounge isn't for programming questions. Likely your db-query and/or processing of it is taking too long.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
Eddy Vluggen wrote:
The lounge isn't for programming questions
This might not be a programming question, so I'll try to help a little. However, it would be better if it were in the database forum. The message you have got is fairly generic for a million and one database issues and does not necessary mean that you have a timeout despite the words in the message. I get the message a lot. Often it is intermittent and can be got around by re-requesting the transaction? If that is the case in your situation, I'm afraid it is one of the "tough - that's life, live with it" problems. If the same transaction always gives the problem then it might be your SQL that is at fault - too complex query, bad indexing (i.e. wrong items being indexed), trying to return too many rows / columns, no caching etc etc - in which case it should be posted on the database forum.
-
Eddy Vluggen wrote:
The lounge isn't for programming questions
This might not be a programming question, so I'll try to help a little. However, it would be better if it were in the database forum. The message you have got is fairly generic for a million and one database issues and does not necessary mean that you have a timeout despite the words in the message. I get the message a lot. Often it is intermittent and can be got around by re-requesting the transaction? If that is the case in your situation, I'm afraid it is one of the "tough - that's life, live with it" problems. If the same transaction always gives the problem then it might be your SQL that is at fault - too complex query, bad indexing (i.e. wrong items being indexed), trying to return too many rows / columns, no caching etc etc - in which case it should be posted on the database forum.
jsc42 wrote:
The message you have got is fairly generic for a million and one database issues and does not necessary mean that you have a timeout despite the words in the message.
Doesn't necessary mean that, but often does.
jsc42 wrote:
Often it is intermittent and can be got around by re-requesting the transaction?
So why the question mark? You unsure?
jsc42 wrote:
If that is the case in your situation, I'm afraid it is one of the "tough - that's life, live with it" problems.
No, it ain't; and if you encounter it, you pay me for the solution. I've seen and solved it; sometimes it is the query, sometimes it is the processing of the results; and before you even dare to make an offer, make it a fakkin' sweet one, since I aint tempted easily, especially not after a lecture of someone who is swimming in sand. Get back to your basket, I'm in a foul mood.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.