Posts: 17
Threads: 10
Joined: May 2008
Reputation:
0
We have a central DB with all connections. Users spread out over the world.
We see hang's and hickups when we in Europe have been using the ASG-RD for the whole day and especially when our US colleges starts to use it.
Today we were 3 Europe users that got an errormessage "An error occured on executing an sql statement PropertiesSet" at the same time around 14:30 CET (start time for US guys)...?
We are using 9.0.5385.0 and a SQL database.
Posts: 11,205
Threads: 101
Joined: Aug 2006
Reputation:
205
Can you please post the whole error message - you can find it in ErrorLog or in Windows Application Event Log - could be a timeout problem...
Regards/Gruss
Oliver
Posts: 17
Threads: 10
Joined: May 2008
Reputation:
0
An error occured on executing an sql statement PropertiesSet Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. --------------------------- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1
Posts: 17
Threads: 10
Joined: May 2008
Reputation:
0
<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:"Segoe UI"; panose-1:2 11 5 2 4 2 4 2 2 3;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin-top:0cm; margin-right:0cm; margin-bottom:8.0pt; margin-left:0cm; line-height:107%; font-size:11.0pt; font-family:"Calibri",sans-serif;} .MsoChpDefault {font-family:"Calibri",sans-serif;} .MsoPapDefault {margin-bottom:8.0pt; line-height:107%;} /* Page Definitions */ @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt;} div.WordSection1 {page:WordSection1;} -->
An error occured on executing an sql statement
PropertiesSet
An error occured on executing an sql statement
PropertiesSet
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
---------------------------
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at CloudAdminDataAccess.SqlDataAccessor.PropertiesSet(IPropertiesItemData data)
Posts: 11,205
Threads: 101
Joined: Aug 2006
Reputation:
205
Yes it is a timeout problem - default is 15 seconds - you can edit this value if you edit your environment (before you are connected - so you have to do choose edit in Login dialog) - if you choose "Configure advanced settings" you will be able to set the timeout value to a higher value - I think you are using the database via WAN and so it could be that a transaction will need more than 15 seconds - even if it is from a collegue from US it might block the database for other users...
Regards/Gruss
Oliver
Posts: 17
Threads: 10
Joined: May 2008
Reputation:
0
So there is some process creating a table-lock?
Can you please take a look at this and see if there is a way to work around it.
Posts: 11,205
Threads: 101
Joined: Aug 2006
Reputation:
205
Did you try to set a higher timeout? I don't think that that we use sql statements that are taking too long to process - but on WAN connections it could be slow and the table lock is necessary to ensure consistency in data structure...
Regards/Gruss
Oliver
