• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 8 replies
  • Answers 3 answers
  • Subscribers 434 subscribers
  • Views 4167 views
  • Users 0 members are here
Options
Related

Object reference not set to an instance of an object. XLS. Trados 2017

Odile Breuvart

 This is the error script I get. I understand many people have got problems with Saving file as target, I keep on getting the same problem with XLS; it had never happened before these last few days and I wish I knew why. Help anybody? Kind regards.

Fullscreen errorstack.xml Download 
<?xml version="1.0"?>
<SDLErrorDetails time="07/09/2017 10:13:54">
<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.TranslatableDocument.SaveMonolingualAsJobRequest.Execute(IJobExecutionContext context)
   at Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__3()
   at Sdl.Desktop.Platform.Implementation.Services.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)
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
  • 0
    Hi ,

    If you open the Excel file again as if it was a new translation project and immediately save the target, before you even translate it, does this work? If it doesn't then Studio has a problem with the file. If you can, then pretranslate the file from your TM and save target again. There's a good chance that will work.

    You might also find that opening the translated sdlxliff as if it was a new translatable file might also allow you to save the target.

    Regards

    Paul

    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

  • 0 in reply to Paul
    Thank you Paul. I have tried what you suggest. I feel there is an issue with timing. Things don't always get saved as quickly on different occasions. Sometimes I have a Target Save result that does not reflect the very last changes I have made but corresponds to something I have written a few minutes before.
  • 0 in reply to Paul
    I have been having the same problem with Excel files since upgrading to SDL Studio 2017 SR1.
    For some reason, it cannot seem to be able to generate XLSX files, unless I first convert them to XLS translate.
    It worked fine before.

    The work-around of opening the SDLXLIFF file as a new translatable file did not work either.

    The error message is the same as above.

    I am using SDL Studio 2017 SR1 and the latest version of Office 2016 (1707, Build 8326.2096).
  • 0 in reply to Odile Breuvart
    Hi ,

    This doesn't really make a lot of sense since the target file is created on the basis of what's in the sdlxliff. There is no mechanism for doing anything else. I don't know how experienced you are but I think it might be worth looking at the way you are working to get to the bottom of this. I can't do anything during the day at the moment but if you have time I'd be happy to schedule some time in the evenings (Central European Time). Drop me an email on pfilkin@sdl.com if you'd like to do this.

    Regards

    Paul

    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

  • 0 in reply to Alexandros Mouratidis
    Hi ,

    Can you share a screenshot of your project settings showing your filetypes? Can you also confirm which of the Excel filetypes is being used for your project? You can see this in the files view under the "Filetype Identifier" column.

    Thank you

    Paul

    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

  • 0 in reply to Paul
    I have used SDL products for about 10 years. My routine has always worked properly, including with xls files, but it is only since the beginning of September that I have had issues with xls files. I have copy pasted what the error message came up with at the time. I don't have the file anymore, but I can furnish evidence based on a recent project if you like. I will email you with more details.
  • 0 in reply to Paul
    Hello , I have the same problem with an Excel file. I have tried everything possible but impossible to generate the target file. As the deadline is aproaching, I am worried.

    Here is the error message:

    <?xml version="1.0"?>

    -<SDLErrorDetails time="04.01.2018 8:24:57">

    <ErrorMessage>Failed to save target content: Odkaz na objekt není nastaven na instanci objektu.</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[ v Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.UpdateDocumentFile(XsltArgumentList argsList, XslCompiledTransform xslTransform, XPathNavigator child)
    v Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.IterateXsltFiles(XsltArgumentList argsList, FileMap rule, XPathNodeIterator iter, Boolean isUpdate, String targetFilePath)
    v Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.IterateContentType(String xslFileNamesPath, Boolean isUpdate, String filePath, String filterStr, String targetFilePath, Boolean isCalledByRelsTableIteration)
    v Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.serviceBackward()
    v Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileParser.DocumentParser.Update()
    v Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileParser.DocumentExtractImpl.Update(DocumentCollection srcCollection, String filename, String tgtFilePath)
    v Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.WriterImpl.EndOfInput()
    v Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.ExcelWriter.EndOfInput()
    v Sdl.FileTypeSupport.Framework.Integration.NativeWriterMessagesProxy.EndOfInput()
    v Sdl.FileTypeSupport.Framework.Integration.FileGenerator.CallEndOfInput()
    v Sdl.FileTypeSupport.Framework.Integration.FileGenerator.FileComplete()
    v Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
    v Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.FileComplete()
    v Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
    v Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
    v Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_Visit(TmfcReaderImpl* , FrameworkFileContainerField* field)
    v FrameworkFileContainerField.vv_AcceptFrameworkVisitor(FrameworkFileContainerField* , FrameworkFieldVisitor* visitor)
    v Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_VisitStartEndField(TmfcReaderImpl* , StartEndField* startEnd)
    v Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.b_VisitNext(TmfcReaderImpl* )
    v Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReader.ParseNext()
    v Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ParseNext()
    v Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.ParseNext()
    v Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.Parse()
    v Sdl.TranslationStudio.Editor.TranslationEditor.TranslatableDocument.SaveMonolingualAsJobRequest.Execute(IJobExecutionContext context)
    v Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__3()
    v Sdl.Desktop.Platform.Implementation.Services.Log.Resources(Object message, Action action)
    v Sdl.Desktop.Platform.Implementation.Services.Job._worker_DoWork(Object sender, DoWorkEventArgs e)
    v System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
    v System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)]]>
    </StackTrace>

    </Exception>


    -<Environment>

    <ProductName>SDL Trados Studio</ProductName>

    <ProductVersion>12.0.0.0</ProductVersion>

    <EntryAssemblyFileVersion>12.3.5281.10</EntryAssemblyFileVersion>

    <OperatingSystem>Microsoft Windows 10 Home</OperatingSystem>

    <ServicePack>NULL</ServicePack>

    <OperatingSystemLanguage>1029</OperatingSystemLanguage>

    <CodePage>1250</CodePage>

    <LoggedOnUser>LIBOR\Libor</LoggedOnUser>

    <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>

    <ComputerName>LIBOR</ComputerName>

    <ConnectedToNetwork>True</ConnectedToNetwork>

    <PhysicalMemory>12463352 MB</PhysicalMemory>

    </Environment>

    </SDLErrorDetails>
  • 0 in reply to Libor Nenutil
    Hi ,

    Please open the source file for translation again and pretranslate from your TM. See if this helps.

    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