Request for Help, TM1 10.2.2 Architect does noch connect to all servers

Post Reply
Sebastian Ortlieb
Posts: 4
Joined: Fri Mar 31, 2017 5:51 am
OLAP Product: TM1
Version: 10.2.2 FP 6 /FP 7
Excel Version: 2013
Location: Frankfurt, Germany

Request for Help, TM1 10.2.2 Architect does noch connect to all servers

Post by Sebastian Ortlieb »

Hello everybody,

i do have a problem with TM1 Architect.

I have three different Servers. A DEV, INT and PRD Machine.
The DEV is a 10.2.2. FP 7, the other are 10.2.2 FP6 IF 1.
They all run on Windows Server 2013 R2

I can reach the Model with TM1 Architect from any of these Server to any Server.

From my Client with a 10.2.2 FP 7 Architect, and before with the 10.2.2. FP6 I can reach INT and PRD but I do not reach DEV.

As far as I can say, I am no network guy, port 5498 and 5495 are open in the internal LAN. Client and Server are in the same LAN. All Servers are installed with default ports. So I suppose it should not be a port Problem, especially everthing is reachable if it is not Client -> DEV.

I tried another client with the same result.

I am a bit puzzled how to further approach this topic. Do you have some suggestions on further testing to identify the cause of this behaviour? If there is some information missing please do ask.

Kind regards,
Sebastian
Sighurd
Posts: 30
Joined: Mon Oct 03, 2011 9:18 pm
OLAP Product: TM1
Version: 10.2.2fp6
Excel Version: 2016

Re: Request for Help, TM1 10.2.2 Architect does noch connect to all servers

Post by Sighurd »

I had a problem recently, when I could not connect to all servers from Client machine with Architect. The issue was with SSL certificates. We used an automated option to update certificates on client machine, but it did not work for some reason. After we did it again manually, the problem was gone.

I am not sure that this is your case though.
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Request for Help, TM1 10.2.2 Architect does noch connect to all servers

Post by Edward Stuart »

The DEV version is on Fix Pack 7? Was this working before Fix Pack 7 was applied?

Have you updated the SSL certificates by adjusting applixca.pem or by switching to Tm1_cav2?

Being able to access the environment between each server confuses things but it would be good to clarify the above.

Can you access TM1Web for each instance from the client machine?

Can you ping the DEV server from the client machine?
Sebastian Ortlieb
Posts: 4
Joined: Fri Mar 31, 2017 5:51 am
OLAP Product: TM1
Version: 10.2.2 FP 6 /FP 7
Excel Version: 2013
Location: Frankfurt, Germany

Re: Request for Help, TM1 10.2.2 Architect does noch connect to all servers

Post by Sebastian Ortlieb »

Thank you for your answers, I was away due to Easter.

Maybe i understood something wrong, but the FP should fix that ssl Problem, so no need for manually changing the ssl?

Besides the client is working with the servers which are FP6 IF 1 where we did change the ssl certificates on the servers.

As far as I have seen via mmc all certificates are the same version.
  • Yes, the DEV System is FP7 as the Client.
    No, I couldn’t reach it on Version FP6 IF 1 from the client
    All TM1 Web are reachable, the INT and PROD have a dedicated WEBHead, the DEV is a single machine Installation.
    Dev Server is pingable.
    DEV and INT Ports are the same.
    Perspective does show the same behavoiur as Architect. Here i do get an Error message that the DEV Server is "Unable to connect to TM! Admin Server".
    Path to Certificate is (FullPath)\cognos\tm1_64\bin\ssl\applixca.pem
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Request for Help, TM1 10.2.2 Architect does noch connect to all servers

Post by Edward Stuart »

Fix Pack 7 does resolve the SSL issue for clean installs.

Prior to Fix Pack 7 you had three choices:

- Amend admin host certificate number and update the certificate from applixca.pem to tm1_ca2.pem

- Run an update script from IBM to rebadge the existing applixca.pem script to work with existing client certificates

- Generate your own SSL certificates

The client and server had to have the same method applied or they would not connect.

My guess is that the Fix Pack 7 fix does not replicate exactly the scripted change as TM1Web works plus you can ping the server.

What method did you use to update the scripts?
Drg
Regular Participant
Posts: 159
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Request for Help, TM1 10.2.2 Architect does noch connect to all servers

Post by Drg »

architect before fix pack 5
do not show instance of service fp6 and higher...
Sebastian Ortlieb
Posts: 4
Joined: Fri Mar 31, 2017 5:51 am
OLAP Product: TM1
Version: 10.2.2 FP 6 /FP 7
Excel Version: 2013
Location: Frankfurt, Germany

Re: Request for Help, TM1 10.2.2 Architect does noch connect to all servers

Post by Sebastian Ortlieb »

Finally I stumbled over the issue.

I forget to use one of the #1 Rule: always double check your information.

The Windows firewall, which we usually do not use, was on. On INT and PRD somebody opened the correct ports but not on DEV. I still have no clue why it was possible to see the ports as open and why I could connect from INT and PRD to DEV.

After deactivating the Windows firewall all clients can connect to DEV.

thanks a lot four your help, it helped me to solve the issue.
Post Reply