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 a Planning Analytic Workspace
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)
Cause
The problem may occur if the imported certificates are not in PEM format.
Resolving The Problem
Import all certificates into the Planning Analytics workspace in PEM format and run the paw_install_location>/scripts/process_certs.ps1 (Microsoft Windows Server 2016 OS) or process_certs.sh (Linux OS) script. Restart PAW containers.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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"}]
Was this topic helpful?
Document Information
Modified date:
24 March 2023
UID
ibm16966008