Troubleshooting
Problem
User runs a report (for example a journal across report). This displays OK on the screen. User now tries to send it to Excel. An error appears. However, if the user launches Excel directly (not from via Controller), user can see the Controller Add-in successfully registered (visible in Excel). User can successfully use the Controller Excel link (directly in Excel) to log in (and work with it - for example to run reports).
Symptom
Error message when trying to send a 'journal across' report to Excel:
The Cognos Controller Link is not installed
After clicking OK:
Standard Error
Details:
Number: 5
Source: mscorlib
Description: COM object that has been separated from its underlying RCW cannot be used
at System.RuntimeType.Invoke...
<...>
Cause
There are many different potential causes for the error "The Cognos Controller Link is not installed"
- For more examples, see separate IBM Technote #1396195.
This Technote specifically relates to the scenario where the cause is that the client device has a 64-bit version of Excel installed. This is unsupported for all versions of Controller before 10.3.
- TIP: A list of supported environments is available inside Technote #7014433.
Environment
Client device has a 64-bit version of Excel installed, but is using Controller 10.2.1 (or earlier)..
Resolving The Problem
Fix:
Upgrade to Controller 10.3 or later.
Workaround:
Uninstall the 64-bit version of MS Office from the client device.
- Afterwards, install a 32-bit version of MS Office.
Related Information
Was this topic helpful?
Document Information
Modified date:
22 November 2018
UID
swg21981289