Troubleshooting
Problem
When try to connect to any TM1 instance the error Bad gateway 502 error is displayed in Planning Analytics for Excel when a custom certificate is used in TM1 Data tier
Symptom
Cognos.Office.Tm1.Connections.Tm1WebException: The remote server returned an error: (502) Bad Gateway. ---> System.Net.WebException: The remote server returned an error: (502) Bad Gateway. at System.Net.HttpWebRequest.GetResponse() at Cognos.Office.Tm1.Connections.Tm1Request.GetResponse() --- End of inner exception stack trace --- at Cognos.Office.Tm1.Connections.Tm1Connection.HandleWebException(Tm1WebException x, Uri path) at Cognos.Office.Tm1.Connections.Tm1Connection.GetResponse(Tm1Request request) at Cognos.Office.Tm1.Connections.Tm1Connection.SendRequest(Tm1Request webRequest, AcceptReturnEnum returns) at Cognos.Office.Tm1.Connections.Tm1Connection.SendRequest(String method, String path, String postData, AcceptReturnEnum returns, Int32 timeout) at Cognos.Office.Tm1.Connections.Tm1Connection.Get(String path, AcceptReturnEnum file, Int32 timeout) at Cognos.Office.Tm1.OData.Providers.ServerConnection.MetadataFile() at Cognos.Office.Tm1.Providers.Tm1ServerAbilities..ctor(ODataConnection connection, String server) at Cognos.Office.Tm1.OData.Providers.ODataConnection.RefreshAbilities(String server, String path) at Cognos.Office.Tm1.OData.Providers.ODataConnection.GetAbilities(String server, String path) at Cognos.Office.Tm1.Providers.Tm1ServerAbilitiesProvider.HasDisplayInfo(String server) at Cognos.Office.Reporting.TM1.ServerMap.FormulaServerMappings.SetAbilities(FormulaServerInfo info) at Cognos.Office.Reporting.TM1.ServerMap.FormulaServerMappings.SetServer(String name, String uri) at Cognos.Office.Reporting.TM1.ShareManager.CommManager_OnLogOn(Object sender, LogOnEventArgs e) at System.EventHandler`1.Invoke(Object sender, TEventArgs e) at Cognos.Office.Framework.Communications.DataSourceManager.ds_LogOnEvent(Object sender, LogOnEventArgs e) at System.EventHandler`1.Invoke(Object sender, TEventArgs e) at Cognos.Office.Tm1.Tm1DataSource.On_LogOn(String server) at Cognos.Office.Tm1.Tm1DataSource.Logon(LogonType logonType, DataSourcePropertiesCollection properties) at Cognos.Office.Framework.Communications.DataSourceManager.LogOn(String dsType, String connectionString, String serverName, IDataSource& source)
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzK7AAK","label":"Planning Analytics-\u003ESecurity-\u003ESSL"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Product":{"code":"SSKVSF","label":"Planning Analytics 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
ibm16966008