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