“TM1 Architect cannot connect to server.” You might get this error when you try to connect an old version of Architect or Perspectives to a Planning Analytics server. One of the quirks of TM1 is that old versions of Architect and Perspectives are able to connect to newer versions of TM1 or Planning Analytics, but NOT vice-versa (so you couldn’t, for example, connect Architect from Planning Analytics 2.0.9 to a TM1 10.2.2 model).
The configuration details for the new TM1 Analytics server are listed below. Don’t worry, you can change them back and forth whenever you need to between 10.2.x and PA.
Note also that in Excel, you cannot have Planning Analytics for Excel client active at the same time as Perspectives.
Steps to Connect Architect/Perspectives 10.2.2 to Planning Analytics Server
Planning Analytics Server Side
Step 1
Ensure you have entries in tm1s.cfg to match the following (obviously using the real IP address of the TM1/Planning Analytics server):
SupportPreTLSv12Clients=T
SSLCertificateID=TM1Server
SSLCertAuthority=ibmtm1.arm
IPAddressV4=xxx.xxx.xx.xx
Step 2
Update Cognos Configuration on the TM1/Planning Analytics server to reflect the “Support pre-TLS v1.2 clients” property is set to True.
Architect or Perspectives Client Side
Step 3
The next thing you need to do is save the attached certificate (ibmtm1.arm) in the installation folder on your hard drive, probably C:Program Filesibmcognostm1binssl. You will need to unzip the file first though!
Step 4
Open the Architect or Perspectives and select File>Options. Then populate:
- Admin Host
- Certificate Authority, and
- Certificate ID
with the details below and click OK twice. Then you should be right to go.
Connection Details
The first screen shot below is a current 10.2.2 version and the second is what you need to change the credentials to for the new one.
For TM1 10.2.2 (Perspectives and Architect)
The connection details for TM1 10.2.2 are listed below:
Admin Host: | dppctm1 |
Certificate Authority: | C:Program Filesibmcognostm1binsslapplixca.pem |
Certificate ID (Exact Case): | tm1adminserver |
For Planning Analytics
Then for Planning Analytics, here are the connection details:
Admin Host: | prdcpla1 |
Certificate Authority: | C:Program Filesibmcognostm1binsslibmtm1.arm |
Certificate ID (Exact Case): | TM1Server |