Microsoft Customization Error: Root Element Missing

Nov 3, 2014 at 8:31 PM
I have been running NodeXL for a couple of months and there has been no problems. Then one day, there was an error that a "root element is missing." I attempted to uninstall and then re-install the template, but when I went to open up the program, I had the same error message. The problem is very similar to what is discussed in this post:

https://nodexl.codeplex.com/discussions/85300

Using the directions provided, the problem was not solved.

Here is a copy of the error message below.

Thanks in advance,
David

************** Exception Text **************
System.Configuration.ConfigurationErrorsException: Root element is missing. (C:\Users\Administrator\AppData\Local\Apps\2.0\Data\X69Q9K8B.3MT\CBGVPY87.TGW\smrf..vsto_5b6b2c938fdf48d2_0001.0000_4299518baa97d826\Data\15.0.4641.1000\user.config) ---> System.Xml.XmlException: Root element is missing.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlTextReader.Read()
at System.Configuration.XmlUtil..ctor(Stream stream, String name, Boolean readToFirstElement, ConfigurationSchemaErrors schemaErrors)
at System.Configuration.BaseConfigurationRecord.InitConfigFromFile()
--- End of inner exception stack trace ---
at Smrf.NodeXL.ExcelTemplate.NodeXLApplicationSettingsBase.GetStandardSettingsFilePath()
at Smrf.NodeXL.ExcelTemplate.NodeXLApplicationSettingsBase.CreateStandardSettingsFolder(Boolean bAlsoCreateStandardSettingsFile)
at Smrf.NodeXL.ExcelTemplate.NodeXLApplicationSettingsBase.ReadStandardSettingsFile()
at Smrf.NodeXL.ExcelTemplate.NodeXLApplicationSettingsBase.OnNewWorkbook()
at Smrf.NodeXL.ExcelTemplate.ThisWorkbook.ThisWorkbook_Startup(Object sender, EventArgs e)
at Microsoft.Office.Tools.Excel.WorkbookImpl.OnStartup()
at Microsoft.Office.Tools.Excel.WorkbookImpl.WorkbookExtensionImpl.Microsoft.Office.Tools.EntryPoint.OnStartup()
at Microsoft.Office.Tools.Excel.WorkbookBase.OnStartup()
at Smrf.NodeXL.ExcelTemplate.ThisWorkbook.FinishInitialization()
at Microsoft.Office.Tools.Excel.WorkbookBase.Microsoft.Office.Tools.EntryPoint.FinishInitialization()
at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.ExecutePhase(ExecutionPhases executionPhases)
at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IExecuteCustomization2.ExecuteEntryPoints()


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34014 built by: FX45W81RTMGDR

CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34003 built by: FX45W81RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

Microsoft.VisualStudio.Tools.Office.Runtime
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50701.0

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.dll

Microsoft.Office.Tools
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50701.0

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.dll

Microsoft.VisualStudio.Tools.Applications.Runtime
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50701.0

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.dll

System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

Microsoft.Office.Tools.Excel.Implementation
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50701.0

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel.Implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.Implementation.dll

Microsoft.Office.Tools.Common.Implementation
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50701.0

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Common.Implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.Implementation.dll

Microsoft.Office.Tools.Excel
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50701.0

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.dll

Microsoft.VisualStudio.Tools.Applications.ServerDocument
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50701.0

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.dll

System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

Smrf.NodeXL.ExcelTemplate
Assembly Version: 1.0.1.334
Win32 Version: 1.0.1.334

CodeBase: file:///C:/Users/Administrator/AppData/Local/Apps/2.0/6AG4LXG4.XD6/YYQGKG3K.ZPT/smrf..vsto_5b6b2c938fdf48d2_0001.0000_4299518baa97d826/Smrf.NodeXL.ExcelTemplate.DLL

Microsoft.Office.Tools.Excel.v4.0.Utilities
Assembly Version: 10.0.0.0
Win32 Version: 10.0.30319.1

CodeBase: file:///C:/Users/Administrator/AppData/Local/Apps/2.0/6AG4LXG4.XD6/YYQGKG3K.ZPT/smrf..vsto_5b6b2c938fdf48d2_0001.0000_4299518baa97d826/Microsoft.Office.Tools.Excel.v4.0.Utilities.DLL

System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.Office.Tools.Common
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50701.0

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Common/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.dll

Microsoft.Office.Tools.Common.v4.0.Utilities
Assembly Version: 10.0.0.0
Win32 Version: 10.0.30319.1

CodeBase: file:///C:/Users/Administrator/AppData/Local/Apps/2.0/6AG4LXG4.XD6/YYQGKG3K.ZPT/smrf..vsto_5b6b2c938fdf48d2_0001.0000_4299518baa97d826/Microsoft.Office.Tools.Common.v4.0.Utilities.DLL

Smrf.NodeXL.ApplicationUtil
Assembly Version: 1.0.1.334
Win32 Version: 1.0.1.334

CodeBase: file:///C:/Users/Administrator/AppData/Local/Apps/2.0/6AG4LXG4.XD6/YYQGKG3K.ZPT/smrf..vsto_5b6b2c938fdf48d2_0001.0000_4299518baa97d826/Smrf.NodeXL.ApplicationUtil.DLL

Smrf.NodeXL.Core
Assembly Version: 1.0.1.334
Win32 Version: 1.0.1.334

CodeBase: file:///C:/Users/Administrator/AppData/Local/Apps/2.0/6AG4LXG4.XD6/YYQGKG3K.ZPT/smrf..vsto_5b6b2c938fdf48d2_0001.0000_4299518baa97d826/Smrf.NodeXL.Core.DLL

Smrf.NodeXL.Visualization.Wpf
Assembly Version: 1.0.1.334
Win32 Version: 1.0.1.334

CodeBase: file:///C:/Users/Administrator/AppData/Local/Apps/2.0/6AG4LXG4.XD6/YYQGKG3K.ZPT/smrf..vsto_5b6b2c938fdf48d2_0001.0000_4299518baa97d826/Smrf.NodeXL.Visualization.Wpf.DLL

Smrf.NodeXL.Util
Assembly Version: 1.0.1.334
Win32 Version: 1.0.1.334

CodeBase: file:///C:/Users/Administrator/AppData/Local/Apps/2.0/6AG4LXG4.XD6/YYQGKG3K.ZPT/smrf..vsto_5b6b2c938fdf48d2_0001.0000_4299518baa97d826/Smrf.NodeXL.Util.DLL

Microsoft.CSharp
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.33440

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll

System.Dynamic
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.33440

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Dynamic/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Dynamic.dll

Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.0.30319.34014 built by: FX45W81RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll

System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
Coordinator
Nov 3, 2014 at 10:55 PM
Hi David,

This is a corruption of the user options file. One way this can happen is if you simultaneously run multiple instances of NodeXL; there may be other ways, too.

The fix is to close all instances of Excel and then delete the user options file, which in your case is here:

C:\Users\Administrator\AppData\Local\Apps\2.0\Data\X69Q9K8B.3MT\CBGVPY87.TGW\smrf..vsto_5b6b2c938fdf48d2_0001.0000_4299518baa97d826\Data\15.0.4641.1000\user.config

NodeXL will automatically recreate the user options file when it's restarted.

Regards,
Arber
Nov 7, 2014 at 6:28 PM
That was able to solve the problem. Thank you!