0

I've received the following error message in the Translation Manger log files when trying to send a new translation job:

   2020-01-02T09:16:40  Tridion.TranslationManager.Service  SendForTranslation  Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   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.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Tridion.TranslationManager.DomainModel.DataAccess.TranslationJobSqlDal.<>c__DisplayClass10_0.<DequeueJob>b__0(DbCommand command)
   at Tridion.TranslationManager.DomainModel.DataAccess.TranslationJobSqlServerDal.ExecuteInCommand[T](String storedProcedure, Func`2 code)
   at Tridion.TranslationManager.DomainModel.DataAccess.TranslationJobSqlDal.DequeueJob(TranslationJobLoadFilters loadFilter, TranslationJobState startState, TranslationJobState endState)
   at Tridion.TranslationManager.DomainModel.TmSession.DequeueForSend(TranslationJobLoadFilters loadFilter)
   at Tridion.TranslationManager.DomainModel.Service.SendForTranslationTask.Process()
   at Tridion.TranslationManager.DomainModel.Service.ServiceTask.ThreadMethod()
The wait operation timed out

I presume, looking at the error message, that this is a problem with the Translation Manager service updating the Translation Manager database (on the Tridion side), rather than a communication issue with the TMS server.

I've checked the Configuring Translation Manager section of the online documentation, but cannot see anywhere in the TranslationManager.xml file to specify the timeout settings. Do these just come from the normal Tridion MMC Snap-in timeout settings?

Tridion MMC Snap-in Timeout Settings


Side note: I suspect that this issue needs the TM_8.5.0.14886 hotfix to resolve properly (rather than just increasing the database timeouts), but I was interested to see where these are configured so I could compare them across (load balanced) servers.

  • I'm interested how this turned out :) did the hotfix fix this issue? – Atila Sos Jan 14 at 14:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.