CanNOT start NodeXL - Error message

Jun 27, 2012 at 2:12 AM

I get the following error message and NodeXL won't open. Please advise...!

************** Exception Text **************System.Configuration.ConfigurationErrorsException: The 'LayoutUserSettings' start tag on line 208 does not match the end tag of 'LayooutUserSettings'. Line 233, position 7. (C:\Users\abc\AppData\Local\Apps\2.0\Data\36P2XWAL.GJC\M02QCXKJ.TCE\smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7\Data\14.0.6117.5003\user.config line 233) ---> System.Xml.XmlException: The 'LayoutUserSettings' start tag on line 208 does not match the end tag of 'LayooutUserSettings'. Line 233, position 7.   at System.Xml.XmlTextReaderImpl.Throw(Exception e)   at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)   at System.Xml.XmlTextReaderImpl.ThrowTagMismatch(NodeData startTag)   at System.Xml.XmlTextReaderImpl.ParseEndElement()   at System.Xml.XmlTextReaderImpl.ParseElementContent()   at System.Xml.XmlTextReaderImpl.Read()   at System.Xml.XmlTextReader.Read()   at System.Xml.XmlTextReaderImpl.Skip()   at System.Xml.XmlTextReader.Skip()   at System.Configuration.XmlUtil.StrictSkipToNextElement(ExceptionAction action)   at System.Configuration.BaseConfigurationRecord.ScanSectionsRecursive(XmlUtil xmlUtil, String parentConfigKey, Boolean inLocation, String locationSubPath, OverrideModeSetting overrideMode, Boolean skipInChildApps)   at System.Configuration.BaseConfigurationRecord.ScanSectionsRecursive(XmlUtil xmlUtil, String parentConfigKey, Boolean inLocation, String locationSubPath, OverrideModeSetting overrideMode, Boolean skipInChildApps)   at System.Configuration.BaseConfigurationRecord.ScanSections(XmlUtil xmlUtil)   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.Workbook.OnStartup()   at Smrf.NodeXL.ExcelTemplate.ThisWorkbook.FinishInitialization()   at Microsoft.VisualStudio.Tools.Office.EntryPointComponentBase.Microsoft.VisualStudio.Tools.Applications.Runtime.IEntryPoint.FinishInitialization()   at Microsoft.VisualStudio.Tools.Applications.AddInAdapter.ExecutePhase(ExecutionPhases executionPhases)   at Microsoft.VisualStudio.Tools.Applications.AddInAdapter.CompleteInitialization()   at Microsoft.VisualStudio.Tools.Office.Internal.OfficeAddInAdapterBase.ExecuteEntryPointsHelper()

************** Loaded Assemblies **************mscorlib    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.5456 (Win7SP1GDR.050727-5400)    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll----------------------------------------Microsoft.VisualStudio.Tools.Office.Runtime.v10.0    Assembly Version: 10.0.0.0    Win32 Version: 10.0.31007.0    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0.dll----------------------------------------System    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.5456 (Win7SP1GDR.050727-5400)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------System.Core    Assembly Version: 3.5.0.0    Win32 Version: 3.5.30729.5420 built by: Win7SP1    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll----------------------------------------System.Configuration    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll----------------------------------------System.Xml    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll----------------------------------------Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0    Assembly Version: 10.0.0.0    Win32 Version: 10.0.31007.0    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0.dll----------------------------------------System.AddIn    Assembly Version: 3.5.0.0    Win32 Version: 3.5.30729.5446 built by: Win7SP1GDR    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll----------------------------------------Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0    Assembly Version: 10.0.0.0    Win32 Version: 10.0.31007.0    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0.dll----------------------------------------System.Deployment    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll----------------------------------------System.Security    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll----------------------------------------Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0    Assembly Version: 10.0.0.0    Win32 Version: 10.0.31007.0    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.dll----------------------------------------System.Windows.Forms    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.5460 (Win7SP1GDR.050727-5400)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System.Drawing    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.5462 (Win7SP1GDR.050727-5400)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------System.Xml.Linq    Assembly Version: 3.5.0.0    Win32 Version: 3.5.30729.5420 built by: Win7SP1    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll----------------------------------------Smrf.NodeXL.ExcelTemplate    Assembly Version: 1.0.1.215    Win32 Version: 1.0.1.215    CodeBase: file:///C:/Users/abc/AppData/Local/Apps/2.0/654Z1Y17.M3T/MZ6M1GWB.J1O/smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7/Smrf.NodeXL.ExcelTemplate.DLL----------------------------------------Microsoft.Office.Tools.Excel.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.v9.0.dll----------------------------------------Microsoft.Office.Tools.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Tools.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.v9.0.dll----------------------------------------Microsoft.Office.Interop.Excel    Assembly Version: 14.0.0.0    Win32 Version: 14.0.4756.1000    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/14.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll----------------------------------------Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0.dll----------------------------------------System.AddIn.Contract    Assembly Version: 2.0.0.0    Win32 Version: 3.5.30729.5420 built by: Win7SP1    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn.Contract/2.0.0.0__b03f5f7f11d50a3a/System.AddIn.Contract.dll----------------------------------------Microsoft.VisualStudio.Tools.Applications.Contract.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Contract.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Contract.v9.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Office.Contract.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Contract.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Contract.v9.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v10.0    Assembly Version: 10.0.0.0    Win32 Version: 10.0.31007.0    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v10.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Office.HostAdapter.v10.0    Assembly Version: 10.0.0.0    Win32 Version: 10.0.31007.0    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.HostAdapter.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.HostAdapter.v10.0.dll----------------------------------------Microsoft.Office.Tools.Common.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Tools.Common.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.v9.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Office.Contract.v10.0    Assembly Version: 10.0.0.0    Win32 Version: 10.0.31007.0    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Contract.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Contract.v10.0.dll----------------------------------------Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0    Assembly Version: 9.0.0.0    Win32 Version: 9.0.30729.4130    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0.dll----------------------------------------office    Assembly Version: 14.0.0.0    Win32 Version: 14.0.4760.1000    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/office/14.0.0.0__71e9bce111e9429c/office.dll----------------------------------------Smrf.NodeXL.Core    Assembly Version: 1.0.1.215    Win32 Version: 1.0.1.215    CodeBase: file:///C:/Users/abc/AppData/Local/Apps/2.0/654Z1Y17.M3T/MZ6M1GWB.J1O/smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7/Smrf.NodeXL.Core.DLL----------------------------------------Smrf.NodeXL.ApplicationUtil    Assembly Version: 1.0.1.215    Win32 Version: 1.0.1.215    CodeBase: file:///C:/Users/abc/AppData/Local/Apps/2.0/654Z1Y17.M3T/MZ6M1GWB.J1O/smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7/Smrf.NodeXL.ApplicationUtil.DLL----------------------------------------Smrf.NodeXL.Visualization.Wpf    Assembly Version: 1.0.1.215    Win32 Version: 1.0.1.215    CodeBase: file:///C:/Users/abc/AppData/Local/Apps/2.0/654Z1Y17.M3T/MZ6M1GWB.J1O/smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7/Smrf.NodeXL.Visualization.Wpf.DLL----------------------------------------Smrf.NodeXL.Util    Assembly Version: 1.0.1.215    Win32 Version: 1.0.1.215    CodeBase: file:///C:/Users/abc/AppData/Local/Apps/2.0/654Z1Y17.M3T/MZ6M1GWB.J1O/smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7/Smrf.NodeXL.Util.DLL----------------------------------------Smrf.NodeXL.Algorithms    Assembly Version: 1.0.1.215    Win32 Version: 1.0.1.215    CodeBase: file:///C:/Users/abc/AppData/Local/Apps/2.0/654Z1Y17.M3T/MZ6M1GWB.J1O/smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7/Smrf.NodeXL.Algorithms.DLL----------------------------------------WindowsBase    Assembly Version: 3.0.0.0    Win32 Version: 3.0.6920.5448 built by: Win7SP1GDR    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll----------------------------------------PresentationCore    Assembly Version: 3.0.0.0    Win32 Version: 3.0.6920.5448 built by: Win7SP1GDR    CodeBase: file:///C:/Windows/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll----------------------------------------Smrf.WinFormsControls    Assembly Version: 1.0.1.7    Win32 Version: 1.0.1.7    CodeBase: file:///C:/Users/abc/AppData/Local/Apps/2.0/654Z1Y17.M3T/MZ6M1GWB.J1O/smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7/Smrf.WinFormsControls.DLL----------------------------------------System.ServiceModel    Assembly Version: 3.0.0.0    Win32 Version: 3.0.4506.5420 (Win7SP1.030729-5400)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.ServiceModel/3.0.0.0__b77a5c561934e089/System.ServiceModel.dll----------------------------------------

Jun 27, 2012 at 5:04 AM

Please do this:

1. Close Excel.

2. In Windows Explorer, delete the following file: C:\Users\abc\AppData\Local\Apps\2.0\Data\36P2XWAL.GJC\M02QCXKJ.TCE\smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7\Data\14.0.6117.5003\user.config

3. Start NodeXL again.

-- Tony

Jun 27, 2012 at 6:04 AM

Thanks a lot!

 

Gihong

Jun 27, 2012 at 6:09 PM

Gihong:

You might be able to help me here.  I'm the NodeXL programmer, and I'm trying to figure out how the file I just asked you to delete, which is a NodeXL "options file," got corrupted.  It's a bug in NodeXL that I'm having a hard time tracking down.  You are the second person I know of who it happened to.

Do you remember what you were doing with NodeXL before the problem started?  Was the program working fine, and then it suddenly stopped working when you tried to open a new NodeXL workbook?  Any information you can provide about what happened might help me fix the bug so it doesn't happen again.

Thanks,
    Tony

Jun 28, 2012 at 1:56 AM

Tony:

According to the timestamp, the file was created far before I started to notice any problem. One of my automated tasks started to generate .graphml only (meaning no .xlsx) a few days ago. I'm unsure as to if/how the two things are correlated. Let me know if there's any more information I can give.

Thanks,

Gihong

Jun 28, 2012 at 2:11 AM
Edited Jun 28, 2012 at 1:31 PM

The following file is created again.

"C:\Users\abc\AppData\Local\Apps\2.0\Data\36P2XWAL.GJC\M02QCXKJ.TCE\smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7\Data\14.0.6117.5003\user.config"

I need to save .xlsx files manually. I'm running 5 twitter keyword searches simultaneously. Is it too many?

Jun 28, 2012 at 5:05 AM

Gihong:

You have provided me with valuable information.  I believe that multiple, automated copies of Excel running at once can corrupt the user.config file, although it happens randomly and I haven't been able to get it to occur on my own computer.  Marc Smith, the founder of this project and the other person to whom this has happened, was running multiple, overlapping copies of the NodeXL Network Server program from Windows Task Scheduler, and it sounds like that's what you are doing, too.

This is a very difficult bug to fix, and for the time being my best advice is to schedule your tasks so they don't overlap, if at all possible.  That way, there will be no more than one copy of Excel running at a time and this corruption shouldn't occur.  In the latest version of the NodeXLNetworkServerFAQ.docx document that is included with NodeXL (but I know doesn't get noticed much!), I've added the following:

------------------------------------------
IMPORTANT:  If you schedule more than one task and you save each network directly to a NodeXL workbook, you should specify times that will prevent the tasks from overlapping each other.  For example, if you have three such tasks and they each take about 15 minutes to run, you should not schedule all of them to run at noon each day.  Instead, schedule the first to run at noon, the second at 1 PM, and the third at 2 PM, for example.

This will avoid random problems that can occur when multiple copies of Excel are simultaneously attempting to perform automated tasks.

This restriction does not apply if you save each network only as GraphML.
------------------------------------------

Regarding the file getting created again, that is to be expected.  NodeXL creates a new, clean user.config file if it doesn't find one already there.

Thanks,
    Tony

Jun 28, 2012 at 5:07 AM

My final solution is to delete everything in the following folder.

"C:\Users\abc\AppData\Local\Apps\2.0\Data\36P2XWAL.GJC\M02QCXKJ.TCE\smrf..vsto_ee5c3b578a613f22_0001.0000_c7a87bb0d55b3bc7\Data"

So doing appears to let NodeXL start afresh. :)