Product:
Planning Analytics 2.0.9.19
Pafe version 100 (IBM_PAfE_x86_2.0.100.3.xll)
Planning Analytics Workspace 100, or earlier versions.
Issue:
When you connect in PAX (Planning Analytics for Excel) to a TM1 server, you get a error for some of the TM1 instance you have on your server, but not all.
System.Net.WebException: The remote server returned an error: (502) Bad Gateway.
at System.Net.HttpWebRequest.GetResponse()
Solution:
Check the TM1S.CFG file for differences, between a working TM1 application and none working TM1 application.
If you use the command tlsCipherList in TM1S.CFG file, it must be on ONE line.
Above will give errors, but below line will not.
You need to ensure that all parameters in the file is on one line only.
Other possible solution, can be that the firewall is not open the ports needed between the PAW server and the TM1 server.
Check from the PAW server that you have access to the TM1 server on all needed TCP ports.
More Information: