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

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

    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

    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