• State Verified Answer
  • Replies 21 replies
  • Answers 2 answers
  • Subscribers 432 subscribers
  • Views 5342 views
  • Users 0 members are here
Options
Related

After translating simple, monolingual excel-file, I cannot save the target file. I get the error message "Failed to save target content: Object reference not set to an instance of an object"

DGS

Hi,

I'm using Trados Studio 2019 and Excel 2016.

I tried the following: unblocked segments, merged splitted ones, I changend File Types order (MS Excel 2007-2016 before Excel 97-2003),  I erased 15.0.0.0 folder in User > App Data > Roaming >  SDL > Sdl Trados Studio. I don't know what I should check or change in WSN+ segment).

The file is very large and has many identical segments which have to be translated differentely in different parts; so, It would take me days to retranslate it.

Can you help.

Thank you.

DG
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents Reply Children
  • 0 in reply to Daniel Hug

    Hi Daniel,

    I have the following checked:

    Headers and footers

    Sheet names

    and in Other settings:

    Skip caracter spacing and kerning

    Retan Studio target comments in target file

    I could also send the error file, if you tell me how.

    Thank you,

    Diana
  • +1 in reply to DGS

    Hi

    You can post the error file (the "stack trace") like this:

    Error dialog box in Trados Studio with red arrows pointing to 'Click here' button and 'Advanced Editing Options'.

    (This is SDL's official image, which I grabbed from another thread.)

    I share 's suspicion about Worksheet names.

    What do the target segments of the worksheet names look like? You can get Studio to only show those lines by using the Advanced Display Filter:

    Trados Studio Advanced Display Filter with red circles highlighting 'Clear' button and filter options for target segments.

    I'd make sure to copy all source segment values to the target segments for the worksheet names.

    Once you're done, just click on "Clear" in the Advanced Display Filter.

    Does that help?

    Daniel
    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 5:44 PM (GMT 0) on 28 Feb 2024]
  • 0 in reply to Daniel Hug

    Hi again,

    The error file contents are:

    Fullscreen 5736.errors_4_community.xml Download 
    <SDLErrorDetails time="12/08/2019 14:15:55">
<ErrorMessage>Failed to save target content: Object reference not set to an instance of an object.</ErrorMessage>
<Exception>
<Type>System.NullReferenceException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</Type>
<HelpLink />
<Source>Sdl.FileTypeSupport.Filters.Excel</Source>
<HResult>-2147467261</HResult>
<StackTrace><![CDATA[ at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.UpdateDocumentFile(XsltArgumentList argsList, XslCompiledTransform xslTransform, XPathNavigator child)
at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.IterateXsltFiles(XsltArgumentList argsList, FileMap rule, XPathNodeIterator iter, Boolean isUpdate, String targetFilePath)
at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.IterateContentType(String xslFileNamesPath, Boolean isUpdate, String filePath, String filterStr, String targetFilePath, Boolean isCalledByRelsTableIteration)
at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.serviceBackward()
at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileParser.DocumentParser.Update()
at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileParser.DocumentExtractImpl.Update(DocumentCollection srcCollection, String filename, String tgtFilePath)
at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.WriterImpl.EndOfInput()
at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.ExcelWriter.EndOfInput()
at Sdl.FileTypeSupport.Framework.Integration.NativeWriterMessagesProxy.EndOfInput()
at Sdl.FileTypeSupport.Framework.Integration.FileGenerator.CallEndOfInput()
at Sdl.FileTypeSupport.Framework.Integration.FileGenerator.FileComplete()
at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.FileComplete()
at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_Visit(TmfcReaderImpl* , FrameworkFileContainerField* field)
at FrameworkFileContainerField.vv_AcceptFrameworkVisitor(FrameworkFileContainerField* , FrameworkFieldVisitor* visitor)
at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_VisitStartEndField(TmfcReaderImpl* , StartEndField* startEnd)
at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.b_VisitNext(TmfcReaderImpl* )
at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReader.ParseNext()
at Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ParseNext()
at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.ParseNext()
at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.Parse()
at Sdl.TranslationStudio.Editor.TranslationEditor.SaveMonolingualAsJobRequest.Execute(IJobExecutionContext context)
at Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__47_0()
at Sdl.Desktop.Logger.Log.Resources(Object message, Action action)
at Sdl.Desktop.Platform.Implementation.Services.Job._worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)]]></StackTrace>
</Exception>
<Environment>
<ProductName>SDL Trados Studio</ProductName>
<ProductVersion>15.0.0.0</ProductVersion>
<EntryAssemblyFileVersion>15.2.0.1041</EntryAssemblyFileVersion>
<OperatingSystem>Microsoft Windows 10 Home</OperatingSystem>
<ServicePack>NULL</ServicePack>
<OperatingSystemLanguage>3082</OperatingSystemLanguage>
<CodePage>1252</CodePage>
<LoggedOnUser>Diana\DianaG</LoggedOnUser>
<DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
<ComputerName>DIANA</ComputerName>
<ConnectedToNetwork>True</ConnectedToNetwork>
<PhysicalMemory>6171384 MB</PhysicalMemory>
</Environment>
</SDLErrorDetails>

    And there's only one sheet and after filtering it looks like this:Screenshot of Trados Studio error message 'Failed to save target content: Object reference not set to an instance of an object.' with details of the System.NullReferenceException error and environment information including product name, version, operating system, and user details.


    Generated Image Alt-Text
    [edited by: Trados AI at 5:44 PM (GMT 0) on 28 Feb 2024]
  • 0 in reply to Daniel Hug

    My reply was considered "abusive" by the system. I'll try again (not including the error file contents and Trados Studio image after filtering).

    There's only one Sheet and after filtering I can see Sheet1 in both the English and the target side. I Copied Source in that segment.
  • 0 in reply to DGS

    Hi agai,

    Also I saved a *.sdladfsettings file, which I don't know how to send or check.

    Thanks in advance.

    Diana
  • +1 in reply to DGS

    You should be able to paste screenshots into these posts.

    FIles should be zipped (covert to a zip archive).
  • +1 in reply to Daniel Hug

    ... and if you use the @ character and type the recipient's name afterwards without a space, the person will get a notification, :

    Screenshot showing the use of @ character followed by 'DGS (DianaGibson Scarpati)' without a space to trigger a notification in Trados Studio.
    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 5:44 PM (GMT 0) on 28 Feb 2024]
  • +1 in reply to DGS

    Hi

    The settings file contained Advanced Display Filter settings...

    I can't see from the stack trace what the problem is, but somebody with more expertise might well be able to. The old Excel filter type was a bit error-prone, but the 2016 is not.

    Did you read this: https://multifarious.filkin.com/2019/01/09/wot-no-target/

    I am quite sure you don't have to translate the whole project again. There are many options before that.

    1. If you have the Professional version of Studio, you can do PerfectMatch, which did the job in my little test file (3 source segments with the same value but different translations):

    Screenshot of Trados Studio Advanced Display Filter settings showing a list of languages with no visible errors or warnings.

    Second project with the same source file, using the sdlxliff of the first project as bilingual match source:

    Screenshot of Trados Studio with red error lines under 'French' and 'Arabic' languages in the Advanced Display Filter settings indicating a problem.

    2. There is a free app on the SDL AppStore called "Export to Excel". Maybe this is useful in your case although you can't re-import.

    Daniel
    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 5:45 PM (GMT 0) on 28 Feb 2024]
  • 0 in reply to Daniel Hug

    Hi again,

    I don't have the professional version. I'll try the app.

    Thank your for your help.

    Best regards,

    Diana