TM1Web can not get TM1 Server after the SSL upgrade

Post Reply
kiss351523
Posts: 51
Joined: Thu May 05, 2011 2:05 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007 and 2003
Location: Asia

TM1Web can not get TM1 Server after the SSL upgrade

Post by kiss351523 »

Dear All,

In accordance with the IBM document, the upgrade of the SSL, i can log in to server througth the Achitect, but there is a problem, access to TM1Web, can not get any TM1 Server in the droplist.

TM1 Version : 10.1
OS: Win2003
Web is IIS

Tks for all your help!!!!
Attachments
2.jpg
2.jpg (1.83 KiB) Viewed 6646 times
1.jpg
1.jpg (25.17 KiB) Viewed 6646 times
Last edited by kiss351523 on Fri Nov 25, 2016 10:26 am, edited 2 times in total.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: TM1Web can not get TM1 Server after the SSL upgrade

Post by gtonkin »

please confirm the version of TM1 you are experiencing this issue on.
kiss351523
Posts: 51
Joined: Thu May 05, 2011 2:05 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007 and 2003
Location: Asia

Re: TM1Web can not get TM1 Server after the SSL upgrade

Post by kiss351523 »

gtonkin wrote:please confirm the version of TM1 you are experiencing this issue on.
oh TM1 version:10.1, thanks.
dsproffitt
Posts: 66
Joined: Wed Jul 16, 2014 9:20 am
OLAP Product: All of them
Version: All of them
Excel Version: 2003 -2013

Re: TM1Web can not get TM1 Server after the SSL upgrade

Post by dsproffitt »

Have you added the certs to
1) Tomcat folder
2) Java keystore
3) Windows Keystore

HAve you recycled the Tomcat working directory?
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: TM1Web can not get TM1 Server after the SSL upgrade

Post by Alan Kirk »

dsproffitt wrote:Have you added the certs to
1) Tomcat folder
...
HAve you recycled the Tomcat working directory?
Isn't 10.1 still on IIS? I thought that the move to Tomcat came at 10.2. (Which is why I thought it odd that there was an instruction about Tomcat in the 9.5.x manual update instructions.)
kiss351523 wrote:
gtonkin wrote:please confirm the version of TM1 you are experiencing this issue on.
oh TM1 version:10.1, thanks.
Can you update your profile, please? (Via the User Control Panel that drops down from your name at the top right.) The main reason for having that field is so that people don't need to ask that question. Thanks.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
declanr
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: TM1Web can not get TM1 Server after the SSL upgrade

Post by declanr »

Might be wrong but I though 10.1 web is IIS but tomcat was used for some of the contributor stuff.
Declan Rodger
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: TM1Web can not get TM1 Server after the SSL upgrade

Post by gtonkin »

AFAIK, you just need to run the following from the command prompt, as admininistrator, in the SSL folder after stopping services and replacing the certifcates with the new ones.

Code: Select all

importsslcert.exe -remove
importsslcert.exe 
There is a lot more waffle in the IBM doc but not relevant.
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: TM1Web can not get TM1 Server after the SSL upgrade

Post by Alan Kirk »

gtonkin wrote:AFAIK, you just need to run the following from the command prompt, as admininistrator, in the SSL folder after stopping services and replacing the certifcates with the new ones.

Code: Select all

importsslcert.exe -remove
importsslcert.exe 
There is a lot more waffle in the IBM doc but not relevant.
That's correct, but if you don't do it then you won't be able to connect with Architect either. Yet the original poster claims that the latter is possible and it's only Web that isn't showing the list of servers.

Restarting the Web Publishing Service wouldn't be an entirely bad idea to see whether that rectifies it. I didn't explicitly do it but I rebooted the physical servers as a precaution and because they were overdue for it anyway, which amounted to the same thing. It doesn't cost anything to give it a shot.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: TM1Web can not get TM1 Server after the SSL upgrade

Post by gtonkin »

declanr wrote:Might be wrong but I though 10.1 web is IIS but tomcat was used for some of the contributor stuff.
I too may be wrong but think they piloted Ops Console on java on 10.1, so potentially this would require some update if configured and in use.
dsproffitt
Posts: 66
Joined: Wed Jul 16, 2014 9:20 am
OLAP Product: All of them
Version: All of them
Excel Version: 2003 -2013

Re: TM1Web can not get TM1 Server after the SSL upgrade

Post by dsproffitt »

Alan Kirk wrote:Isn't 10.1 still on IIS? I thought that the move to Tomcat came at 10.2. (Which is why I thought it odd that there was an instruction about Tomcat in the 9.5.x manual update instructions.)
It did .. apologies .. Must remember to read the WHOLE post .. :|
kiss351523
Posts: 51
Joined: Thu May 05, 2011 2:05 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007 and 2003
Location: Asia

Re: TM1Web can not get TM1 Server after the SSL upgrade

Post by kiss351523 »

I tried a variety of ways, still can not get the server list, very sadddddddddd :( :( :( :( :( :(
Post Reply