• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 12 replies
  • Answers 2 answers
  • Subscribers 434 subscribers
  • Views 4996 views
  • Users 0 members are here
Options
Related

Error while generating target translation

Eric Wouters

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
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
  • 0

    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

  • 0 in reply to Paul
    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
  • 0 in reply to Eric Wouters
    Hello Paul,

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

    Best regards,

    Eric
  • 0 in reply to Eric Wouters

    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

  • 0 in reply to Paul

    Hi Paul,

    Thank you again for your fast reply.

    Please find attached the exported error messages file: 

    Fullscreen sdlerror-2017321-13h39m15s.sdlerror.xml Download 
    <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

     
  • 0 in reply to Eric Wouters
    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
  • 0 in reply to Eric Wouters
    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
  • +1 in reply to Eric Wouters
    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
  • 0 in reply to Eric Wouters
    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

  • 0 in reply to Eric Wouters

    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