• State Suggested Answer
  • Replies 6 replies
  • Answers 1 answer
  • Subscribers 432 subscribers
  • Views 2136 views
  • Users 0 members are here
Options
Related

Failed to save target content: object reference not set to an instance of an object

Martha Fillastre

Dear all,

I translated a PowerPoint file with Studio 2019. When I try to save the target file as a PowerPoint file, I get the above message.

The file has embedded excel files which are not visible, and which I did not translate, so I guess that might be causing the error.

The details of the message, with the XML link, are as follows

Can anyone help with this? The answers I've seem don't seem to correspond exactly.

Thanks in advance

Martha

: 

Type   System.NullReferenceException, mscorlib, Version=4.0

HelpL

Source  Sdl FileTypeSupport.Filters.MicrosoftOffice.Excel_2

HResult   -2147467261

Stacktrace

<SDLErrorDetails time="21/11/2022 17:05: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.MicrosoftOffice.Excel_2</Source>
    <HResult>-2147467261</HResult>
    <StackTrace><![CDATA[   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.PivotTables.CacheFieldRoute.BuildCacheFieldExtendedCellReference(CellReference cacheFieldCell)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.PivotTables.CacheFieldRoute.WriteUpdatedCacheFieldName(Entity entity)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.PivotTables.CacheFieldRoute.Handle(Entity entity)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Routes.DispatchRoute.Dispatch(Entity entity)
   at lambda_method(Closure , IMessage )
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Infrastructure.Dispatcher.Publish(IMessage message)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Services.ParserService.Publish(Entity parsedEntity)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Services.ParserService.Parse()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Parser.DispatchingParserService.Process(Func`1 inputStreamFactory, IDispatcherConfiguration dispatcherConfiguration)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Infrastructure.TargetFileWriter.WriteTargetFile(String sourceFilePath, String targetFilePath, IDispatcherConfiguration dispatcherConfiguration, Action`1 markupWriterSetter)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.PivotTables.PivotTablesWriter.WritePivotCaches()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.PivotTables.PivotTablesWriter.Execute()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Archive.ArchiveWriter.WriteArchiveParts()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Archive.ArchiveWriter.Process(WriterInformation writerInformation)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.XlsxWriter.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
   at Sdl.FileTypeSupport.Framework.Integration.SubContentGenerator.FileComplete()
   at Sdl.FileTypeSupport.Framework.Integration.FileGenerator.SetFileProperties(IFileProperties fileInfo)
   at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.SetFileProperties(IFileProperties fileInfo)
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.SetFileProperties(IFileProperties fileInfo)
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.SetFileProperties(IFileProperties fileInfo)
   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.8.3007</EntryAssemblyFileVersion>
    <OperatingSystem>Microsoft Windows 10 Professionnel</OperatingSystem>
    <ServicePack>NULL</ServicePack>
    <OperatingSystemLanguage>1036</OperatingSystemLanguage>
    <CodePage>1252</CodePage>
    <LoggedOnUser>THINKPAD\Martha</LoggedOnUser>
    <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
    <ComputerName>THINKPAD</ComputerName>
    <ConnectedToNetwork>True</ConnectedToNetwork>
    <PhysicalMemory>16627276 MB</PhysicalMemory>
  </Environment>
</SDLErrorDetails>

Moved stack to a code block.
[edited by: Paul at 11:27 PM (GMT 0) on 21 Nov 2022]
emoji
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0

     

    I think you may be right about the embedded Excel.  But can you try this:

    1. create a new project with the powerpoint
    2. pre-translate from your TM
    3. immediately try to save the target file

    See if that helps.

    You could also try saving the source Powerpoint as a different type of file (ppt vs pptx for example) and see if this helps.  If it doesn't, and if you are able to send me your source Powerpoint file, and your fully translated SDLXLIFF, then I'd be happy to take a look and see if I can get the target file out.  You can send them to pfilkin at sdl dotcom if it's ok.

    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
  • 0 in reply to Paul

    Hello Paul,

    Sorry for not replying at once. I had a deadline to meet (and this didn't make things easier!). 
    I tried all your solutions but they didn't work. I finally deleted the slides with the embedded Excel files (luckily there were only three of them) and added them back and translated them manually after my translation. I'm sending you my files just in case you can get something out of them. Thanks for your help
    emoji
  • 0 in reply to Martha Fillastre

      

    Thanks for sending me your file.  I used the "divide and conquer" technique to find which part of the Powerpoint was causing a problem as I could reproduce your error on a new project even without translating the file, and I was also using 2022.

    So I split the file, tested both halves.  One failed so I split that one and repeated the process.  After a few goes I identified one slide, so I then started to remove parts of the content and tested again.  The problem was related to one table on that slide.  So removing the table allowed me to pre-translate from your sdlxliff, save the target, and get a translated file out.

    I sent you the translated file, and if you agree I'll provide the slide with only the table on it to our development team for resolution and improvement of the filetype.

    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
Reply
  • 0 in reply to Martha Fillastre

      

    Thanks for sending me your file.  I used the "divide and conquer" technique to find which part of the Powerpoint was causing a problem as I could reproduce your error on a new project even without translating the file, and I was also using 2022.

    So I split the file, tested both halves.  One failed so I split that one and repeated the process.  After a few goes I identified one slide, so I then started to remove parts of the content and tested again.  The problem was related to one table on that slide.  So removing the table allowed me to pre-translate from your sdlxliff, save the target, and get a translated file out.

    I sent you the translated file, and if you agree I'll provide the slide with only the table on it to our development team for resolution and improvement of the filetype.

    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
Children