Using old clients with new planning analytics server
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Using old clients with new planning analytics server
Hi we are having client 10.1 and planning to connect with new planning analytics server . is this compatible and possible to use the old client with the new server . If anyone has achieved this please let us know .
Thanks,
Admin : see the linked post in this thread for the important post in this thread http://www.tm1forum.com/viewtopic.php?f ... 785#p68776
Thanks,
Admin : see the linked post in this thread for the important post in this thread http://www.tm1forum.com/viewtopic.php?f ... 785#p68776
- Elessar
- Community Contributor
- Posts: 412
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Using old clients with new planning analytics server
Hello! What do you mean by "client"? Architect, Perspectives, CAFE, Perf. Modeler, Cognos Insight?
Usually, you can connect using old clients to new server, but you should turn ON supportpretlsv12clients parameter in tm1s.cfg: http://www-01.ibm.com/support/docview.w ... wg27048181
Usually, you can connect using old clients to new server, but you should turn ON supportpretlsv12clients parameter in tm1s.cfg: http://www-01.ibm.com/support/docview.w ... wg27048181
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Re: Using old clients with new planning analytics server
Yes we want architecture to connect . We are in 10.1 and trying to connect to IBM Planning Analytics .
I have added the entry in the config file
SupportPreTLSv12Clients=T and restarted the server .
But the server shows up but we could not login to it .
I have added the entry in the config file
SupportPreTLSv12Clients=T and restarted the server .
But the server shows up but we could not login to it .
- Elessar
- Community Contributor
- Posts: 412
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Using old clients with new planning analytics server
What do you mean by "could not login"? The login window did not appear? Are there any errors?
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Re: Using old clients with new planning analytics server
we see the server on double clicking on the server nothing happens, Will not show me the login credentials to enter or log me in through integrated login . But it works with the new client .
I alos have additional parameter IPAddress= T
SupportPreTLSv12Clients=T
in the config files.
I alos have additional parameter IPAddress= T
SupportPreTLSv12Clients=T
in the config files.
Re: Using old clients with new planning analytics server
I think PAL and TM1 10.x use different security certificates, can you check the versions / sizes of applix.ca file in bin64/ssl folder for PA and 10.1 client?
Difference in ssl certs would look exactly as you describe (see the server, cannot connect). You can enable the Login logging in tm1 server to see whether there's a SSL handshake issue.
Cheers,
Y
Difference in ssl certs would look exactly as you describe (see the server, cannot connect). You can enable the Login logging in tm1 server to see whether there's a SSL handshake issue.
Cheers,
Y
-
- Posts: 30
- Joined: Tue Jun 07, 2011 8:30 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: 2016
Re: Using old clients with new planning analytics server
Having this same experience as well. We often use the older version of Perspectives/Architect to connect to the new and old version of servers during an upgrade project. We opened a ticket with IBM and they stated that Perspectives/Architect 10.1.x and 10.2.x will not be able to connect to PA Local 2.0.x whc.
Haven't looked into the SSL certs yet, but that does make sense.
Any other feedback on this?
Haven't looked into the SSL certs yet, but that does make sense.
Any other feedback on this?
Matthew Berson
ACG TM1 Consulting
ACG TM1 Consulting
- qml
- MVP
- Posts: 1096
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Using old clients with new planning analytics server
We have a PAL 2.0.4 server and our users are using a multitude of Perspective/Architect versions, going back as far as version 9.5.1. Here are the things that need to be done:
1) set the TM1 Admin server to support pre-TLS v1.2 clients via Cognos Configuration
2) add in tm1s.cfg:
3) copy ibmtm1.arm file from PA2 installed directory to bin/ssl and bin64/ssl folders of Perspectives/Architect installation (or, really, anywhere else on the client machine or a network share accessible from it)
4) change in TM1 Options in Perspectives/Architect:
Certicate Authority: full path to the copied ibmtm1.arm file
CertificateID: TM1Server (case-sensitive)
1) set the TM1 Admin server to support pre-TLS v1.2 clients via Cognos Configuration
2) add in tm1s.cfg:
Code: Select all
SupportPreTLSv12Clients=T
SSLCertificateID=TM1Server
SSLCertAuthority=ibmtm1.arm
4) change in TM1 Options in Perspectives/Architect:
Certicate Authority: full path to the copied ibmtm1.arm file
CertificateID: TM1Server (case-sensitive)
Last edited by qml on Mon Mar 26, 2018 3:12 pm, edited 1 time in total.
Kamil Arendt
-
- MVP
- Posts: 2835
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Using old clients with new planning analytics server
Can I recommend we put this post in the Tips and Tricks section? Great info, thanks.qml wrote: ↑Fri Mar 23, 2018 5:34 pm We have a PAL 2.0.4 server and our users are using a multitude of Perspective/Architect versions, going back as far as version 9.5.1. Here are the things that need to be done:
1) set the TM1 Admin server to support pre-TLS v1.2 clients via Cognos Configuration
2) add in tm1s.cfg:
SupportPreTLSv12Clients=T
SSLCertificateID=TM1Server
SSLCertAuthority=ibmtm1.arm
3) copy ibmtm1.arm file from PA2 installed directory to bin/ssl and bin64/ssl folders of Perspectives/Architect installation (or, really, anywhere else on the client machine or a network share accessible from it)
4) change in TM1 Options in Perspectives/Architect:
Certicate Authority: full path to the copied ibmtm1.arm file
CertificateID: TM1Server (case-sensitive)
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: Using old clients with new planning analytics server
Brilliant! Thanks for sharing. I got it working on my current 10.2.2 fp4 client to connect to PA2 server by changing the configurations above. Just need to remember to reboot your admin host after changing in Cognos Configuration.qml wrote: ↑Fri Mar 23, 2018 5:34 pm We have a PAL 2.0.4 server and our users are using a multitude of Perspective/Architect versions, going back as far as version 9.5.1. Here are the things that need to be done:
1) set the TM1 Admin server to support pre-TLS v1.2 clients via Cognos Configuration
2) add in tm1s.cfg:
SupportPreTLSv12Clients=T
SSLCertificateID=TM1Server
SSLCertAuthority=ibmtm1.arm
3) copy ibmtm1.arm file from PA2 installed directory to bin/ssl and bin64/ssl folders of Perspectives/Architect installation (or, really, anywhere else on the client machine or a network share accessible from it)
4) change in TM1 Options in Perspectives/Architect:
Certicate Authority: full path to the copied ibmtm1.arm file
CertificateID: TM1Server (case-sensitive)
A quick Q, is there any difference between the old client of V10 and PA client when connecting to PA2 server? Especially from end user point of view?
-
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Using old clients with new planning analytics server
Definitely +1 http://www.tm1forum.com/viewtopic.php?f ... 785#p68776
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Community Contributor
- Posts: 312
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Re: Using old clients with new planning analytics server
Just in case anyone else goes down the same rabbit hole:
Step 3 on Kamil's post implies (or at least it did to me) that you don't need to add the ibmtm1.arm file to the local install \ssl directory. Using 10.2 and 10.2.2 it wouldn't work for me unless that file is in the \ssl directory, no matter which directory I pointed the SSL Certificate Authority to.
Step 3 on Kamil's post implies (or at least it did to me) that you don't need to add the ibmtm1.arm file to the local install \ssl directory. Using 10.2 and 10.2.2 it wouldn't work for me unless that file is in the \ssl directory, no matter which directory I pointed the SSL Certificate Authority to.
Paul
- qml
- MVP
- Posts: 1096
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Using old clients with new planning analytics server
Hi Paul, that is interesting. My post was indeed meant to imply that you don't need to put the file in the ssl directory. In newer Windows versions Program Files is locked down and you'd need admin access to put any files in there, which is often not possible. In all my testing simply linking to an external, network share holding ibmtm1.arm worked without having to put the file in the ssl folder.Paul Segal wrote: ↑Tue May 08, 2018 1:29 pmStep 3 on Kamil's post implies (or at least it did to me) that you don't need to add the ibmtm1.arm file to the local install \ssl directory. Using 10.2 and 10.2.2 it wouldn't work for me unless that file is in the \ssl directory, no matter which directory I pointed the SSL Certificate Authority to.
Can you tell me more about your setup? Is it only Architect/Perspectives? Are you using any VBA or any other custom stuff?
Kamil Arendt
-
- Community Contributor
- Posts: 312
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Re: Using old clients with new planning analytics server
Hi Kamil,
The only non-vanilla thing is that this is running on Citrix, and the way this is set up I don't have access to the \ssl directory for the Citrix image to add the imbtm1.arm file. It is only Architect/Perspectives for the moment. I tried it on a local copy of TM1 and I had the same issue. Clients are 10.2 and 10.2.2. The only way I could get this to work was to set UseSSL=F on the server, and then the TM1 server instances are visible and I'm able to log in. If I don't do this, the instances are visible, but I get the hour glass and no login pop-up.
The only non-vanilla thing is that this is running on Citrix, and the way this is set up I don't have access to the \ssl directory for the Citrix image to add the imbtm1.arm file. It is only Architect/Perspectives for the moment. I tried it on a local copy of TM1 and I had the same issue. Clients are 10.2 and 10.2.2. The only way I could get this to work was to set UseSSL=F on the server, and then the TM1 server instances are visible and I'm able to log in. If I don't do this, the instances are visible, but I get the hour glass and no login pop-up.
Paul
-
- Posts: 110
- Joined: Wed May 20, 2009 7:30 am
- OLAP Product: TM1
- Version: 10.2.2 - PA
- Excel Version: 2010
- Location: Rennes, France
Re: Using old clients with new planning analytics server
Thank you very much, it worked perfectly well for me.qml wrote: ↑Fri Mar 23, 2018 5:34 pm We have a PAL 2.0.4 server and our users are using a multitude of Perspective/Architect versions, going back as far as version 9.5.1. Here are the things that need to be done:
1) set the TM1 Admin server to support pre-TLS v1.2 clients via Cognos Configuration
2) add in tm1s.cfg:3) copy ibmtm1.arm file from PA2 installed directory to bin/ssl and bin64/ssl folders of Perspectives/Architect installation (or, really, anywhere else on the client machine or a network share accessible from it)Code: Select all
SupportPreTLSv12Clients=T SSLCertificateID=TM1Server SSLCertAuthority=ibmtm1.arm
4) change in TM1 Options in Perspectives/Architect:
Certicate Authority: full path to the copied ibmtm1.arm file
CertificateID: TM1Server (case-sensitive)
But I have a question. Once I have done the step 4, I see my instances that are migrated to Planning Analytics. But I don't see any more 10.2.2 instances that are not migrated yet. Is there a way to see at the same time PA instances, and 10.2.2 instances ?
Thanks in advance
- qml
- MVP
- Posts: 1096
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Using old clients with new planning analytics server
Hi Catherine,Catherine wrote: ↑Tue Mar 12, 2019 10:36 am But I have a question. Once I have done the step 4, I see my instances that are migrated to Planning Analytics. But I don't see any more 10.2.2 instances that are not migrated yet. Is there a way to see at the same time PA instances, and 10.2.2 instances ?
Yes, you will need to change all the TM1 Options settings you changed in step 4 back to the original ones and you will then see the 10.2.2 servers. So you can't access both versions at the same time - you'll have to keep flipping your settings I'm afraid.
Kamil Arendt
-
- Posts: 4
- Joined: Tue May 13, 2014 8:38 pm
- OLAP Product: TM1
- Version: 2.0.6
- Excel Version: 2016
Re: Using old clients with new planning analytics server
Greetings,
while connecting to a TM1 server (PA 2.0.8) with a TM1 client (PA 2.0.6) is possible, is this a constellation supported by IBM?
while connecting to a TM1 server (PA 2.0.8) with a TM1 client (PA 2.0.6) is possible, is this a constellation supported by IBM?