Hello,

We are trying to publish solution from the Service Center. We are getting this error.


Error closing the transaction to the database: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.


   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.TdsParserStateObject.ReadSniError(TdsParserStateObject
stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj)
   at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[]
buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
   at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest
transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean
isDelegateControlRequest)
   at System.Data.SqlClient.SqlInternalTransaction.Commit()
   at System.Data.SqlClient.SqlTransaction.Commit()
   at OutSystems.HubEdition.Extensibility.Data.TransactionService.GenericTransactionManager.EndTransaction(TransactionInfo
transInfo, Boolean commit, Boolean toFreeResources)
   at OutSystems.HubEdition.Extensibility.Data.TransactionService.GenericTransactionManager.SafeEndTransaction(TransactionInfo
transInfo, Boolean commit, Boolean toFreeResources)
   at OutSystems.HubEdition.Extensibility.Data.TransactionService.GenericTransactionManager.SafeEndTransaction(TransactionInfo
transInfo, Boolean commit, Boolean toFreeResources)
   at OutSystems.HubEdition.Extensibility.Data.TransactionService.GenericTransactionManager.EndCommitableTransaction(IDbTransaction
trans, Boolean commit)
   at #Hyb.#Oyb.Commit()
   at #Znf.#Ynf.GetPendingActivities(Int32 batch, String myIp)
   at OutSystems.HubEdition.Scheduler.SchedulerProducerConsumer`1.InnerExecuteProducer()
   at OutSystems.HubEdition.Scheduler.SchedulerProducerConsumer`1.<ExecuteProducer>b__c()
   at OutSystems.HubEdition.ServerCommon.SandboxUtils.ExecuteInMainSandbox(Action
action)
   at OutSystems.HubEdition.Scheduler.SchedulerProducerConsumer`1.ExecuteProducer()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext
executionContext, ContextCallback callback, Object state, Boolean
preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state, Boolean
preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()


Please advice how to resolve this issue.

Thanks and Regards,

Suraj Borade


Hi Suraj,

To be sure, did you check the network connectivity? Are you able to reach deployment centre from the host where the service centre is hosted?

Regards,

Swatantra

Hello Mr., Everything is fine with you. I need help in a scenario that I will describe below:

I have faced this problem "rror closing the transaction to the database" or "A transport-level error has occurred when receiving results from the server. (Provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)" In a PRD Outsystems environment, V11. We have a Timer that runs every 10 minutes and integrates data between LEGACY and the Outsystems environment, and this error occurs in virtually all executions. We have already identified scenarios where the error occurs when Outsystems is attempting to execute a query in the Outsystems database itself (IIS and SQL in a local AWS environment, Zona Virginia) and also at many times when we will access other SQL environments also on Amazon, but in other regions .

Have any of you still experienced this problem in your environment?