Index Out Of Range error message while translating Excel file

I'm getting the common "Index Out Of Range" message while translating an Excel file. I think it occurs pretty much only where there is a segment containing measures, like it messes with Trados' understanding somehow? When that happens, the translation memory results continue to appear, but without any identification, and they can't be used with the shortcut Ctrl+1/2/3...

Screenshot of error Message appearing after confirming segment 125 and arriving on segment 126 (which contains measures):

Error message in Trados Studio 'Index Out Of Range' after confirming segment 125, with segment 126 containing measures displayed in the background.

Here is the source file:

Daily Products 2024-01-12.xlsx

And here are some of the parameters:

Trados Studio project settings window showing translation memory and automated translation providers for English to French.

Trados Studio file types settings window with a list of supported file extensions and their corresponding file type configurations.



Generated Image Alt-Text
[edited by: Trados AI at 1:22 PM (GMT 0) on 29 Feb 2024]
emoji
Parents
  •  

    Can you share the full error message please?  Just click on the disk, save to your desktop and then attach the xml file you saved to your reply:

    The image displays a dialog box with a French error message from a software application. The dialog box's title is "Erreur" which translates to "Error". The message in the dialog box says "L'index était hors limites. Il ne doit pas être négatif et doit être inférieur à la taille de la collection. Nom du paramètre : index", which translates to "The index was out of bounds. It must not be negative and must be smaller than the size of the collection. Parameter name: index". This suggests that an operation was attempted on a collection with an index that is outside the valid range. It is likely an issue with array or list handling in the code, where an index is either less than zero or greater than the maximum allowed index for the collection.  At the bottom left corner of the dialog box, there's an icon resembling a book or pages, which probably indicates a reference to further information or documentation. The label next to this icon says "Pour connaissances: Communauté", which translates to "For knowledge: Community". This likely suggests that the user can seek additional help from the community or knowledge base.

    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
  • Hi Paul, here is the xml of the error message. Not for the same source file, but it's the same type of content.

    <SDLErrorDetails time="2024-01-16 14:01:13">
      <ErrorMessage>L'index était hors limites. Il ne doit pas être négatif et doit être inférieur à la taille de la collection.
    Nom du paramètre : 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[   à System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
       à Sdl.TranslationStudio.Editor.TranslationMemory.TranslationMemoryViewPartControl.ShowDocumentSource(List`1 placeables, EditDistance editDistanceInformation, Segment tuSourceSegment, Segment tokenizedDocumentSourceSegment)
       à Sdl.TranslationStudio.Editor.TranslationMemory.TranslationMemoryViewPartControl.ShowDocumentSource()
       à Sdl.TranslationStudio.Editor.TranslationMemory.TranslationMemoryViewPartControl.TranslationMemoryViewPartControl_CurrentSearchResultChanged(Object sender, EventArgs e)
       à System.EventHandler.Invoke(Object sender, EventArgs e)
       à Sdl.TranslationStudio.Editor.TranslationMemory.CompoundTranslationMemorySearchResultsControl._searchResultsControl_CurrentTranslationUnitChanged(Object sender, EventArgs e)
       à System.EventHandler.Invoke(Object sender, EventArgs e)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.OnCurrentTranslationUnitChanged()
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.HandleActiveRowChanged(ActiveRowChangedEventArgs e)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.Source_ActiveRowChanged(Object sender, ActiveRowChangedEventArgs e)
       à System.EventHandler`1.Invoke(Object sender, TEventArgs e)
       à AbstractFrameworkEditControl.raise_ActiveRowChanged(Object value0, ActiveRowChangedEventArgs value1)
       à AbstractFrameworkEditControl.OnActiveRowChanged(Object sender, ActiveRowChangedEventArgs args)
       à AbstractFrameworkEditControl.set_ActiveRow(IRowInfo activeRow)
       à Sdl.DesktopEditor.Control.Support.RowInfo.set_Active(Boolean value)
       à SideBySideEditor.set_ActiveRowNumber(Int32 rowNumber)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.set_CurrentTranslationUnitIndex(Int32 value)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.SideBySideEditor_AfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs e)
       à SideBySideEditor.raise_AfterInitialUpdate(Object value0, AfterInitialUpdateEventArgs value1)
       à SideBySideEditor.OnAfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs args)
       à SideBySideEditor.Target_AfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs args)
       à AbstractFrameworkEditControl.raise_AfterInitialUpdate(Object value0, AfterInitialUpdateEventArgs value1)
       à AbstractFrameworkEditControl.OnAfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs args)
       à FrameworkEditControlEventSource.AfterInitialUpdate(FrameworkEditControlEventSource* )
       à Tree.DocumentControl.vl_WindowProc(DocumentControl* , HWND__* , UInt32 , UInt32 , Int32 )
       à FrameworkDocumentControl.vl_WindowProc(FrameworkDocumentControl* , HWND__* h_wnd, UInt32 n_msg, UInt32 w_p, Int32 l_p)
       à System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
       à System.Windows.Forms.NativeWindow.DefWndProc(Message& m)
       à System.Windows.Forms.Control.DefWndProc(Message& m)
       à System.Windows.Forms.Control.WndProc(Message& m)
       à System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)]]></StackTrace>
      </Exception>
      <Environment>
        <ProductName>Trados Studio</ProductName>
        <ProductVersion>Studio17</ProductVersion>
        <EntryAssemblyFileVersion>17.2.9.18688</EntryAssemblyFileVersion>
        <OperatingSystem>Microsoft Windows 10 Famille</OperatingSystem>
        <ServicePack>NULL</ServicePack>
        <OperatingSystemLanguage>1033</OperatingSystemLanguage>
        <CodePage>1252</CodePage>
        <LoggedOnUser>DESKTOP-66C33AU\mguay</LoggedOnUser>
        <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
        <ComputerName>DESKTOP-66C33AU</ComputerName>
        <ConnectedToNetwork>True</ConnectedToNetwork>
        <PhysicalMemory>8249836 MB</PhysicalMemory>
      </Environment>
    </SDLErrorDetails>

    emoji
  •  

    The error occurred in the method ShowDocumentSource of the class TranslationMemoryViewPartControl.  This method is probably responsible for displaying the document source in the Translation Memory View.  I suggest you try a reset.

    To do this just close Trados Studio and then rename this folder:

    c:\Users\%username%\AppData\Roaming\Trados\Trados Studio\Studio17\

    to c:\Users\%username%\AppData\Roaming\Trados\Trados Studio\Studio17_old\

    If you can't find this folder then you need to unhide your hidden files/folders:

    www.howtogeek.com/.../

    Then restart Trados Studio and see if that helped.

    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
  • So we tried that and it seemed to be OK for a few days, but it did it again yesterday (see attached, it was when arriving on segment 130).

    Error message in Trados Studio indicating 'L'index etait hors limites. Il ne doit pas etre negatif et doit etre inferieur a la taille de la collection. Nom du parametre: index'.

    Trados Studio screenshot showing an error dialog box over a segment list, with segment 130 highlighted and an error message about index being out of range.

    <SDLErrorDetails time="2024-01-24 10:40:26">
      <ErrorMessage>L'index était hors limites. Il ne doit pas être négatif et doit être inférieur à la taille de la collection.
    Nom du paramètre : 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[   à System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
       à Sdl.TranslationStudio.Editor.TranslationMemory.TranslationMemoryViewPartControl.ShowDocumentSource(List`1 placeables, EditDistance editDistanceInformation, Segment tuSourceSegment, Segment tokenizedDocumentSourceSegment)
       à Sdl.TranslationStudio.Editor.TranslationMemory.TranslationMemoryViewPartControl.ShowDocumentSource()
       à Sdl.TranslationStudio.Editor.TranslationMemory.TranslationMemoryViewPartControl.TranslationMemoryViewPartControl_CurrentSearchResultChanged(Object sender, EventArgs e)
       à System.EventHandler.Invoke(Object sender, EventArgs e)
       à Sdl.TranslationStudio.Editor.TranslationMemory.CompoundTranslationMemorySearchResultsControl._searchResultsControl_CurrentTranslationUnitChanged(Object sender, EventArgs e)
       à System.EventHandler.Invoke(Object sender, EventArgs e)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.OnCurrentTranslationUnitChanged()
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.HandleActiveRowChanged(ActiveRowChangedEventArgs e)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.Source_ActiveRowChanged(Object sender, ActiveRowChangedEventArgs e)
       à System.EventHandler`1.Invoke(Object sender, TEventArgs e)
       à AbstractFrameworkEditControl.raise_ActiveRowChanged(Object value0, ActiveRowChangedEventArgs value1)
       à AbstractFrameworkEditControl.OnActiveRowChanged(Object sender, ActiveRowChangedEventArgs args)
       à AbstractFrameworkEditControl.set_ActiveRow(IRowInfo activeRow)
       à Sdl.DesktopEditor.Control.Support.RowInfo.set_Active(Boolean value)
       à SideBySideEditor.set_ActiveRowNumber(Int32 rowNumber)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.set_CurrentTranslationUnitIndex(Int32 value)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.SideBySideEditor_AfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs e)
       à SideBySideEditor.raise_AfterInitialUpdate(Object value0, AfterInitialUpdateEventArgs value1)
       à SideBySideEditor.OnAfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs args)
       à SideBySideEditor.Target_AfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs args)
       à AbstractFrameworkEditControl.raise_AfterInitialUpdate(Object value0, AfterInitialUpdateEventArgs value1)
       à AbstractFrameworkEditControl.OnAfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs args)
       à FrameworkEditControlEventSource.AfterInitialUpdate(FrameworkEditControlEventSource* )
       à Tree.DocumentControl.vl_WindowProc(DocumentControl* , HWND__* , UInt32 , UInt32 , Int32 )
       à FrameworkDocumentControl.vl_WindowProc(FrameworkDocumentControl* , HWND__* h_wnd, UInt32 n_msg, UInt32 w_p, Int32 l_p)
       à System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
       à System.Windows.Forms.NativeWindow.DefWndProc(Message& m)
       à System.Windows.Forms.Control.DefWndProc(Message& m)
       à System.Windows.Forms.Control.WndProc(Message& m)
       à System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)]]></StackTrace>
      </Exception>
      <Environment>
        <ProductName>Trados Studio</ProductName>
        <ProductVersion>Studio17</ProductVersion>
        <EntryAssemblyFileVersion>17.2.9.18688</EntryAssemblyFileVersion>
        <OperatingSystem>Microsoft Windows 10 Famille</OperatingSystem>
        <ServicePack>NULL</ServicePack>
        <OperatingSystemLanguage>1033</OperatingSystemLanguage>
        <CodePage>1252</CodePage>
        <LoggedOnUser>DESKTOP-66C33AU\mguay</LoggedOnUser>
        <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
        <ComputerName>DESKTOP-66C33AU</ComputerName>
        <ConnectedToNetwork>True</ConnectedToNetwork>
        <PhysicalMemory>8249836 MB</PhysicalMemory>
      </Environment>
    </SDLErrorDetails>

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 1:22 PM (GMT 0) on 29 Feb 2024]
Reply
  • So we tried that and it seemed to be OK for a few days, but it did it again yesterday (see attached, it was when arriving on segment 130).

    Error message in Trados Studio indicating 'L'index etait hors limites. Il ne doit pas etre negatif et doit etre inferieur a la taille de la collection. Nom du parametre: index'.

    Trados Studio screenshot showing an error dialog box over a segment list, with segment 130 highlighted and an error message about index being out of range.

    <SDLErrorDetails time="2024-01-24 10:40:26">
      <ErrorMessage>L'index était hors limites. Il ne doit pas être négatif et doit être inférieur à la taille de la collection.
    Nom du paramètre : 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[   à System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
       à Sdl.TranslationStudio.Editor.TranslationMemory.TranslationMemoryViewPartControl.ShowDocumentSource(List`1 placeables, EditDistance editDistanceInformation, Segment tuSourceSegment, Segment tokenizedDocumentSourceSegment)
       à Sdl.TranslationStudio.Editor.TranslationMemory.TranslationMemoryViewPartControl.ShowDocumentSource()
       à Sdl.TranslationStudio.Editor.TranslationMemory.TranslationMemoryViewPartControl.TranslationMemoryViewPartControl_CurrentSearchResultChanged(Object sender, EventArgs e)
       à System.EventHandler.Invoke(Object sender, EventArgs e)
       à Sdl.TranslationStudio.Editor.TranslationMemory.CompoundTranslationMemorySearchResultsControl._searchResultsControl_CurrentTranslationUnitChanged(Object sender, EventArgs e)
       à System.EventHandler.Invoke(Object sender, EventArgs e)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.OnCurrentTranslationUnitChanged()
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.HandleActiveRowChanged(ActiveRowChangedEventArgs e)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.Source_ActiveRowChanged(Object sender, ActiveRowChangedEventArgs e)
       à System.EventHandler`1.Invoke(Object sender, TEventArgs e)
       à AbstractFrameworkEditControl.raise_ActiveRowChanged(Object value0, ActiveRowChangedEventArgs value1)
       à AbstractFrameworkEditControl.OnActiveRowChanged(Object sender, ActiveRowChangedEventArgs args)
       à AbstractFrameworkEditControl.set_ActiveRow(IRowInfo activeRow)
       à Sdl.DesktopEditor.Control.Support.RowInfo.set_Active(Boolean value)
       à SideBySideEditor.set_ActiveRowNumber(Int32 rowNumber)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.set_CurrentTranslationUnitIndex(Int32 value)
       à Sdl.TranslationStudio.Common.TranslationMemory.AbstractTranslationMemoryControl`1.SideBySideEditor_AfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs e)
       à SideBySideEditor.raise_AfterInitialUpdate(Object value0, AfterInitialUpdateEventArgs value1)
       à SideBySideEditor.OnAfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs args)
       à SideBySideEditor.Target_AfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs args)
       à AbstractFrameworkEditControl.raise_AfterInitialUpdate(Object value0, AfterInitialUpdateEventArgs value1)
       à AbstractFrameworkEditControl.OnAfterInitialUpdate(Object sender, AfterInitialUpdateEventArgs args)
       à FrameworkEditControlEventSource.AfterInitialUpdate(FrameworkEditControlEventSource* )
       à Tree.DocumentControl.vl_WindowProc(DocumentControl* , HWND__* , UInt32 , UInt32 , Int32 )
       à FrameworkDocumentControl.vl_WindowProc(FrameworkDocumentControl* , HWND__* h_wnd, UInt32 n_msg, UInt32 w_p, Int32 l_p)
       à System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
       à System.Windows.Forms.NativeWindow.DefWndProc(Message& m)
       à System.Windows.Forms.Control.DefWndProc(Message& m)
       à System.Windows.Forms.Control.WndProc(Message& m)
       à System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)]]></StackTrace>
      </Exception>
      <Environment>
        <ProductName>Trados Studio</ProductName>
        <ProductVersion>Studio17</ProductVersion>
        <EntryAssemblyFileVersion>17.2.9.18688</EntryAssemblyFileVersion>
        <OperatingSystem>Microsoft Windows 10 Famille</OperatingSystem>
        <ServicePack>NULL</ServicePack>
        <OperatingSystemLanguage>1033</OperatingSystemLanguage>
        <CodePage>1252</CodePage>
        <LoggedOnUser>DESKTOP-66C33AU\mguay</LoggedOnUser>
        <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
        <ComputerName>DESKTOP-66C33AU</ComputerName>
        <ConnectedToNetwork>True</ConnectedToNetwork>
        <PhysicalMemory>8249836 MB</PhysicalMemory>
      </Environment>
    </SDLErrorDetails>

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 1:22 PM (GMT 0) on 29 Feb 2024]
Children
No Data