IBM Support

'User XYZ already logged in to this database', triggered by closing Excel at the 'wrong' time earlier, solved by using EXCEL_EAGERLOAD

Troubleshooting


Problem

User intermittently receives 'User XYZ already logged in to this database' when using either 'Reports - Run' or 'Company - Data Entry Reported Values'.

This only occurs when the user has recently closed an Excel session at the 'wrong' time.

Symptom

User tries to either open a Data Entry form or run a report (via 'Reports - Run'). User receives a message similar to this:

image-20180823085717-1

     User XYZ already logged in to this database.

However, the problem will appear intermittent because it only occurs when certain tasks are performed (in a specific order!) prior to performing this task.

Example:

Below is one example of how to reproduce the problem. Naturally there are other potential methods to trigger the problem:

1. Close any open sessions/processes related to Excel/Controller (Excel.exe and ccr.exe)

2. Launch Excel, and create a brand-new (blank/empty) spreadsheet

[Alternatively, you may have an Excel spreadsheet open for a different reason - for example, you may have been running a Controller report recently]

If you look in 'Task Manager' now, inside 'Details' there is a process 'EXCEL.EXE' running
- Also, a copy of Excel is visibly running in Windows:

image-20180823090433-3
- This is as expected :-)

3. Minimise Excel (do not close it)

4. Now click "Company > Data entry Reported Values"

5. Now Close Excel (choose not to save your spreadsheet)

image-20180823090757-5

If you look in 'Task Manager' now, inside 'Details' there is still a process 'EXCEL.EXE' running
- HOWEVER, there is *no* copy of Excel is visibly running in Windows!

image-20180823090857-6

6. Now click "Reports - Run"

image-20180823091209-7

If you look in 'Task Manager' now, inside 'Details' there are *TWO* processes for 'EXCEL.EXE' running:

image-20180823091251-8

7. Choose some parameters, and click 'Send to application':

image-20180823091334-9

=> An error appears (as part of Excel): 

image-20180823091415-10

User XYZ already logged in

=========================================

Depending on the environment, if you click OK to that error, you may get a new error:

image-20180823091620-12

An error occurred when setting status to logged off.
Please save your work and restart excel.

image-20180823091611-11

Details:
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Security Error 1
   at Cognos.Controller.Proxy.SoapExtension.ServerExtension.ValidateNativeUser(SoapMessage& message)
   at Cognos.Controller.Proxy.SoapExtension.ServerExtension.ProcessMessage(SoapMessage message)
   at System.Web.Services.Protocols.SoapMessage.RunExtensions(SoapExtension[] extensions, Boolean throwOnException)
   at System.Web.Services.Protocols.SoapServerProtocol.CreateServerInstance()
   at System.Web.Services.Protocols.WebServiceHandler.Invoke()
   at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
   --- End of inner exception stack trace ---

=========================================

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3.1","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.

Document Information

Modified date:
09 May 2025

UID

ibm10728985