Citrix support for Add-in Express

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

Citrix support for Add-in Express
 
roy cao


Guest


Hi Add-in Express Team

Recently, some of our customers failed to use our Excel add-in by Citrix environment. although they're Memory requirement is 8G in Virtual machine, but still meet many issues, for example, out of memory issue.

the customer's IT setup is:
Windows 7 virtual clients in a Citrix environment with XenDesktop 7.11 (Citrix Studio Version 7.11.0.40). In the background we use virtual clients under VMWare vsphere Client version 6.5.0.23000.


the loader logs is:
Add-in Express Loader Log File: 07/08/2019 16:23:51:849
Startup directory: C:\Program Files (x86)\Moody's Analytics\Moody's Add-In for Excel\
Loader version: 8.2.4371.0
Operating System: Microsoft Windows 7 Enterprise Edition Service Pack 1 (build 7601), 64-bit
Process Owner: User
Command Line: "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
16:23:51:849 0436 5364 Start.
16:23:51:849 0436 5364 Creating a new instance of the add-in loader.
16:23:51:849 0436 5364 Loading mscoree.dll
16:23:51:880 0436 5364 Success.
16:23:51:880 0436 5364 Loading the configuration from the system registry.
16:23:51:880 0436 5364 Getting the latest CLR version.
16:23:51:880 0436 5364 The latest CLR version is 'v4.0.30319'.
16:23:51:880 0436 5364 The configuration has been loaded successfully.
16:23:51:880 0436 5364 Runtime version: v4.0.30319.
16:23:51:880 0436 5364 Assembly name: Moodys3.ExcelAddinTemplates, PublicKeyToken=29DC55FDEFE40C25.
16:23:51:880 0436 5364 Class name: Moodys3.ExcelAddinTemplates.UiModule.
16:23:51:880 0436 5364 Registry key: CLSID\{9B90B8F5-005C-4A08-A53C-E2CA83F44108}.
16:23:51:880 0436 5364 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
16:23:51:880 0436 5364 Loading CLR: v4.0.30319.
16:23:51:880 0436 5364 Calling CLRCreateInstance method.
16:23:51:880 0436 5364 Success.
16:23:51:880 0436 5364 Calling GetRuntime method.
16:23:51:880 0436 5364 Success.
16:23:51:880 0436 5364 Checking if the hosting API of .NET Framework v4.0 beta is installed.
16:23:51:943 0436 5364 The hosting API is up to date.
16:23:51:943 0436 5364 Calling GetInterface method for the CorRuntimeHost interface.
16:23:51:943 0436 5364 Success.
16:23:51:943 0436 5364 Starting CLR...
16:23:51:943 0436 5364 Success.
16:23:51:943 0436 5364 Getting the CLR version.
16:23:51:943 0436 5364 The CLR v4.0.30319 has been initialized successfully.
16:23:51:943 0436 5364 Creating a new domain setup.
16:23:51:943 0436 5364 Success.
16:23:51:943 0436 5364 Getting the add-in directory.
16:23:51:943 0436 5364 Success. The directory is 'C:\Program Files (x86)\Moody's Analytics\Moody's Add-In for Excel\'
16:23:51:943 0436 5364 The configuration file is 'C:\Program Files (x86)\Moody's Analytics\Moody's Add-In for Excel\App.config'
16:23:51:943 0436 5364 The 'shadow copy' is enabled.
16:23:51:943 0436 5364 Creating a new application domain.
16:23:51:974 0436 5364 Success.
16:23:51:974 0436 5364 Creating an instance of the managed class. Assembly identity: 'Moodys3.ExcelAddinTemplates, PublicKeyToken=29DC55FDEFE40C25'
16:23:52:645 0436 5364 Success.
16:23:52:645 0436 5364 Unwrapping the managed class.
16:23:52:660 0436 5364 Success.
16:23:52:660 0436 5364 Querying the add-in extensibility.
16:23:52:660 0436 5364 Success.
16:23:52:660 0436 5364 Querying the custom task panes.
16:23:52:660 0436 5364 Success.
16:23:52:660 0436 5364 Querying the ribbon extensibility.
16:23:52:660 0436 5364 Success.
16:23:52:660 0436 5364 Querying the form regions.
16:23:52:660 0436 5364 Success.
16:23:52:660 0436 5364 Querying the encryption provider.
16:23:52:660 0436 5364 The 'EncryptionProvider' interface is not supported.
16:23:52:660 0436 5364 Getting the dispid of the 'Dispose' method.
16:23:52:660 0436 5364 Success.
16:23:52:660 0436 5364 The instance of the managed add-in class has been created successfully.
16:23:58:151 0436 5364 Creating a new instance of the XLL loader.
16:23:58:151 0436 5364 Success.
16:23:58:151 0436 5364 Getting the CLSID of the managed XLL class.
16:23:58:151 0436 5364 Success.
16:23:58:151 0436 5364 Loading the configuration from the system registry.
16:23:58:151 0436 5364 Getting the latest CLR version.
16:23:58:151 0436 5364 The latest CLR version is 'v4.0.30319'.
16:23:58:151 0436 5364 The configuration has been loaded successfully.
16:23:58:151 0436 5364 Runtime version: v4.0.30319.
16:23:58:151 0436 5364 Assembly name: Moodys3.ExcelAddinTemplates, PublicKeyToken=29dc55fdefe40c25.
16:23:58:151 0436 5364 Class name: Moodys3.ExcelAddinTemplates.XLLModule.
16:23:58:167 0436 5364 Registry key: CLSID\{5FBC845F-4793-3D86-9794-715F1F12BF1E}.
16:23:58:167 0436 5364 Attempting to create a new instance of the managed XLL class: CLR - v4.0.30319
16:23:58:167 0436 5364 Getting the base directory for the domain.
16:23:58:167 0436 5364 Success. The directory is 'C:\Program Files (x86)\Moody's Analytics\Moody's Add-In for Excel\'.
16:23:58:167 0436 5364 Opening adxloader.dll.manifest.
16:23:58:167 0436 5364 Success. The manifest is 'C:\Program Files (x86)\Moody's Analytics\Moody's Add-In for Excel\adxloader.dll.manifest'.
16:23:58:167 0436 5364 Getting the 'assemblyIdentity' element.
16:23:58:167 0436 5364 Success.
16:23:58:167 0436 5364 Getting the 'name' attribute.
16:23:58:167 0436 5364 Success. The name is 'Moodys3.ExcelAddinTemplates, PublicKeyToken=29dc55fdefe40c25'.
16:23:58:167 0436 5364 Getting the 'name' attribute.
16:23:58:167 0436 5364 Success. The class name is 'Moodys3.ExcelAddinTemplates.XLLModule'.
16:23:58:167 0436 5364 Attempting to create a new instance of the XLL class.
16:23:58:245 0436 5364 Success.
16:23:58:245 0436 5364 Getting the dispid of the 'autoOpen' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Getting the dispid of the 'autoClose' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Getting the dispid of the 'autoAdd' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Getting the dispid of the 'autoRemove' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Getting the dispid of the 'autoFree' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Getting the dispid of the 'autoFree12' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Getting the dispid of the 'addInManagerInfo' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Getting the dispid of the 'addInManagerInfo12' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Getting the dispid of the 'Dispose' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Getting the dispid of the 'initialize4' method.
16:23:58:260 0436 5364 Success.
16:23:58:260 0436 5364 Invoking the 'initialize4' method.
16:23:58:323 0436 5364 Success.
16:23:58:323 0436 5364 The instance of the managed XLL class has been created successfully.
16:23:58:323 0436 5364 Forwarding xlAddInManagerInfo12 to the managed code.
16:23:58:338 0436 5364 Success.
16:23:58:338 0436 5364 Forwarding xlAutoOpen to the managed code.
16:23:58:370 0436 5364 Success.



any suggestion is welcome.

Thanks
Roy
Posted 18 Dec, 2019 00:40:14 Top
Andrei Smolin


Add-in Express team


Posts: 18833
Joined: 2006-05-11
Hello Roy,

roy cao writes:
Add-in Express Loader Log File: 07/08/2019 16:23:51:849


This file is outdated. Starting from Add-in Express 8.6 (and you use the loader from 8.2) the default location of the log file is {user profile}\AppData\Local\Temp\<ProductName>\adxloader.log; the ProductName part reflects the ProductName field of AssemblyInfo.cs (AssemblyInfo.vb).

Also, if possible, reinstall your add-in, start Excel and, while Excel is started, send me copies of adxloader.log and adxregistrator.exe.


Andrei Smolin
Add-in Express Team Leader
Posted 18 Dec, 2019 02:10:08 Top
roy cao


Guest


Hi Andrei,

Thank you for your info.
The log is correct. As this customer is using our old version add-in, which's based on 8.2 version Add-in express.

We asked the customer to re-install the add-in on July , it didn't work.

Just want to confirm with you firstly, Does the Add-in express can support the Citrix environment?

Thanks
Roy
Posted 18 Dec, 2019 02:28:06 Top
Andrei Smolin


Add-in Express team


Posts: 18833
Joined: 2006-05-11
roy cao writes:
The log is correct.


Are you saying that the date on that server is incorrect? Should I assume that starting Excel does create/update adxloader.log (and it shows both COM add-in and XLL add-in loading correctly, similar to the above) and this is only the date which is incorrect?

I'd like to know how you install the add-in on that machine. This is why I'd like to have adxregistrator.log. In version 8.2, the default location for adxregistrator.log is {profile}\Documents\Add-in Express\; see the profile of the user who started the installer.

roy cao writes:
some of our customers failed to use our Excel add-in


1) That is, the COM add-in loads correctly and this is the XLL add-in that fails?
2) Is the Excel add-in listed on File | Options | Add-ins? If yes, under what heading?
3) Also check if it is shown in the Excel Add-ins dialog. If shown, is it checked? Is it named correctly in that dialog?
4) Can you confirm that there's no other Excel version(s) installed on that machine? If so and if that Excel version(s) was installed recently, you may need to repair all Office versions (in the order of their versions: 2010 before and 2016 then) and reinstall the add-in.

roy cao writes:
Just want to confirm with you firstly, Does the Add-in express can support the Citrix environment?


Yes.


Andrei Smolin
Add-in Express Team Leader
Posted 18 Dec, 2019 02:46:38 Top