SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 7.3.435 Pro] - Query Timeout Expired on SQL Server

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 7.3.435 Pro] - Query Timeout Expired on SQL Server
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 1390

Post [SA 7.3.435 Pro] - Query Timeout Expired on SQL Server Reply with quote
I'm trying to run a stored procedure that is known to run 2-4 minutes, depending on the load on the server. Somewhere after 60 seconds (~65-102s) the execution stops with last line of message "The command(s) completed successfully(102.34 s)." and the second line of the messages showing "Query timeout expired."

I tried modifying the Command Timeout in connection settings from 0 to 600 secs but the showing the Raw Connection String did not reflect the changes. Also, manually editing the connection string by adding "Command Timeout=600;" but it made no difference.

What's happening here?

EDIT: Also, the line and the icon for the "Query timeout expired" line is green instead of red or yellow that would indicate that there was something wrong. The last line of the message ("completed successfully") is misleading as well.
Tue Nov 03, 2015 5:31 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Please try setting command timeout to zero, which means no timeout, and then restart SQL Assistant including the system tray application. Hope that works.


Last edited by SysOp on Tue Nov 03, 2015 11:08 am; edited 1 time in total
Tue Nov 03, 2015 9:33 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1390

Post Reply with quote
It didn't help. I still get "Query timeout expired" after ~102 seconds.
Tue Nov 03, 2015 10:53 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Are you using SA SQL Editor or SSMS? If SA, are connecting using ODBC or ADO
Tue Nov 03, 2015 11:11 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1390

Post Reply with quote
I'm connecting in SA SQL Editor through ODBC. The query is finishes without the timeout expired error in SSMS.
Tue Nov 03, 2015 5:26 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Would you please try changing connection from ODBC to ADO.NET and see if that does the trick?
Tue Nov 03, 2015 7:18 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1390

Post Reply with quote
It finished using ADO.NET in ~114 seconds. But I'd refrain using ADO.NET for it has its own quirks, such as not returning milliseconds for datetimes.

What would be the cause of this? I don't remember having query timeouts expire earlier.
Wed Nov 04, 2015 5:24 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Thanks for testing with ADO.NET. We will look into ODBC issue and test if the command timeout entered in the settings is negated by something else. This may take a little while. I will post any updates as they become available.
Wed Nov 04, 2015 10:37 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1390

Post Reply with quote
Thank you very much. As I said earlier, modifying the values in the editbox did not change the string shown in Raw Connection String. I hope this helps.
Wed Nov 04, 2015 12:26 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.