BigFix Excel Connector

system · November 13, 2011, 6:45pm

(imported comment written by manonstreet91)

Lee,

Thanks for the (quick) reply. If I use the query definition “All Computer Groups”, it sometimes returns data really quickly, other times it errors out in the same manner. The actual Web Reports interface using the same credentials is very responsive, so I do not believe it to be a server side issue. Doing almost any other action (running other query definitions, trying to load up the BES properties, etc…), hangs for a long while, then returns the error. I’m not sure if it’s related / typical, but clicking the Execute Query Wizard also takes a while before displaying.

I am running Windows 7 SP 1 x64 and Excel 2010 x64. I’ve seen some notes for previous versions about Excel x64 not being supported, perhaps that’s the issue. Any ideas on what to try next?

leewei · November 13, 2011, 7:16pm

(imported comment written by Lee Wei)

manonstreet,

I don’t recognize the symptom of the problem. Maybe you can help me test my using the Session Relevance Tester (http://forum.bigfix.com/viewtopic.php?id=3026) which can issue SOAP queries against Web Reports. This would be the same interface that the Excel Connector uses.

Anytime you load up a report/query in the Excel Connector, you can click on “Show Relevance Code” to copy the statement for testing in the Session Relevance Tester.

When I get back from my travels end of this week, I would be happy to help debug if we cannot make head way. Please contact me via email.

Lee Wei

system · April 12, 2012, 1:30pm

(imported comment written by JiriS)

Hello,

we have problem with importing column ‘LastReportTime’.

Column is imported, but we receive error:

Office 2003 (SP3):

Processing error: Application Microsoft Office cannot use number format.

Office 2007 :

Processing error: Cannot set up property NumberFormat of class Range.

We using MS Office in Czech language

Thank for any suggestion

Jiri Sury

leewei · April 12, 2012, 7:51pm

(imported comment written by Lee Wei)

Hello Jiri,

The Excel Connector converts the “Last Report Time” string property to a format that looks like this:

yyyy/mm/dd hh:mm AM/PM

It then tells Excel to format the data as a Date/Time. Looks like it is making a mess of it in your case. I wonder if it has to do with language version.

Can you try selecting the cells and change the Format?

Lee Wei

system · May 3, 2012, 8:23pm

(imported comment written by JiriS)

Hello Lee,

Thank you for suggestion

I suppose that problem is with clock format.

Excel Connector use 12-hour format, but we use 24-hour format.

I tested changing regional format

(WinXP: control panel->Regional and Language options->Standards and formats)

When I use Czech formats, which is usual for our PCs, I receive error,

but when I use English(United States), I receive result without error

Jiri Sury

leewei · May 4, 2012, 12:51am

(imported comment written by Lee Wei)

Jiri,

Thanks for narrowing it down, this helps me to find a solution when I update the software.

Lee Wei

system · October 8, 2012, 1:12am

(imported comment written by kapax00)

Lee Wei,

I’m having issue with the installation of the latest Excel connector. (3.3.1 with an msi labeled as 3.3.2).

It is freshly installed on Win7(x64) on top of an Office Professional Plus 2007 (running as a KVM virtual machine, if this may have any relevance in the case).

I ensured to have the latest system and application patches and (I think) I followed all the installation instructions correctly, including the full 4 .NET Framework.

The installation reports a correct installation but when I open Excel I receive the popup as in the attached picture.

The full diagnostic text is appended, along with the Add-in Express installation log files.

I made various attempts, all the times with the same results.

Any suggestion on what can I do to fix the issue?

Thanks for help.

Andrea A Capasso

=========================

Detailed technical information follows:

(Inner Exception)

Date and Time: 07/10/2012 22:43:09

Machine Name: VAAC520

IP Address: fe80::49c9:4d47:9b42:3c0%14

Current User: VAAC520\andrea_capasso

Application Domain: C:\Users\IBM_ADMIN\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3\

Assembly Codebase: file:///C:/Users/IBM_ADMIN/AppData/Roaming/BigFix Enterprise/Tivoli Endpoint Manager Excel Connector 3.3/AddinExpress.MSO.2005.DLL

Assembly Full Name: AddinExpress.MSO.2005, Version=6.4.3056.2005, Culture=neutral, PublicKeyToken=4416dd98f0861965

Assembly Version: 6.4.3056.2005

Exception Source: Interop.Excel

Exception Type: System.Runtime.InteropServices.COMException

Exception Message: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))

Exception Target Site: get_Version

Stack Trace ----

Excel._Application.get_Version()

AddinExpress.MSO.2005.DLL: N 00000 (0x0) JIT

BigFixExcelConnector.FormWizard…ctor()

AddinExpress.MSO.2005.DLL: N 0462 (0x1CE) IL

BigFixExcelConnector.AddinModule.AddinModule_AddinInitialize(sender As Object, e As EventArgs)

AddinExpress.MSO.2005.DLL: N 0001 (0x1) IL

AddinExpress.MSO.ADXAddinModule.Extensibility.IDTExtensibility2.OnStartupComplete(custom As Array&)

AddinExpress.MSO.2005.DLL: N 0572 (0x23C) IL

(Outer Exception)

Date and Time: 07/10/2012 22:43:09

Machine Name: VAAC520

IP Address: fe80::49c9:4d47:9b42:3c0%14

Current User: VAAC520\andrea_capasso

Application Domain: C:\Users\IBM_ADMIN\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3\

Assembly Codebase: file:///C:/Users/IBM_ADMIN/AppData/Roaming/BigFix Enterprise/Tivoli Endpoint Manager Excel Connector 3.3/AddinExpress.MSO.2005.DLL

Assembly Full Name: AddinExpress.MSO.2005, Version=6.4.3056.2005, Culture=neutral, PublicKeyToken=4416dd98f0861965

Assembly Version: 6.4.3056.2005

Exception Source:

Exception Type: AddinExpress.MSO.ADXExternalException

Exception Message: An error has occured in the code of the add-in.

Exception Target Site: Object reference not set to an instance of an object.

Stack Trace ----

=========================

=========adxloader.log=========

Add-in Express Loader Log File: 10/07/2012 22:42:56

Startup directory: C:\Users\IBM_ADMIN\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3\

Loader version: 6.4.3056.0

Operating System: Microsoft Windows 7 Professional Service Pack 1 (build 7601), 64-bit

Process Owner: Administrator

Command Line: “C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE”

Run ‘As Administrator’: Yes

Process Elevated: Yes

Integrity Level: High

UAC (User Account Control): Off

22:42:56 0756 4044 Start.

22:42:56 0756 4044 Reading the registry key ‘HKEY_CLASSES_ROOT\CLSID{FDFBA9E9-6C9D-45B8-8594-C8A035970615}’

22:42:56 0756 4044 Success. The registry key ‘HKEY_CLASSES_ROOT\CLSID{FDFBA9E9-6C9D-45B8-8594-C8A035970615}’ is closed.

22:42:56 0756 4044 Converting the ‘{4BA250A6-8BCA-46A6-982A-F340081187C3}’ CLSID from string.

22:42:56 0756 4044 Success.

22:42:56 0756 4044 Attempting to get the class object by the ‘{4BA250A6-8BCA-46A6-982A-F340081187C3}’ CLSID.

22:42:56 0756 4044 Success.

22:42:56 0756 4044 Creating a new instance of the add-in loader.

22:42:56 0756 4044 Loading mscoree.dll

22:42:56 0756 4044 Success.

22:42:56 0756 4044 Loading the configuration from the system registry.

22:42:56 0756 4044 Getting the latest CLR version.

22:42:56 0756 4044 The latest CLR version is ‘v4.0.30319’.

22:42:56 0756 4044 The configuration has been loaded successfully.

22:42:56 0756 4044 Runtime version: v2.0.50727.

22:42:56 0756 4044 Assembly name: BigFixExcelConnector, PublicKeyToken=BEF2983F1300AF93.

22:42:56 0756 4044 Class name: BigFixExcelConnector.AddinModule.

22:42:56 0756 4044 Registry key: CLSID{FDFBA9E9-6C9D-45B8-8594-C8A035970615}.

22:42:56 0756 4044 Attempting to create a new instance of the managed add-in class: CLR - v2.0.50727

22:42:56 0756 4044 Loading CLR: v2.0.50727.

22:42:56 0756 4044 Calling CLRCreateInstance method.

22:42:56 0756 4044 Success.

22:42:56 0756 4044 Calling GetRuntime method.

22:42:56 0756 4044 Success.

22:42:56 0756 4044 Calling GetInterface method.

22:42:57 0756 4044 Calling GetInterface method for the CorRuntimeHost interface.

22:42:57 0756 4044 Success.

22:42:57 0756 4044 Starting CLR…

22:42:57 0756 4044 Success.

22:42:57 0756 4044 The CLR v2.0.50727 has been initialized successfully.

22:42:57 0756 4044 Creating a new domain setup.

22:42:57 0756 4044 Success.

22:42:57 0756 4044 Getting the add-in directory.

22:42:57 0756 4044 Success. The directory is ‘C:\Users\IBM_ADMIN\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3’

22:42:57 0756 4044 The configuration file is ‘C:\Users\IBM_ADMIN\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3\app.config’

22:42:57 0756 4044 The ‘shadow copy’ is enabled.

22:42:57 0756 4044 Creating a new application domain.

22:42:57 0756 4044 Success.

22:43:01 0756 4044 Unwrapping the managed class.

22:43:02 0756 4044 Success.

22:43:02 0756 4044 Querying the add-in extensibility.

22:43:02 0756 4044 Querying the custom task panes.

22:43:02 0756 4044 Querying the ribbon extensibility.

22:43:02 0756 4044 Success.

22:43:02 0756 4044 Querying the form regions.

22:43:02 0756 4044 Success.

22:43:02 0756 4044 Getting the dispid of the ‘Dispose’ method.

22:43:02 0756 4044 Success.

22:43:02 0756 4044 The managed add-in class has been created successfully.

=========adxloader.log=========

=========adxregistrator.log=========

Add-in Express Registrator Log File: 10/07/2012 22:37:59

Installation directory: C:\Users\IBM_ADMIN\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3\

Registrator version: 6.4.3056.0

Operating System: Microsoft Windows 7 Professional Service Pack 1 (build 7601), 64-bit

Process Owner: Administrator

Command Line: “C:\Users\IBM_ADMIN\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3\adxregistrator.exe” /Install=BigFixExcelConnector.dll /privileges=admin

Run ‘As Administrator’: Yes

Process Elevated: Yes

Integrity Level: High

UAC (User Account Control): Off

22:37:59 0192 Starting the add-in registration process.

22:37:59 0192 Loading mscoree.dll

22:37:59 0192 Success.

22:37:59 0192 .NET Framework installation directory:

22:37:59 0192 The latest version of .NET Framework: ‘v4.0.30319’

22:37:59 0192 Loading CLR: v4.0.30319.

22:37:59 0192 Calling CLRCreateInstance method.

22:37:59 0192 Success.

22:37:59 0192 Calling GetRuntime method.

22:37:59 0192 Success.

22:37:59 0192 Calling GetInterface method.

22:37:59 0192 Calling GetInterface method for the CorRuntimeHost interface.

22:37:59 0192 Success.

22:37:59 0192 Starting CLR…

22:37:59 0192 Success.

22:37:59 0192 The CLR v4.0.30319 has been initialized successfully.

22:37:59 0192 Creating a new domain setup.

22:37:59 0192 Success.

22:37:59 0192 Getting the add-in directory.

22:37:59 0192 Success. The directory is ‘C:\Users\IBM_ADMIN\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3’

22:37:59 0192 The ‘shadow copy’ is disabled.

22:37:59 0192 Creating a new application domain.

22:37:59 0192 Success.

22:37:59 0192 Getting the base directory for the domain.

22:37:59 0192 Success. The directory is ‘C:\Users\IBM_ADMIN\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3’.

22:37:59 0192 Searching for the Add-in Express core library.

22:37:59 0192 Success. The ‘AddinExpress.MSO.2005.dll’ file is found.

22:37:59 0192 Creating an instance of the ‘AddinExpress.Deployment.ADXRegistrator’ class.

22:37:59 0192 Assembly identity is ‘AddinExpress.MSO.2005’.

22:38:00 0192 Success.

22:38:00 0192 Unwrapping the instance of the ‘AddinExpress.Deployment.ADXRegistrator’ class.

22:38:00 0192 Success.

22:38:00 0192 Calling the managed registration procedure.

22:38:00 0584 Connecting to the application domain of the Add-in Express loader.

22:38:00 0584 Success.

22:38:00 0584 Loading the ‘bigfixexcelconnector.dll’ assembly.

22:38:01 0584 Success.

22:38:01 0584 Registering the ‘bigfixexcelconnector.dll’ assembly (administrator).

22:38:06 0584 The ’ bigfixexcelconnector.dll’ assembly has been registered successfully.

22:38:07 0192 Success.

22:38:07 0192 The add-in registration process is completed with HRESULT = 0.

=========adxregistrator.log=========

system · October 8, 2012, 11:33am

(imported comment written by kapax00)

Lee Wei,

I found the reson of the problem.

I was able to narrow down the issue to a “Culture” related setting in my OS, that was set to Italian.

If this is not addessed in the code (http://www.add-in-express.com/forum/read.php?FID=5&TID=10278), changing the OS regional settings can solve the problem.

Just sharing the info here for anyone that may get similar messages, and for your awareness.

Andrea A Capasso

leewei · October 8, 2012, 8:08pm

(imported comment written by Lee Wei)

Andrea,

Thanks for the info on how to fix it.

Lee Wei

system · December 18, 2012, 6:41pm

(imported comment written by SystemAdmin)

Hi Lee,

I am getting the error “Error: the operator “lowercase” is not defined” when running the following code generated by the excel connector

(    item 0 of it as string  & 
"$x$" & (

if ((year of date (local time zone) of it) as integer = 1980) then (
"<none>") 

else ( (year of it as string & 
"/" & month of it as two digits & 
"/" & day_of_month of it as two digits) of date (local time zone) of it & 
" " & (two digit hour of it as string & 
":" & two digit minute of it as string) of time (local time zone) of it)) of (item 1 of it as time) & 
"$x$" & item 2 of it as string  & 
"$x$" & item 3 of it as string  & 
"$x$" & item 4 of it as string  & 
"$x$" & item 5 of it as string  & 
"$x$" & item 6 of it as string  & 
"$x$" & item 7 of it as string ) of ( (

if (exists ID of Action of it) then (concatenations 
"%0A" of (ID of Action of it as string)) 

else (
"<none>")), (

if (exists Time Issued of Action of it) then (Time Issued of Action of it as string) 

else (
"Fri, 15 Feb 1980 00:00:00 -0000")), (

if (exists Name of Action of it) then (concatenations 
"%0A" of (Name of Action of it as string)) 

else (
"<none>")), (

if (exists State of Action of it) then (concatenations 
"%0A" of (State of Action of it as string)) 

else (
"<none>")), (

if (exists Name of Computer of it) then (concatenations 
"%0A" of (Name of Computer of it as string)) 

else (
"<none>")), (

if (exists Status of it) then (concatenations 
"%0A" of (Status of it as string)) 

else (
"<none>")), (

if (exists Detailed Status of it) then (concatenations 
"%0A" of (Detailed Status of it as string)) 

else (
"<none>")), (

if (exists Name of Issuer of Action of it) then (concatenations 
"%0A" of (Name of Issuer of Action of it as string)) 

else (
"<none>"))) of results whose (((Status of it as lowercase contains 
"expired"))) of bes actions

I notice that if I manually change the

whose (((Status of it as lowercase contains 
"expired")))

to

whose  (((Status of it as string as lowercase contains 
"expired")))

it works correctly.

Any hints on how to correct this?

Thanks

Martin Carnegie

Gulf Breeze Software Partners

http://www.gulfsoft.com

leewei · December 18, 2012, 10:24pm

(imported comment written by Lee Wei)

Hi Martin,

Thanks for reporting this.

Yes it would be a bug since the Excel Connector is treating the Action Status as a string when it should be an object.

I will have to fix the code and the only way I can see you working around this would be to extract the data and filter out in Excel in the mean time.

Lee Wei

system · December 19, 2012, 5:56pm

(imported comment written by SystemAdmin)

Hi Lee,

Thanks for the quick response. The extract and filter in Excel is exactly what I am doing Little issues like this in such a great tool are minor. Without this tool, it would not be so easy to get the data I need.

On a side question, this tool seems to be pulling data for deleted records (IsDeleted = 1), is that correct? If so, is there a way to filter them out as I have not seen one yet?

Thanks.

Martin Carnegie

Gulf Breeze Software Partners

http://www.gulfsoft.com

leewei · December 20, 2012, 3:44am

(imported comment written by Lee Wei)

Martin,

I found out that the default inspector “bes actions” will return member actions for Multi-Action Group (MAG).

To return the actions as would be exactly the same as from the Console, we can use the inspector “top level bes actions”.

What do you guys think?

Of course, it would be nice to have a check box, but I will have to think about the UI…

Lee Wei

system · February 4, 2013, 2:22pm

(imported comment written by SystemAdmin)

Hi Lee,

I’m a new member here and your work is indeed impressive.

I need some help with a TEM web report which will return “IP address / Host Name”, “Vuln. Level(High)” , “Operating System” , “Service Pack” , “Vulnerabilities (Total, High, Medium, Low)” , "Missing Patches (Total, Critic., Imprt., Moder., Low).

Thanks in advance

Faith

leewei · February 4, 2013, 9:05pm

(imported comment written by Lee Wei)

Faith,

First of all, welcome to the forum.

From your description, this is likely to be a good report for you to start with.

Fixlet Compliance by Computer Group

Here is a screen shot of the report:

Lee Wei

dhtorsdc · October 29, 2014, 6:29pm

(imported comment written by dhtorsdc)

Hi Lee:

Was this switch for deleted actions ever put in or is there a way to include them and show which are deleted and which aren’t in the output? This would be very useful. Thanks!

leewei · April 16, 2013, 10:31pm

(imported comment written by Lee Wei)

Added the latest version today 3.3.3.

There are no new features, just maintenance as follows:

Changed name to IBM Endpoint Manager (IEM) Excel Connector
Added support for Excel 2013.
Fixed error with Regional and Language Formats that non-English
Fixed error with searching for action status using the “Results of BES Action” object

Lee Wei

system · May 1, 2013, 6:45pm

(imported comment written by GeorgeLeeUPS)

Hi Lee

The excel connector is a great add-in for excel but is it possible to change the way the excel connector uses the whose statement for the bes of action? When I use the Query Wizard to build a report for BES Actions the last part of the relevance is

of results
whose(((ID of Action of it=190049)))
of bes actions

Reason I ask is that this piece of relevance could take a long time to return the results depending on how much data is returning. Which causes a heavy load on the Web report server.

If I make a slight change to the relevance to look like this

of results
of bes actions whose(((ID of it=190049)))

the results return back significantly faster than the previous statement.

I’ve used the Relevance editor to make this change and it works but I can’t save the changes and the format is no longer the same. Any help would be greatly appreciated.

leewei · May 7, 2013, 7:45pm

(imported comment written by Lee Wei)

Acknowledge reading this, thank you for the note and I will take a look on fixing this for you.

Lee Wei

system · August 16, 2013, 12:29am

(imported comment written by DavidNautilus)

Hello Lee,

I am not able to install the connector. I first tried installing version 3.3.1 with a normal user account trought the .msi installer. The GUI didn´t show any errors. I then found out that there was a newer version so I decided to uninstall version 3.3.1 through control panel and then rebooted the computer. Then I installed the most recent 3.3.3 version and installed it running the setup.exe file through right click “run as” as recomended in your instructions. The connector doesn´t show up in excel, This is content of adxregistrator.log file:

Add-in Express Registrator Log File: 08/15/2013 13:22:58

Installation directory: D:\Documents and Settings\Administrador\Datos de programa\IBM\IBM Endpoint Manager Excel Connector 3.3.3\

Registrator version: 7.2.4055.0

Operating System: Microsoft Windows XP Professional Service Pack 3 (build 2600)

Process Owner: Administrator

Command Line: “D:\Documents and Settings\Administrador\Datos de programa\IBM\IBM Endpoint Manager Excel Connector 3.3.3\adxregistrator.exe” /install=“BigFixExcelConnector.dll” /privileges=user

Run ‘As Administrator’: Yes

Process Elevated: No

Integrity Level: Untrusted

UAC (User Account Control): Off

13:22:58 0076 Starting the add-in registration process.

13:22:58 0076 Loading mscoree.dll

13:22:58 0076 Success.

13:22:58 0076 .NET Framework installation directory:

13:22:58 0076 The latest version of .NET Framework: ‘v4.0.30319’

13:22:58 0076 Loading CLR: v4.0.30319.

13:22:58 0076 Calling CLRCreateInstance method.

13:22:58 0076 Success.

13:22:58 0076 Calling GetRuntime method.

13:22:58 0076 Success.

13:22:58 0076 Checking if the hosting API of .NET Framework v4.0 beta is installed.

13:22:58 0076 The hosting API is up to date.

13:22:58 0076 Calling GetInterface method for the CorRuntimeHost interface.

13:22:58 0076 Success.

13:22:58 0076 Starting CLR…

13:22:59 0076 Success.

13:22:59 0076 Getting the CLR version.

13:22:59 0076 The CLR v4.0.30319 has been initialized successfully.

13:22:59 0076 Creating a new domain setup.

13:22:59 0076 Success.

13:22:59 0076 Getting the add-in directory.

13:22:59 0076 Success. The directory is ‘D:\Documents and Settings\Administrador\Datos de programa\IBM\IBM Endpoint Manager Excel Connector 3.3.3’

13:22:59 0076 The ‘shadow copy’ is disabled.

13:22:59 0076 Creating a new application domain.

13:22:59 0076 Success.

13:22:59 0076 Getting the base directory for the domain.

13:22:59 0076 Success. The directory is ‘D:\Documents and Settings\Administrador\Datos de programa\IBM\IBM Endpoint Manager Excel Connector 3.3.3’.

13:22:59 0076 Searching for the Add-in Express core library.

13:22:59 0076 Success. The ‘AddinExpress.MSO.2005.dll’ file is found.

13:22:59 0076 Creating an instance of the ‘AddinExpress.Deployment.ADXRegistrator’ class.

13:22:59 0076 Assembly identity is ‘AddinExpress.MSO.2005’.

13:23:00 0076 Success.

13:23:00 0076 Unwrapping the instance of the ‘AddinExpress.Deployment.ADXRegistrator’ class.

13:23:00 0076 Success.

13:23:00 0076 Calling the managed registration procedure.

13:23:00 0420 Connecting to the application domain of the Add-in Express loader.

13:23:00 0420 Success.

13:23:00 0420 Loading the ‘bigfixexcelconnector.dll’ assembly.

13:23:00 0420 Success.

13:23:00 0420 Registering the ‘bigfixexcelconnector.dll’ assembly (user).

13:23:02 0076 Managed Error:

(Inner Exception)

Date and Time: 15/08/2013 01:23:01 p.m.

Machine Name: HOSTNAME

IP Address: 10.123.xx.xx

Current User: HOSTNAME\Admin

Application Domain: D:\Documents and Settings\Administrador\Datos de programa\IBM\IBM Endpoint Manager Excel Connector 3.3.3\

Assembly Codebase:
file:///D:/Documents
and Settings/Administrador/Datos de programa/IBM/IBM Endpoint Manager Excel Connector 3.3.3/AddinExpress.MSO.2005.DLL

Assembly Full Name: AddinExpress.MSO.2005, Version=7.2.4055.2005, Culture=neutral, PublicKeyToken=4416dd98f0861965

Assembly Version: 7.2.4055.2005

Exception Source:

Exception Type: System.IO.FileLoadException

Exception Message: The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Exception Target Site: Object reference not set to an instance of an object.

---- Stack Trace ----

(Outer Exception)

Date and Time: 15/08/2013 01:23:02 p.m.

Machine Name: HOSTNAME

IP Address: 10.123.xx.xx

Current User: HOSTNAME\Admin

Application Domain: D:\Documents and Settings\Administrador\Datos de programa\IBM\IBM Endpoint Manager Excel Connector 3.3.3\

Assembly Codebase:
file:///C:/WINDOWS/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

Assembly Full Name: mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Assembly Version: 4.0.0.0

Exception Source: mscorlib

Exception Type: System.IO.FileLoadException

Exception Message: Could not load file or assembly ‘System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Exception Target Site: GetExportedTypes

---- Stack Trace ----

System.Reflection.RuntimeAssembly.GetExportedTypes(assembly As RuntimeAssembly, retTypes As ObjectHandleOnStack)

   mscorlib.dll: N 00000 (0x0) JIT

System.Reflection.RuntimeAssembly.GetExportedTypes()

   mscorlib.dll: N 0000 (0x0) IL

AddinExpress.Projects.Common.Utilities.GetRegistrableTypesInAssembly(assembly As Assembly)

   mscorlib.dll: N 0006 (0x6) IL

AddinExpress.Projects.Common.Utilities.RegisterAssembly(assembly As Assembly, createVersionKey As Boolean, allUsers As Boolean, targetHive As ADXTargetRegistryHive, callRegMethod As Boolean)

   mscorlib.dll: N 0000 (0x0) IL

AddinExpress.Deployment.AddinDomainAdapter.RegisterForComInterop(register As Boolean, dllType As String, dllPath As String, showExceptions As Boolean, logFullPath As String)

   mscorlib.dll: N 0228 (0xE4) IL

AddinExpress.Deployment.ADXRegistrator.RegisterAssembly(commandLine As String)

   mscorlib.dll: N 0437 (0x1B5) IL

13:23:02 0076 The add-in registration process is completed with HRESULT = -2147467259.