9.1 SP4 Not connecting to Server

Post Reply
par3
Posts: 82
Joined: Tue Sep 09, 2008 7:05 am

9.1 SP4 Not connecting to Server

Post by par3 »

Hi All,

We have recently upgraded a server to 9.1 Sp4 (64bit edition) as well as the clients to 9.1 Sp4. The problem however is that the clients are now not able to "see" the server.

Path to the admin host is still correct.

Any clue's on wht this may happen?


Thanx People!
belair22
Posts: 68
Joined: Wed Feb 25, 2009 2:26 am
OLAP Product: TM1, Cognos Express
Version: 9.5 9.4 9.1 9.0 8.4
Excel Version: 2007 2003

Re: 9.1 SP4 Not connecting to Server

Post by belair22 »

Without knowing what version you upgraded from its difficult to determine where the problem lies.

At a guess I'd say it's a change to client settings - speficially the certificate Path - need to change it from C:\program files\applix\ssl\..... to C:\program files\cognos\.... (through Perspectives/Server Explorer).
User avatar
Steve Rowe
Site Admin
Posts: 2455
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: 9.1 SP4 Not connecting to Server

Post by Steve Rowe »

Hi par3,

Sounds pretty scary! Did this happen in your test upgrade?

What's the problem? Are the log ins being refused or is the server not visible in the server explorer?

If the server is not visible then
1.Check that the server is actually running by looking in the services of the 64 bit box!
2.Double check that the box name is what you think it is and that this is what in the admin host.
3.Ping the Tm1 server box from the client, if this does not work then you have some kind of network issue and raise with IT. If the ping does work try using the ip address instead of the name.

All a bit obvious I suppose but not sure what else the problem could be...

Cheers
Technical Director
www.infocat.co.uk
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

Re: 9.1 SP4 Not connecting to Server

Post by Herman Moller »

Par3,

It sounds like it could also be a firewall issue?

Check the firewall ports to see if this could be blocking your tm1 connection.

Examine the TM1 Admin Server SSL connection which is normally port 5498.

Regards

Herman
par3
Posts: 82
Joined: Tue Sep 09, 2008 7:05 am

Re: 9.1 SP4 Not connecting to Server

Post by par3 »

Hi Guys,

We upgraded from 9.1 Sp3.

The servername in the admin host box is definitely correct.

The port number in the config file is not as you mentioned Herman but does it make difference?

The other interesting thing is that Tm1 Web still works fine as well as our remote desktop connection to the server.
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

Re: 9.1 SP4 Not connecting to Server

Post by Herman Moller »

Par3,

The port number is not in the config file.

Re run the install on the server machine and examine the attached screenshot.

The TM1 Admin server SSL port should be 5498.

If this number is different this could be your problem.

Herman
Attachments
SSL Port.GIF
SSL Port.GIF (15.63 KiB) Viewed 9082 times
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

Re: 9.1 SP4 Not connecting to Server

Post by Herman Moller »

Par3,

I would also like to add because you can see the TM1 server on the Server, but no where else makes me think its is still a firewall issue. Try the following on the server.

Go to Windows Firewall and choose exceptions.

Choose a port number as below:

5498

If you open up this port from the firewall see if the user can now see the TM1 server.

Attached another screenshot below.

HTH

Herman
Attachments
SSL FireWall.GIF
SSL FireWall.GIF (26.33 KiB) Viewed 9078 times
par3
Posts: 82
Joined: Tue Sep 09, 2008 7:05 am

Re: 9.1 SP4 Not connecting to Server

Post by par3 »

Thanx Herman!

I tried everything you suggested but no cigar. Interestingly one of the other users can see the server but the other 3 can't.

Have any more ideas?
par3
Posts: 82
Joined: Tue Sep 09, 2008 7:05 am

Re: 9.1 SP4 Not connecting to Server

Post by par3 »

Wait, my mistake!

No users can see the server.
par3
Posts: 82
Joined: Tue Sep 09, 2008 7:05 am

Re: 9.1 SP4 Not connecting to Server

Post by par3 »

Hello again,

OK I have tried everything mentioned in your replies, and lastly I turned off the firewall but still no luck.

Does anyone have further ideas PLEASE!!!!!
User avatar
Steve Rowe
Site Admin
Posts: 2455
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: 9.1 SP4 Not connecting to Server

Post by Steve Rowe »

Hi Par3,

I'd raise with IBM or your VAR ASAP, without sitting in front of the box, I've exhausted my suggestions....
Technical Director
www.infocat.co.uk
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: 9.1 SP4 Not connecting to Server

Post by Martin Erlmoser »

you can try "%programfiles%\Cognos\tm1\bin\ssl\importsslcert.exe"
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: 9.1 SP4 Not connecting to Server

Post by Steve Vincent »

I've a sneaky feeling i might know the answer to this. If your previous setup worked fine and the server config has not changed, then its not very likely to be firewall or SSL issues. What it could be tho is a setting in the server config file that dictates which client versions are allowed to connect.

Code: Select all

ClientVersionMaximum = 9.0.2
ClientVersionMinimum = 9.0.0
If you have either of those set, try commenting them out and restarting the server. I know from trying to help test someone elses server (they were on 9.1 i'm on 9.0) that if they are wrong you won't be able to see the server in server explorer.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Post Reply