IBM Support

"Conversion from string "" to type 'integer' is not valid ... Input string was not in a correct format" error logging on from Excel (when using Windows Authentication), triggered by the end user having invalid LLOCALE

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':
 
image 4012
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:
image 4009

Initially this seems to have worked, but then an error message appears:
image 4010
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):
image 4011

If the user clicks 'Log on...' then this error appears:
image 4012
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.

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