Error while generating target translation

Hello,

I'm using Studio 2015 SP2 on a Windows 10 Pro PC with Office 365.

I had a very larger Excel file (.xls) to translate, but only some cells of it. So I formatted in yellow the text of all the cells I didn't have to translate and finished the translation. 

But when I wanted to save the target file or even to generate the translated file, I each time got an error saying that the target file could not be generated because of 2 errors - see screen capture attached: 

I have a Dutch Windows, so the error messages are in Dutch. The translation of these 2 same errors is this: The index is out of range. The index cannot be negative and must be smaller that the size of the collection (?). Setting name: index.

 

I now had to paste the translated cells and lost so about 1 hour. I would appreciate a solutionj for this problem, as my customer will send me from now on eacht month an update of this Excel file that contains error messages in Dutch, French and English.

 

Can anyone help me to solve this problem. 

Please find also attached the original Excel file: Vertaling genmessages maart_FR - Kopie.zip and the sdlxliff file: Vertaling genmessages maart_FR - Kopie.xlsx.zip

 

Thank you for your help.

Best regards,

Eric

Parents Reply Children
  • Hi Paul,

    Thank you again for your fast reply.

    Please find attached the exported error messages file: 

    <SDLErrorDetails time="21-3-2017 13:39:25">
      <ErrorMessage>Failed to save target content: De index valt buiten het bereik. Deze mag niet negatief zijn en moet kleiner zijn dan de grootte van de verzameling.
    Parameternaam: index</ErrorMessage>
      <Exception>
        <Type>System.ArgumentOutOfRangeException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</Type>
        <ParamName>index</ParamName>
        <HelpLink />
        <Source>Sdl.FileTypeSupport.Filters.Excel</Source>
        <HResult>-2146233086</HResult>
        <StackTrace><![CDATA[   bij Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.WriterImpl.EndOfInput()
       bij Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.ExcelWriter.EndOfInput()
       bij Sdl.FileTypeSupport.Framework.Integration.NativeWriterMessagesProxy.EndOfInput()
       bij Sdl.FileTypeSupport.Framework.Integration.FileGenerator.CallEndOfInput()
       bij Sdl.FileTypeSupport.Framework.Integration.FileGenerator.FileComplete()
       bij Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
       bij Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.FileComplete()
       bij Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
       bij Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
       bij Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_Visit(TmfcReaderImpl* , FrameworkFileContainerField* field)
       bij FrameworkFileContainerField.vv_AcceptFrameworkVisitor(FrameworkFileContainerField* , FrameworkFieldVisitor* visitor)
       bij Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_VisitStartEndField(TmfcReaderImpl* , StartEndField* startEnd)
       bij Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.b_VisitNext(TmfcReaderImpl* )
       bij Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReader.ParseNext()
       bij Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ParseNext()
       bij Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.ParseNext()
       bij Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.Parse()
       bij Sdl.TranslationStudio.Editor.TranslationEditor.TranslatableDocument.SaveMonolingualAsJobRequest.Execute(IJobExecutionContext context)
       bij Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__3()
       bij Sdl.Desktop.Platform.Implementation.Services.Log.Resources(Object message, Action action)
       bij Sdl.Desktop.Platform.Implementation.Services.Job._worker_DoWork(Object sender, DoWorkEventArgs e)
       bij System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
       bij System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)]]></StackTrace>
      </Exception>
      <Environment>
        <ProductName>SDL Trados Studio</ProductName>
        <ProductVersion>12.0.0.0</ProductVersion>
        <EntryAssemblyFileVersion>12.2.5195.7</EntryAssemblyFileVersion>
        <OperatingSystem>Microsoft Windows 10 Pro</OperatingSystem>
        <ServicePack>NULL</ServicePack>
        <OperatingSystemLanguage>1043</OperatingSystemLanguage>
        <CodePage>1252</CodePage>
        <LoggedOnUser>DESKTOP-J11QPPD\Eric</LoggedOnUser>
        <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
        <ComputerName>DESKTOP-J11QPPD</ComputerName>
        <ConnectedToNetwork>True</ConnectedToNetwork>
        <PhysicalMemory>8282720 MB</PhysicalMemory>
      </Environment>
    </SDLErrorDetails>

    And the settings: Exported settings for MS Excel 2000-2003.zip

     

    Best regards,

    Eric

     

  • Hi Paul,

    I saw that the 1st sentence in the xml is in Dutch. I'll translate this for you:
    DUT: Failed to save target content: De index valt buiten het bereik. Deze mag niet negatief zijn en moet kleiner zijn dan de grootte van de verzameling.

    Parameternaam: index<

    EN: Failed to save target content: The index is out of the range. He can not be negative and must be smaller than the size of the collection (or set?).
    Parameter name: index<

    Best regards,
    Eric
  • Hi Paul,

    The customer sent me just a couple of minutes ago an updated version of that big spreadsheet, and I have to translate the updated cells by this Monday at the latest. Normally, my customer should send me once a month such updated spreadsheet...

    Should you not have a solution before then, I'll just copy/paste the translated cells like I did last time.

    Best regards,
    Eric
  • Hi Paul,

    Again spooky... I succeeded to save the translated spreadsheat with Save target as... as I usualy do. The ways of Windows are indeed mysterious...

    best regards,

    Eric
    emoji
  • Hi Eric,

    Apologies for the late response... I'd like to say I knew if I waited long enough it'd sort itself out ;-) But just got lucky!!

    Regards

    Paul

    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

  • I'm getting the exact same message if I try to start Trados, and Trados doesn't want to start.

    I've placed the files with the probable problem somewhere else, but Trados still doesn't want to start.

    It happened after the power of the motherboard shut off.

    emoji
  • The odd thing is, I get the error when I want to start Trados Studio 2022, but not with SDL Trados Studio 2021.

    I deleted 2021 en reinstalled it and can work in it. Afterwards, I deleted 2022 and reinstalled it, but I'm still getting the same error while starting up, and Trados 2022 doesnt want to work.

    For your information: the error is "De index valt buiten het bereik. Deze mag niet negatief zijn en moet kleiner zijn dan de grootte van de verzameling. Parameternaam: index"

    emoji
  • It turns out that the file of which I had to change the name, was in

    C:\Users\Peter\AppData\Roaming\Trados\Trados Studio

    and not in

    C:\Users\Peter\AppData\Roaming\SDL\SDL Trados Studio

    emoji