Issue with XLL register within Excel

Add-in Express™ Support Service
That's what is more important than anything else

Issue with XLL register within Excel
How can I find the Log file 
Glen Lewis




Posts: 29
Joined: 2021-03-12
I am using the click once deployment, all of the users so far have worked. But one user the COM add-in registers but the XLL does not.

I need to review the log file to see what the issue is but I have no idea where to find it.
Posted 10 Aug, 2021 10:48:43 Top
Dmitry Kostochko


Add-in Express team


Posts: 2875
Joined: 2004-04-05
Hello Glen,

The log file default location is <user profile>\AppData\Local\Temp\<ProductName>\adxregistrator.log. The ProductName part reflects the ProductName field of AssemblyInfo.cs (AssemblyInfo.vb).
Posted 10 Aug, 2021 11:00:34 Top
Glen Lewis




Posts: 29
Joined: 2021-03-12
Here is the log of the user that isn't working:

Add-in Express Loader Log File: 08/10/2021 10:19:31:177

Startup directory: C:\Users\rivmar1\AppData\Local\Apps\2.0\5XHBVB1G.HCR\E5LQK562.C4K\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\
Loader version: 9.5.4661.0
Operating System: Microsoft Windows 10 Professional (build 17134), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
10:19:31:177 4176 13932 Start.
10:19:31:177 4176 13932 The minimum supported Office version is 16
10:19:31:177 4176 13932 The host's version is 16.0.13426.20332
10:19:31:177 4176 13932 Creating a new instance of the add-in loader.
10:19:31:177 4176 13932 Loading mscoree.dll
10:19:31:177 4176 13932 INFO: Assembly codebase - C:\Users\rivmar1\AppData\Local\Apps\2.0\5XHBVB1G.HCR\E5LQK562.C4K\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\ExcelFinanceAddIn.dll.
10:19:31:177 4176 13932 INFO: Assembly version - 1.2.5.0.
10:19:31:177 4176 13932 Success.
10:19:31:177 4176 13932 Loading the configuration from the system registry.
10:19:31:177 4176 13932 Getting the latest CLR version.
10:19:31:177 4176 13932 The latest CLR version is 'v4.0.30319'.
10:19:31:177 4176 13932 The configuration has been loaded successfully.
10:19:31:177 4176 13932 Runtime version: v4.0.30319.
10:19:31:177 4176 13932 Assembly name: ExcelFinanceAddIn, PublicKeyToken=F5A20BE33FBD8EF0.
10:19:31:177 4176 13932 Class name: ExcelFinanceAddIn.AddinModule.
10:19:31:177 4176 13932 Registry key: CLSID\{6174AD39-E73E-45E9-A520-6F087FC81F77}.
10:19:31:177 4176 13932 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
10:19:31:177 4176 13932 Loading CLR: v4.0.30319.
10:19:31:177 4176 13932 Calling CLRCreateInstance method.
10:19:31:177 4176 13932 Success.
10:19:31:177 4176 13932 Calling GetRuntime method.
10:19:31:177 4176 13932 Success.
10:19:31:177 4176 13932 Checking if the hosting API of .NET Framework v4.0 beta is installed.
10:19:31:193 4176 13932 The hosting API is up to date.
10:19:31:193 4176 13932 Calling SetDefaultStartupFlags method.
10:19:31:193 4176 13932 Success.
10:19:31:193 4176 13932 Calling GetInterface method for the CorRuntimeHost interface.
10:19:31:193 4176 13932 Success.
10:19:31:193 4176 13932 Starting CLR...
10:19:31:193 4176 13932 Success.
10:19:31:193 4176 13932 Getting the CLR version.
10:19:31:193 4176 13932 The CLR v4.0.30319 has been initialized successfully.
10:19:31:193 4176 13932 Creating a new domain setup.
10:19:31:193 4176 13932 Success.
10:19:31:193 4176 13932 Getting the add-in directory.
10:19:31:193 4176 13932 Success. The directory is 'C:\Users\rivmar1\AppData\Local\Apps\2.0\5XHBVB1G.HCR\E5LQK562.C4K\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\'
10:19:31:193 4176 13932 The configuration file is 'C:\Users\rivmar1\AppData\Local\Apps\2.0\5XHBVB1G.HCR\E5LQK562.C4K\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\ExcelFinanceAddIn.dll.config'
10:19:31:193 4176 13932 The 'shadow copy' is disabled.
10:19:31:193 4176 13932 Creating a new application domain.
10:19:31:193 4176 13932 Success.
10:19:31:193 4176 13932 Creating an instance of the managed class. Assembly identity: 'ExcelFinanceAddIn, PublicKeyToken=F5A20BE33FBD8EF0'
10:19:31:302 4176 13932 Success.
10:19:31:302 4176 13932 Unwrapping the managed class.
10:19:31:302 4176 13932 Success.
10:19:31:302 4176 13932 Querying the add-in extensibility.
10:19:31:302 4176 13932 Success.
10:19:31:302 4176 13932 Querying the custom task panes.
10:19:31:302 4176 13932 Success.
10:19:31:302 4176 13932 Querying the ribbon extensibility.
10:19:31:302 4176 13932 Success.
10:19:31:302 4176 13932 Querying the form regions.
10:19:31:302 4176 13932 Success.
10:19:31:302 4176 13932 Querying the encryption provider.
10:19:31:302 4176 13932 The 'EncryptionProvider' interface is not supported.
10:19:31:302 4176 13932 Getting the dispid of the 'Dispose' method.
10:19:31:302 4176 13932 Success.
10:19:31:302 4176 13932 Getting the dispid of the 'InitializeLoaderService' method.
10:19:31:302 4176 13932 Success.
10:19:31:302 4176 13932 Invoking the 'InitializeLoaderService' method.
10:19:31:302 4176 13932 Success.
10:19:31:302 4176 13932 The instance of the managed add-in class has been created successfully.



Here is the log of mine that is working:

Add-in Express Loader Log File: 08/10/2021 11:10:46:719

Startup directory: C:\Users\glen.lewis\AppData\Local\Apps\2.0\B6G343BR.YC2\DE0206NB.ZPB\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\
Loader version: 9.5.4661.0
Operating System: Microsoft Windows 10 Professional (build 22000), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
11:10:46:720 9584 33640 The minimum supported Office version is 16
11:10:46:721 9584 33640 The host's version is 16.0.14228.20226
11:10:46:721 9584 33640 Creating a new instance of the XLL loader.
11:10:46:721 9584 33640 Loading mscoree.dll
11:10:46:721 9584 33640 INFO: Assembly codebase - C:\Users\glen.lewis\AppData\Local\Apps\2.0\B6G343BR.YC2\DE0206NB.ZPB\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\ExcelFinanceAddIn.dll.
11:10:46:721 9584 33640 INFO: Assembly version - 1.2.5.0.
11:10:46:721 9584 33640 Success.
11:10:46:721 9584 33640 Getting the CLSID of the managed XLL class.
11:10:46:721 9584 33640 Success.
11:10:46:721 9584 33640 Loading the configuration from the system registry.
11:10:46:721 9584 33640 Getting the latest CLR version.
11:10:46:722 9584 33640 The latest CLR version is 'v4.0.30319'.
11:10:46:722 9584 33640 The configuration has been loaded successfully.
11:10:46:722 9584 33640 Runtime version: v4.0.30319.
11:10:46:722 9584 33640 Assembly name: ExcelFinanceAddIn, PublicKeyToken=f5a20be33fbd8ef0.
11:10:46:722 9584 33640 Class name: ExcelFinanceAddIn.XllFunctions.
11:10:46:722 9584 33640 Registry key: CLSID\{D2D66FC9-3C02-3EE7-BF0C-8B4462CDF082}.
11:10:46:722 9584 33640 Attempting to create a new instance of the managed XLL class: CLR - v4.0.30319
11:10:46:722 9584 33640 Loading CLR: v4.0.30319.
11:10:46:722 9584 33640 Calling CLRCreateInstance method.
11:10:46:722 9584 33640 Success.
11:10:46:722 9584 33640 Calling GetRuntime method.
11:10:46:722 9584 33640 Success.
11:10:46:722 9584 33640 Checking if the hosting API of .NET Framework v4.0 beta is installed.
11:10:46:728 9584 33640 The hosting API is up to date.
11:10:46:728 9584 33640 Calling SetDefaultStartupFlags method.
11:10:46:728 9584 33640 Success.
11:10:46:728 9584 33640 Calling GetInterface method for the CorRuntimeHost interface.
11:10:46:728 9584 33640 Success.
11:10:46:728 9584 33640 Starting CLR...
11:10:46:728 9584 33640 Success.
11:10:46:728 9584 33640 Getting the CLR version.
11:10:46:728 9584 33640 The CLR v4.0.30319 has been initialized successfully.
11:10:46:728 9584 33640 Creating a new domain setup.
11:10:46:728 9584 33640 Success.
11:10:46:728 9584 33640 Getting the add-in directory.
11:10:46:728 9584 33640 Success. The directory is 'C:\Users\glen.lewis\AppData\Local\Apps\2.0\B6G343BR.YC2\DE0206NB.ZPB\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\'
11:10:46:729 9584 33640 The configuration file is 'C:\Users\glen.lewis\AppData\Local\Apps\2.0\B6G343BR.YC2\DE0206NB.ZPB\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\ExcelFinanceAddIn.dll.config'
11:10:46:729 9584 33640 The 'shadow copy' is disabled.
11:10:46:729 9584 33640 Creating a new application domain.
11:10:46:731 9584 33640 Success.
11:10:46:731 9584 33640 Getting the base directory for the domain.
11:10:46:731 9584 33640 Success. The directory is 'C:\Users\glen.lewis\AppData\Local\Apps\2.0\B6G343BR.YC2\DE0206NB.ZPB\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\'.
11:10:46:731 9584 33640 Opening adxloader.dll.manifest.
11:10:46:731 9584 33640 Success. The manifest is 'C:\Users\glen.lewis\AppData\Local\Apps\2.0\B6G343BR.YC2\DE0206NB.ZPB\exce..ddin_0e3f8980f338ba0a_0001.0002_3d96d73801ef5769\adxloader.dll.manifest'.
11:10:46:731 9584 33640 Getting the 'assemblyIdentity' element.
11:10:46:731 9584 33640 Success.
11:10:46:731 9584 33640 Getting the 'name' attribute.
11:10:46:731 9584 33640 Success. The name is 'ExcelFinanceAddIn, PublicKeyToken=f5a20be33fbd8ef0'.
11:10:46:731 9584 33640 Getting the 'name' attribute.
11:10:46:731 9584 33640 Success. The class name is 'ExcelFinanceAddIn.XllFunctions'.
11:10:46:731 9584 33640 Attempting to create a new instance of the XLL class.
11:10:46:742 9584 33640 Success.
11:10:46:742 9584 33640 Getting the dispid of the 'autoOpen' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Getting the dispid of the 'autoClose' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Getting the dispid of the 'autoAdd' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Getting the dispid of the 'autoRemove' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Getting the dispid of the 'autoFree' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Getting the dispid of the 'autoFree12' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Getting the dispid of the 'addInManagerInfo' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Getting the dispid of the 'addInManagerInfo12' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Getting the dispid of the 'Dispose' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Getting the dispid of the 'initialize4' method.
11:10:46:743 9584 33640 Success.
11:10:46:743 9584 33640 Invoking the 'initialize4' method.
11:10:46:798 9584 33640 Success.
11:10:46:798 9584 33640 The instance of the managed XLL class has been created successfully.
11:10:46:798 9584 33640 Forwarding xlAutoOpen to the managed code.
11:10:46:816 9584 33640 Success.
11:10:46:990 9584 33640 Start.
11:10:46:990 9584 33640 The minimum supported Office version is 16
11:10:46:990 9584 33640 The host's version is 16.0.14228.20226
11:10:46:990 9584 33640 Creating a new instance of the add-in loader.
11:10:46:990 9584 33640 Success.
11:10:46:990 9584 33640 Loading the configuration from the system registry.
11:10:46:990 9584 33640 Getting the latest CLR version.
11:10:46:990 9584 33640 The latest CLR version is 'v4.0.30319'.
11:10:46:990 9584 33640 The configuration has been loaded successfully.
11:10:46:990 9584 33640 Runtime version: v4.0.30319.
11:10:46:990 9584 33640 Assembly name: ExcelFinanceAddIn, PublicKeyToken=F5A20BE33FBD8EF0.
11:10:46:990 9584 33640 Class name: ExcelFinanceAddIn.AddinModule.
11:10:46:990 9584 33640 Registry key: CLSID\{6174AD39-E73E-45E9-A520-6F087FC81F77}.
11:10:46:990 9584 33640 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
11:10:46:990 9584 33640 Creating an instance of the managed class. Assembly identity: 'ExcelFinanceAddIn, PublicKeyToken=F5A20BE33FBD8EF0'
11:10:47:039 9584 33640 Success.
11:10:47:039 9584 33640 Unwrapping the managed class.
11:10:47:040 9584 33640 Success.
11:10:47:040 9584 33640 Querying the add-in extensibility.
11:10:47:040 9584 33640 Success.
11:10:47:040 9584 33640 Querying the custom task panes.
11:10:47:040 9584 33640 Success.
11:10:47:040 9584 33640 Querying the ribbon extensibility.
11:10:47:040 9584 33640 Success.
11:10:47:040 9584 33640 Querying the form regions.
11:10:47:040 9584 33640 Success.
11:10:47:040 9584 33640 Querying the encryption provider.
11:10:47:041 9584 33640 The 'EncryptionProvider' interface is not supported.
11:10:47:041 9584 33640 Getting the dispid of the 'Dispose' method.
11:10:47:042 9584 33640 Success.
11:10:47:042 9584 33640 Getting the dispid of the 'InitializeLoaderService' method.
11:10:47:042 9584 33640 Success.
11:10:47:042 9584 33640 Invoking the 'InitializeLoaderService' method.
11:10:47:042 9584 33640 Success.
11:10:47:042 9584 33640 The instance of the managed add-in class has been created successfully.




From what I can see, it isn't even trying to load the XLL, min on line 20 has the XLL Class, the other doesn't.

Any ideas of what could be happening?


This log file show the add-in when excel opens. But doesn't have the log of the registration of the add-in. I am thinking there is an issue with the XLL registration.
Posted 10 Aug, 2021 11:17:13 Top
Glen Lewis




Posts: 29
Joined: 2021-03-12
More info, when we installed it using a standalone installer. When I we launched excel we get this error.


Detailed technical information follows:
---
(Inner Exception)
(Inner Exception)
Date and Time: 8/10/2021 11:27:26 AM
Machine Name: HQFSL9810
IP Address: 127.0.0.1
Current User: STBTC\rivmar1

Application Domain: C:\Users\rivmar1\AppData\Local\GL Consulting\ExcelFinanceAddIn\
Assembly Codebase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
Assembly Full Name: System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Assembly Version: 4.0.0.0

Exception Source: System.Configuration
Exception Type: System.Configuration.ConfigurationErrorsException
Exception Message: Unrecognized configuration section userSettings. (C:\Users\rivmar1\AppData\Local\Microsoft_Corporation\C__Users_rivmar1_AppData__Path_tkrehcb3zj0cqoyjgeeoo0qtmbgbwh0x\16.0.13426.20332\user.config line 3)
Exception Target Site: ThrowIfErrors

---- Stack Trace ----
System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(ignoreLocal As Boolean)
System.Configuration.dll: N 0040 (0x28) IL
System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(schemaErrors As ConfigurationSchemaErrors)
System.Configuration.dll: N 0022 (0x16) IL
System.Configuration.ClientConfigurationSystem.OnConfigRemoved(sender As Object, e As InternalConfigEventArgs)
System.Configuration.dll: N 0030 (0x1E) IL



(Outer Exception)
Date and Time: 8/10/2021 11:27:26 AM
Machine Name: HQFSL9810
IP Address: 127.0.0.1
Current User: STBTC\rivmar1

Application Domain: C:\Users\rivmar1\AppData\Local\GL Consulting\ExcelFinanceAddIn\
Assembly Codebase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
Assembly Full Name: System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Assembly Version: 4.0.0.0

Exception Source: System.Configuration
Exception Type: System.Configuration.ConfigurationErrorsException
Exception Message: Configuration system failed to initialize
Exception Target Site: PrepareConfigSystem

---- Stack Trace ----
System.Configuration.ConfigurationManager.PrepareConfigSystem()
System.Configuration.dll: N 0024 (0x18) IL
System.Configuration.ConfigurationManager.GetSection(sectionName As String)
System.Configuration.dll: N 0015 (0xF) IL
System.Configuration.PrivilegedConfigurationManager.GetSection(sectionName As String)
System.Configuration.dll: N 0000 (0x0) IL
System.Net.Configuration.SettingsSectionInternal.get_Section()
System.Configuration.dll: N 0025 (0x19) IL
System.Net.Sockets.Socket.InitializeSockets()
System.Configuration.dll: N 0190 (0xBE) IL
System.Net.Dns.GetHostName()
System.Configuration.dll: N 0015 (0xF) IL
AddinExpress.Projects.Common.ADXExceptionManager.GetCurrentIP()
System.Configuration.dll: N 0000 (0x0) IL



(Outer Exception)
Date and Time: 8/10/2021 11:27:26 AM
Machine Name: HQFSL9810
IP Address: 127.0.0.1
Current User: STBTC\rivmar1

Application Domain: C:\Users\rivmar1\AppData\Local\GL Consulting\ExcelFinanceAddIn\
Assembly Codebase: file:///C:/Users/rivmar1/AppData/Local/GL Consulting/ExcelFinanceAddIn/AddinExpress.MSO.2005.DLL
Assembly Full Name: AddinExpress.MSO.2005, Version=9.5.4661.0, Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 9.5.4661.0

Exception Source:
Exception Type: AddinExpress.MSO.ADXExternalException
Exception Message: An error has occurred in the code of the add-in.

---- Stack Trace ----
Posted 10 Aug, 2021 11:33:37 Top
Dmitry Kostochko


Add-in Express team


Posts: 2875
Joined: 2004-04-05
Hello Glen,


This log file show the add-in when excel opens. But doesn't have the log of the registration of the add-in. I am thinking there is an issue with the XLL registration.


Yes, you are right, we need to examine the adxRegistrator's log file, probably it will contain some errors. Also, may it be that your customer simply turned off your XLL? Please check this in the Excel Add-ins dialog.


More info, when we installed it using a standalone installer. When I we launched excel we get this error.


Is it some test installation project? If so, it looks like you forgot to include some files (configuration ?) into the project.
Posted 11 Aug, 2021 04:29:12 Top
Glen Lewis




Posts: 29
Joined: 2021-03-12
This add-in has been in production use now for about 3 months with 35+ plus PC installs for two different companies.

Same installer has been used for both companies.
Posted 12 Aug, 2021 10:31:56 Top
Dmitry Kostochko


Add-in Express team


Posts: 2875
Joined: 2004-04-05
Hello Glen,

So, do both issues (XLL is not loaded and the "Configuration system failed to initialize" exception) occur on the same PC? And all other installations (35+) work correctly? If so, I would recommend repairing or even reinstalling the .NET Framework and Microsoft Office on the affected machine.
Posted 13 Aug, 2021 02:36:18 Top