IBM Support

Error 'External component has thrown an exception' when launching Excel or Reports Run

Troubleshooting


Problem

User launches Controller, and clicks 'Reports - Run' or 'Reports - Create'. User receives error message. Problem also occurs if user launches Excel and uses the Controller Excel link menu to achieve the same task.

Symptom

There are many different potential errors that can occur, some are intermittent, for example:

Example #1

IBM Cognos 8 Controller Link


External component has thrown an exception.
OK

Example #2


CallFunc::GetIDsOfNames '...' returned 0x80020006

Example #3
Standard Error
Number: 458
Source: Microsoft.VisualBasic
Description: Bad variable type. (Excpetion from HRESULT: 0x80020008(DISP_E_BADVARTYPE))

Example #4


Standard Error
Number: -2147467261
Source: interop.Excel
Description: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Example #5


Standard Error
Number: 91
Source: Microsoft.VisualBasic
Description: Object variable or With block variable not set.
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Controller (Frango) 8.2","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.

Historical Number

1038109

Document Information

More support for:
IBM Cognos Controller

Software version:
Controller (Frango) 8.2

Operating system(s):
Windows

Document number:
375379

Modified date:
08 May 2025

UID

swg21347659

Manage My Notification Subscriptions