IBM Support

"'Controller_ExcelLink' has fired an exception" ... "System.NullReferenceException ... ConvertToXlMethodInfos" when enabling Excel link

Troubleshooting


Problem

User launches Excel. The Controller add-in is not visible - Specifically, the Controller COM addin does not successfully load. If the user tries to activate the Controller Excel link, and error appears.

Symptom

After launching Excel, if you try to activate the Controller Excel link, the following message is shown:

Date and Time: 4/5/2017 4:33:14 PM
Machine Name: PCNAME
IP Address: ::1
Current User: DOMAIN\username

Application Domain: C:\Program Files (x86)\IBM\IBM Cognos Controller\
Assembly Codebase: file:///C:/Program Files (x86)/IBM/IBM Cognos Controller/AddinExpress.MSO.2005.DLL
Assembly Full Name: AddinExpress.MSO.2005, Version=7.5.4072.2005,
Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 7.5.4072.2005

Exception Source: AddinExpress.MSO.2005
Exception Type: System.NullReferenceException
Exception Message: Object reference not set to an instance of an object.
Exception Target Site: ConvertToXlMethodInfos

---- Stack Trace ----
AddinExpress.MSO.ADXExcelMethodInfo.ConvertToXlMethodInfos
(methodInfos As List`1, functions As List`1)
AddinExpress.MSO.2005.DLL: N 0005 (0x5) IL
AddinExpress.MSO.ADXXLLModule.RegisterMethods(methods As List`1)
AddinExpress.MSO.2005.DLL: N 0000 (0x0) IL
AddinExpress.MSO.ADXXLLModule.autoOpen()
AddinExpress.MSO.2005.DLL: N 0781 (0x30D) IL

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Cognos Controller

Software version:
10.2.1

Operating system(s):
Windows

Document number:
562285

Modified date:
08 May 2025

UID

swg22004440

Manage My Notification Subscriptions