Due to essential maintenance, access to Trados cloud will be unavailable on Saturday 30 August from 00:00 to 12:00 UTC.

Can't generate target translation

Hi team,

When we trying to generate target translation and the error msg is below

<SDLErrorDetails time="2025/8/5 13:49:55">
  <ErrorMessage>Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index</ErrorMessage>
  <Exception>
    <Type>System.ArgumentOutOfRangeException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</Type>
    <ParamName>index</ParamName>
    <HelpLink />
    <Source>mscorlib</Source>
    <HResult>-2146233086</HResult>
    <StackTrace><![CDATA[   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Services.CommentsWriterService.UpdateExistingSharedString(String newCommentsAdded, SharedStringTable sharedStringTable, String contentCell)
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Services.CommentsWriterService.AddContentInSharedStringTable(SharedStringTable sharedStringTableItem, Cell commentCell, String newCommentsAdded)
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Services.ExcelWriterService.InsertCommentsInCell(String targetCellReference, List`1 comments)
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Services.ExcelWriterService.WriteAsSharedString(String sourceContent, String targetContent, IParagraphUnit paragraphUnit, List`1 comments)
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Routes.Writer.WriterDispatchRoute.Handle(ParagraphUnitFound paragraphUnitFound)
   at lambda_method(Closure , IMessage )
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Infrastructure.Dispatcher.Publish(IMessage message)
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Writer.ExcelWriter.Publish(IParagraphUnit paragraphUnit, Cell sourceCell)
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Writer.ExcelWriter.Process(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Writer.BilingualExcelWriter.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Filters.BilingualExcel.Writer.Emoji.BilingualExcelEmojiWriterProcessor.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Filters.Processors.EmbeddedContent.RegexEmbeddedBilingualGenerator.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.Bilingual.WhitespaceBetweenSegmentsBilingualProcessor.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.Integration.GenerationBilingualContentLocator.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.Integration.FileGenerator.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.ProjectApi.AutomaticTasks.CancelProcessor.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.Integration.LocationMarkerLocator.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ProcessParagraphUnit(IParagraphUnit paragraphUnit)
   at Sdl.FileTypeSupport.Framework.Core.Utilities.BilingualApi.ParagraphUnitBuffer.ProcessParagraphUnit(IParagraphUnit pu)
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.OutputParagraphUnit(IParagraphUnit pu)
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.ParseLocalizableParagraphUnit(transunit transunit, LockTypeFlags lockFlags)
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.ParseTransUnit(transunit transunit)
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.ParseGroup(group group)
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.OnGroup(XmlElement group)
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.SdlXliffFeeder.<ContinueScanning>b__14_11(ISdlXliffStreamContentHandler handler)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.SdlXliffFeeder.ContinueScanning()
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.ContinueParsing()
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.ParseNext()
   at Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ParseNext()
   at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.ParseNext()
   at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.Parse()
   at Sdl.ProjectApi.AutomaticTasks.NativeFileGenerator.GenerateFiles(ContentRestriction restriction, Boolean preview, Int32 filePercentBase, Int32 filePercentFactor)
   at Sdl.ProjectApi.AutomaticTasks.GenerateTargetTranslation.GenerateTargetTranslationTask.ProcessFile(IExecutingTaskFile executingTaskFile)
   at Sdl.ProjectApi.AutomaticTasks.AbstractFileLevelAutomaticTaskImplementation.Execute()]]></StackTrace>
  </Exception>
</SDLErrorDetails>

I have tried cleaning temp files on the Disk C and also used Trados Freshstart, but neither fixed the problem.

emoji
Parents
  •  

    Was this Excel created by some other application other than Excel?  Excel keeps a hidden “master list” of all the bits of text used in a workbook.  Each cell points to an item in that list by number.  If that list and the numbers in the cells get out of step (this can happen if the file was created by another tool, a macro, or after heavy edits), then when Trados tries to write the translation and add comments back to the sheet it looks up a number that no longer exists.  That’s why you see: “Index was out of range”.

    Can you try opening the original Excel in Excel and do “File → Save As …” to a new .xlsx.  Then test a new project with this new Excel file.

    You could also temporarily turn off exporting comments into the worksheet as the error does seem to be related 

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji
Reply
  •  

    Was this Excel created by some other application other than Excel?  Excel keeps a hidden “master list” of all the bits of text used in a workbook.  Each cell points to an item in that list by number.  If that list and the numbers in the cells get out of step (this can happen if the file was created by another tool, a macro, or after heavy edits), then when Trados tries to write the translation and add comments back to the sheet it looks up a number that no longer exists.  That’s why you see: “Index was out of range”.

    Can you try opening the original Excel in Excel and do “File → Save As …” to a new .xlsx.  Then test a new project with this new Excel file.

    You could also temporarily turn off exporting comments into the worksheet as the error does seem to be related 

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji
Children
No Data