Error opening an order
Posted: Wed Aug 16, 2023 1:59 pm
Hello,
We are receiving this error sometimes when opening an order through the SoftPro SDK. Any ideas on what would cause this error and how to prevent it? This code is running inside a SoftPro Server Package. Thank you.
NHibernate.Exceptions.GenericADOException: could not delete collection: [SoftPro.Select.Client.Runtime.Session.Locks#d18bdcfc-a3c1-4cc5-87cf-0588106bf336][SQL: DELETE FROM core.LockView WHERE SessionID = @p0] ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user. ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection.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, Boolean shouldCacheForAlwaysEncrypted)
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 NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)
at NHibernate.Persister.Collection.AbstractCollectionPersister.Remove(Object id, ISessionImplementor session)
--- End of inner exception stack trace ---
at NHibernate.Persister.Collection.AbstractCollectionPersister.Remove(Object id, ISessionImplementor session)
at NHibernate.Action.CollectionUpdateAction.Execute()
at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)
at NHibernate.Engine.ActionQueue.ExecuteActions()
at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)
at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)
at NHibernate.Impl.SessionImpl.Flush()
at SoftPro.PersistenceModel.DeadlockDetectionAspect.SoftPro.ServerModel.Aspects.IAspect.Process(Action method) in D:\a\1\s\Code\SPNet\Models\PersistenceModel\DeadlockDetectionAspect.cs:line 33
at SoftPro.PersistenceModel.UniqueConstraintViolationAspect.SoftPro.ServerModel.Aspects.IAspect.Process(Action method) in D:\a\1\s\Code\SPNet\Models\PersistenceModel\UniqueConstraintViolationAspect.cs:line 32
at SoftPro.PersistenceModel.StaleObjectStateExceptionAspect.SoftPro.ServerModel.Aspects.IAspect.Process(Action method) in D:\a\1\s\Code\SPNet\Models\PersistenceModel\StaleObjectStateExceptionAspect.cs:line 23
at SoftPro.Select.Server.Runtime.LockProvider.Acquire(Guid objectType, Guid objectIdentifier, String& owner, String& reason) in D:\a\1\s\Code\SPNet\Select\SelectServer\Runtime\LockProvider.cs:line 165
at SoftPro.Select.Service.Runtime.LockContext.Acquire(Guid objectType, Guid objectIdentifier) in D:\a\1\s\Code\SPNet\Select\SelectService\Runtime\LockContext.cs:line 49
at SoftPro.OrderTracking.Server.Orders.OrderStore.ReadOrder(OrderIdentifier id, Boolean readOnly, Byte[]& data) in D:\a\1\s\Code\SPNet\ProForm\ProFormServer\Orders\OrderStore.cs:line 1388
at SoftPro.OrderTracking.Server.Orders.OrderStore.SoftPro.OrderTracking.Client.Orders.IOrderStore.OpenOrder(OrderIdentifier id, OrderEditMode mode) in D:\a\1\s\Code\SPNet\ProForm\ProFormServer\Orders\OrderStore.cs:line 1253
at SoftPro.OrderTracking.Server.Orders.OrderStore.SoftPro.OrderTracking.Client.Orders.IOrderStore.OpenOrder(IOrderInfo orderInfo, OrderEditMode mode) in D:\a\1\s\Code\SPNet\ProForm\ProFormServer\Orders\OrderStore.cs:line 1219
We are receiving this error sometimes when opening an order through the SoftPro SDK. Any ideas on what would cause this error and how to prevent it? This code is running inside a SoftPro Server Package. Thank you.
NHibernate.Exceptions.GenericADOException: could not delete collection: [SoftPro.Select.Client.Runtime.Session.Locks#d18bdcfc-a3c1-4cc5-87cf-0588106bf336][SQL: DELETE FROM core.LockView WHERE SessionID = @p0] ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user. ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection.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, Boolean shouldCacheForAlwaysEncrypted)
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 NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)
at NHibernate.Persister.Collection.AbstractCollectionPersister.Remove(Object id, ISessionImplementor session)
--- End of inner exception stack trace ---
at NHibernate.Persister.Collection.AbstractCollectionPersister.Remove(Object id, ISessionImplementor session)
at NHibernate.Action.CollectionUpdateAction.Execute()
at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)
at NHibernate.Engine.ActionQueue.ExecuteActions()
at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)
at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)
at NHibernate.Impl.SessionImpl.Flush()
at SoftPro.PersistenceModel.DeadlockDetectionAspect.SoftPro.ServerModel.Aspects.IAspect.Process(Action method) in D:\a\1\s\Code\SPNet\Models\PersistenceModel\DeadlockDetectionAspect.cs:line 33
at SoftPro.PersistenceModel.UniqueConstraintViolationAspect.SoftPro.ServerModel.Aspects.IAspect.Process(Action method) in D:\a\1\s\Code\SPNet\Models\PersistenceModel\UniqueConstraintViolationAspect.cs:line 32
at SoftPro.PersistenceModel.StaleObjectStateExceptionAspect.SoftPro.ServerModel.Aspects.IAspect.Process(Action method) in D:\a\1\s\Code\SPNet\Models\PersistenceModel\StaleObjectStateExceptionAspect.cs:line 23
at SoftPro.Select.Server.Runtime.LockProvider.Acquire(Guid objectType, Guid objectIdentifier, String& owner, String& reason) in D:\a\1\s\Code\SPNet\Select\SelectServer\Runtime\LockProvider.cs:line 165
at SoftPro.Select.Service.Runtime.LockContext.Acquire(Guid objectType, Guid objectIdentifier) in D:\a\1\s\Code\SPNet\Select\SelectService\Runtime\LockContext.cs:line 49
at SoftPro.OrderTracking.Server.Orders.OrderStore.ReadOrder(OrderIdentifier id, Boolean readOnly, Byte[]& data) in D:\a\1\s\Code\SPNet\ProForm\ProFormServer\Orders\OrderStore.cs:line 1388
at SoftPro.OrderTracking.Server.Orders.OrderStore.SoftPro.OrderTracking.Client.Orders.IOrderStore.OpenOrder(OrderIdentifier id, OrderEditMode mode) in D:\a\1\s\Code\SPNet\ProForm\ProFormServer\Orders\OrderStore.cs:line 1253
at SoftPro.OrderTracking.Server.Orders.OrderStore.SoftPro.OrderTracking.Client.Orders.IOrderStore.OpenOrder(IOrderInfo orderInfo, OrderEditMode mode) in D:\a\1\s\Code\SPNet\ProForm\ProFormServer\Orders\OrderStore.cs:line 1219