Troubleshooting
Problem
User launches Excel. User clicks 'Controller - Log on'. An error occurs.
A similar error occurs if the user tries to click on the green 'X' button (Controller Link) from inside the main 'classic' client.
Problem may only occur for some 'bad' users.
Symptom
Scenario #1:
User launches Excel. User clicks 'Controller - Log on':

Conversion from string "" to type 'integer' is not valid ... Input string was not in a correct format
Scenario #2:
User launches 'classic' Controller client. User clicks green 'X' (Controller Link) to launch Excel:

Initially this seems to have worked, but then an error message appears:

User is already logged in to this database. Do you want to start a new session for this user?
If the user clicks "yes" then Excel appears, but the user is not logged on.
- You can tell that they are not logged on because the menu item "Log on..." is active (and "Log off" is greyed out):

If the user clicks 'Log on...' then this error appears:

Conversion from string "" to type 'integer' is not valid ... Input string was not in a correct format
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"ARM Category":[{"code":"a8m0z000000brYKAAY","label":"Installation"}],"ARM Case Number":"TS003763068","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","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.
Was this topic helpful?
Document Information
More support for:
IBM Cognos Controller
Component:
Installation
Software version:
All Version(s)
Document number:
6220228
Modified date:
09 May 2025
UID
ibm16220228
Manage My Notification Subscriptions