Troubleshooting
Problem
System was initially working OK (no problems/errors).
Customer then modifies the Microsoft networking TLS settings (on both the Controller application server and SQL database server) so that:
- TLS 1.0 disabled
- TLS 1.1 disabled
- TLS 1.2 enabled
After making those changes, user launches Controller client. User then:
- Chooses database
- Types in username/password
An error appears.
Symptom
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.) ---> System.ComponentModel.Win32Exception: An existing connection was forcibly closed by the remote host
--- End of inner exception stack trace ---
at Cognos.Controller.Proxy.ControllerReportNetService.RepNet.GetUserInfo(String sGuid, String sUser, String passportId)
at Cognos.Controller.Proxy.CCRWS.GetUserInfo(String sGuid, String sUser, String passportId)
--- End of inner exception stack trace ---
at Cognos.Controller.Forms.Common.Main.DoLoginCognos8(Form& frm)
at CCR.AppContext.DoLogin()
at CCR.AppContext.Login()
--- End of inner exception stack trace ---
at Cognos.Controller.Proxy.ControllerReportNetService.RepNet.GetUserInfo(String sGuid, String sUser, String passportId)
at Cognos.Controller.Proxy.CCRWS.GetUserInfo(String sGuid, String sUser, String passportId)
--- End of inner exception stack trace ---
at Cognos.Controller.Forms.Common.Main.DoLoginCognos8(Form& frm)
at CCR.AppContext.DoLogin()
at CCR.AppContext.Login()
Cause
The Controller application server cannot connect to the Microsoft SQL database server.
Example
In one real-life customer scenario, the cause was Microsoft patch KB4467697 (on the Controller application server).
Resolving The Problem
Fix:
Uninstall the Microsoft patch KB4467697 from the Controller application server:
Workaround:
Re-enable the TLS 1.0/1.1 protocols (on both the Controller application server and SQL database server).
Related Information
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
10 July 2019
UID
ibm10958757