Troubleshooting
Problem
User launches the 'main' Controller client. User launches the 'Trial Balance with Drilldown' menu item, and then runs a TBwD report (to Excel)
- User keeps the TBwD Excel report open (visible), but launches a fresh/new copy of Excel.
Inside the new Excel, user tries to logon to Controller. An error appears.
Symptom
Inside Controller, user clicks "Group - Reports - Trial Balance with Drilldown..."

User chooses some selections/parameters, and then clicks "Send to Application":

Excel opens, and displays the relevant data.
If the user launches 'Task Manager' they will see that there is only one copy of EXCEL.EXE process running:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
User now launches Excel from the Start Menu.
If the user launches 'Task Manager' they will now see that there are two copies of the EXCEL.EXE process running:

Inside this 'new' Excel instance, the user then clicks on the 'Controller' add-in menu bar, and then clicks 'Log on...':

User types in their username/password:

An error appears:

User ADM already logged in to this database
========================
Depending on what the end user does not (in other words, what order they close the above screens) the following error may appear:

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 ---
========================

User chooses some selections/parameters, and then clicks "Send to Application":

Excel opens, and displays the relevant data.
-
- Notice (below) how the Controller add-in bar shows that 'Log on...' is greyed out (therefore the user is logged onto the Excel link):

If the user launches 'Task Manager' they will see that there is only one copy of EXCEL.EXE process running:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
User now launches Excel from the Start Menu.
- This causes a 'fresh' copy of Excel to start loading:

If the user launches 'Task Manager' they will now see that there are two copies of the EXCEL.EXE process running:

Inside this 'new' Excel instance, the user then clicks on the 'Controller' add-in menu bar, and then clicks 'Log on...':

User types in their username/password:

An error appears:

User ADM already logged in to this database
========================
Depending on what the end user does not (in other words, what order they close the above screens) the following error may appear:

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"},"ARM Category":[{"code":"a8m0z000000Gmx2AAC","label":"Error"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"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
Modified date:
09 May 2025
UID
swg22017327