Troubleshooting
Problem
When using the IBM Cognos Controller excel plug-in together with the Microsoft Azure Information Protection plug-in each time the user closes excel, excel crashes.
Symptom
Both plug-ins are turned on and when closing excel it crashes and reopens. Once reopened, you might find the controller link plug-in was disabled, and needs to be manually enabled once again.
Cause
This issue is related to APAR PH38143.
Environment
The behavior has been encountered on all versions lower than 10.4.2.1.
Diagnosing The Problem
By using the steps in the workaround described below to disable the plug-in, it can be confirmed your excel crash is related to this compatibility issue.
Resolving The Problem
Solution
This issue (APAR PH38143) has been addressed in version 10.4.2.1 IF1.
It is recommended to update to that version of IBM Cognos Controller, or higher.
Please contact IBM Technical Support to request access to this specific interim fix (10.4.2.1 IF1) as it is not generally available.
Workaround
It is not possible to remove the controller COM plug-in without removing the Azure plug-in first. When you try to remove controller COM Addin, Excel closes and then reopens. However, you can Disable (untick) Azure COM plug-in, in File - Options - Addins, then clicking OK does just that (disables Azure addin). Excel stays open
- Then go back into the plug-ins and disable controller COM addin, click OK Excel stays open
- Then go back into the plug-ins and disable the controller Addin click OK Excel stays open
- Then go back into the plug-ins and enable the Azure COM addin click OK Excel stays open
- Close Excel. It does no reopen
It is recommended to update to that version of IBM Cognos Controller, or higher.
Please contact IBM Technical Support to request access to this specific interim fix (10.4.2.1 IF1) as it is not generally available.
Workaround
It is not possible to remove the controller COM plug-in without removing the Azure plug-in first. When you try to remove controller COM Addin, Excel closes and then reopens. However, you can Disable (untick) Azure COM plug-in, in File - Options - Addins, then clicking OK does just that (disables Azure addin). Excel stays open
- Then go back into the plug-ins and disable controller COM addin, click OK Excel stays open
- Then go back into the plug-ins and disable the controller Addin click OK Excel stays open
- Then go back into the plug-ins and enable the Azure COM addin click OK Excel stays open
- Close Excel. It does no reopen
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"ARM Category":[{"code":"a8m0z000000bnDIAAY","label":"APAR Incident"},{"code":"a8m0z000000bpIoAAI","label":"Controller-\u003EBA - Cognos Controller-\u003EExcel"}],"ARM Case Number":"TS006660845","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.2"}]
Was this topic helpful?
Document Information
Modified date:
10 November 2022
UID
ibm16838477