June 24, 2013 at 8:43 am
Hi,
When a user tries to edit a table, he is getting a timeout error.
Here is a brief details about the error.
"Executed SQL Stmnts: "the stmnts" from dbo.tablename,
Error source: .Net SqlClient Data Provider
Error Message: Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Also, when he tries to do a select query, it prompts him to login the server\instance again, eventhough he is already logged in.
Please share your knowledge, if you know about this error.
Thanks,
SueTons.
Regards,
SQLisAwe5oMe.
June 24, 2013 at 8:54 am
SQLCrazyCertified (6/24/2013)
Hi,When a user tries to edit a table, he is getting a timeout error.
Here is a brief details about the error.
"Executed SQL Stmnts: "the stmnts" from dbo.tablename,
Error source: .Net SqlClient Data Provider
Error Message: Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Also, when he tries to do a select query, it prompts him to login the server\instance again, eventhough he is already logged in.
Please share your knowledge, if you know about this error.
Thanks,
SueTons.
What are you using for a front end? I think you might be referring to using the right click, edit table in SSMS but I am not sure.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 24, 2013 at 9:03 am
Sean Lange (6/24/2013)
SQLCrazyCertified (6/24/2013)
Hi,When a user tries to edit a table, he is getting a timeout error.
Here is a brief details about the error.
"Executed SQL Stmnts: "the stmnts" from dbo.tablename,
Error source: .Net SqlClient Data Provider
Error Message: Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Also, when he tries to do a select query, it prompts him to login the server\instance again, eventhough he is already logged in.
Please share your knowledge, if you know about this error.
Thanks,
SueTons.
What are you using for a front end? I think you might be referring to using the right click, edit table in SSMS but I am not sure.
Sean, Yes, I am referrring to editing table using SSMS.
SueTons.
Regards,
SQLisAwe5oMe.
June 24, 2013 at 9:06 am
In which case, check to see if there is an open transaction in the database; may be that someone has a transaction open that is locking the system tables.
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
June 24, 2013 at 9:22 am
SQLCrazyCertified (6/24/2013)
Sean Lange (6/24/2013)
SQLCrazyCertified (6/24/2013)
Hi,When a user tries to edit a table, he is getting a timeout error.
Here is a brief details about the error.
"Executed SQL Stmnts: "the stmnts" from dbo.tablename,
Error source: .Net SqlClient Data Provider
Error Message: Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Also, when he tries to do a select query, it prompts him to login the server\instance again, eventhough he is already logged in.
Please share your knowledge, if you know about this error.
Thanks,
SueTons.
What are you using for a front end? I think you might be referring to using the right click, edit table in SSMS but I am not sure.
Sean, Yes, I am referrring to editing table using SSMS.
SueTons.
There are some serious issues with the Edit databound grid. I can't recall the details at the moment but honestly anybody who is using SSMS should be able to write update statements instead of using that grid.
I would tend to agree with Matthew that the issue is most likely due to locking. I would not be surprised at all if that edit window generates its own table locks when opening the edit window.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 24, 2013 at 9:49 am
Sean Lange (6/24/2013)
SQLCrazyCertified (6/24/2013)
Sean Lange (6/24/2013)
SQLCrazyCertified (6/24/2013)
Hi,When a user tries to edit a table, he is getting a timeout error.
Here is a brief details about the error.
"Executed SQL Stmnts: "the stmnts" from dbo.tablename,
Error source: .Net SqlClient Data Provider
Error Message: Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Also, when he tries to do a select query, it prompts him to login the server\instance again, eventhough he is already logged in.
Please share your knowledge, if you know about this error.
Thanks,
SueTons.
What are you using for a front end? I think you might be referring to using the right click, edit table in SSMS but I am not sure.
Sean, Yes, I am referrring to editing table using SSMS.
SueTons.
There are some serious issues with the Edit databound grid. I can't recall the details at the moment but honestly anybody who is using SSMS should be able to write update statements instead of using that grid.
I would tend to agree with Matthew that the issue is most likely due to locking. I would not be surprised at all if that edit window generates its own table locks when opening the edit window.
No active transactions...and they've been doing this way for long time without any issues, just started happen since Friday.
SueTons.
Regards,
SQLisAwe5oMe.
June 24, 2013 at 10:03 am
SQLCrazyCertified (6/24/2013)
No active transactions...and they've been doing this way for long time without any issues, just started happen since Friday.SueTons.
So what happened late last week? Are there new triggers on the table? Maybe some audting? Is it consistently throwing this exception?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 24, 2013 at 10:20 am
See if there is any open transactions (uncommitted transactions) using dbcc opentran which will show any blocked spids. Look for any locks on your table using sp_lock or (dm_tran_locks) or you can run sp_who2 for more info. In SSMS you can look into Management > Activity Monitor > right click "View locks by Object"
What is the transaction timeout set for SSMS. Check this by going to Tools > Options and click on the Designers. Look for "Transactions time out after" The default value is 30 sec. Check if this was changed recently.
June 24, 2013 at 10:53 am
Thank you all for your feedbacks.
I checked with the user now and it seems it resolved itself. Maybe as you guys mentioned, it was due to some long running transactions or due to some locking in system tables, however, I couldn't find it. Anyway, thanks.
SueTons.
Regards,
SQLisAwe5oMe.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply