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
  •  

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

    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
Children