Hi All:
I have installed the AWS workspace recently and then installed the TM1 perspectives 64 bit client component. I can see the list of my TM1 servers in the perspectives but when I click on the server and it is not connecting. when I click on the server it showing that loading and disappearing it. I tried all the IBM suggestions but didnot work nothing.
https://www.ibm.com/support/pages/clien ... t-any-them
https://www.ibm.com/support/pages/n33-c ... rspectives
TM1 server version: Tm1 10.2.2
Really appreciated any help?
TM1 Client shows list of TM1 Servers but cannot connect to any of them
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
-
- Regular Participant
- Posts: 197
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: TM1 Client shows list of TM1 Servers but cannot connect to any of them
As your on 10.2.2 I would say either
a group policy is blocking the outdated cipher suite protocols that are used in 10.2.2
Or the IBM certificates are the original (expired ones). Any 10.2.2 install requires the certificates being updated after installation.
a group policy is blocking the outdated cipher suite protocols that are used in 10.2.2
Or the IBM certificates are the original (expired ones). Any 10.2.2 install requires the certificates being updated after installation.
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
Re: TM1 Client shows list of TM1 Servers but cannot connect to any of them
HI burnstripe, After perspective 64-bit installed, I couldn't see the TM1 servers. so, I need to copy over the SSL certificate files (below listed) and past it in bin64 directory and then I can see the TM1 servers in the perspectives. but I couldnot able to connect as per my initial thread
applixca
applixca.pem
applixcacrl
applixcacrl.pem
tm1admsvrcert.pem
tm1store
tm1svrcert.pem
applixca
applixca.pem
applixcacrl
applixcacrl.pem
tm1admsvrcert.pem
tm1store
tm1svrcert.pem
-
- MVP
- Posts: 3118
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 Client shows list of TM1 Servers but cannot connect to any of them
Why are you still using this version ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
Re: TM1 Client shows list of TM1 Servers but cannot connect to any of them
Hi Wim Gielis, Customer is planning to migrate to higher version in next year.
by the way I could able to findout issue. it is SSL issue that I need to update SSL then it worked. but I am getting different issue now:
My AWS is windows 10 and Excel version 2008/Office 365 and I installed the perspectives 64-bit (TM1 10.2.2). while opening my TM1 reports (VBA code/macros) for testing/input numbers then it is showing that incompatible (attached error). My question is, 32-bit perspectives would it support? Is there anyone come across similar issue?
by the way I could able to findout issue. it is SSL issue that I need to update SSL then it worked. but I am getting different issue now:
My AWS is windows 10 and Excel version 2008/Office 365 and I installed the perspectives 64-bit (TM1 10.2.2). while opening my TM1 reports (VBA code/macros) for testing/input numbers then it is showing that incompatible (attached error). My question is, 32-bit perspectives would it support? Is there anyone come across similar issue?
- Attachments
-
- VBA error.PNG (7.89 KiB) Viewed 4125 times
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 Client shows list of TM1 Servers but cannot connect to any of them
I am fairly certain Excel 2008 didn’t have a 64-bit option.mincharug.shulft wrote: ↑Fri Sep 24, 2021 6:31 pm My AWS is windows 10 and Excel version 2008/Office 365 and I installed the perspectives 64-bit (TM1 10.2.2). while opening my TM1 reports (VBA code/macros) for testing/input numbers then it is showing that incompatible (attached error). My question is, 32-bit perspectives would it support? Is there anyone come across similar issue?
You can only use 64-bit perspectives with 64-bit Excel.
So yes you will need to uninstall the 64-bit and then install the 32-bit version, or get a newer 64-bit Excel.
Declan Rodger