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
  • Hello Eric,

    I opened your sdlxliff and saved the excel target without any error messages.  However the file doesn't look right to me.  So, can you please provide the following:

    1. Attach the proper error stack (just add the xml error stack as an xml file... please don't zip it first)
    2. Export your settings for the Excel filetype and attach the settings file here too (you can zip that one)

    Thank you

    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

  • Hi Paul,

    Sorry for my late reply (deadlines again...).

    What do you mean with "Attach the proper error stack (just add the xml error stack as an xml file... "? Where can I find this?

    Best regards,
    Eric
  • Hello Paul,

    Could it be that you missed my last question of how to find the "proper error stack"?

    Best regards,

    Eric
  • Yes I did... sorry!  You need to get to the error details:

    This will give you the error message where you can get at the stack.  You then save the xml file like this:

    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

  • 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
Reply Children