How to install and configure TM1 Architect on Windows XP?

[abcuser]

Hi,
I have installed TM1 server v9.5.2 on Windows 2008 R2 64-bit (TM1 Admin server is also installed on the same Windows machine). I have also installed TM1 Architect v9.5.2 32-bit on the same computer. Started TM1 Architect and I can connect to TM1 server and see the cubes. So locally at server site everything is working fine (I can access computer with remote desktop and work just normally).

Now I would like to install TM1 Architect on my Windows XP sp3 notebook. I would like to develop cubes from my notebook (I don't need any Excel support, just a GUI do see cubes, write processes etc).

So from setup program I have selected TM1 and then selected custom, I have disabled all components except TM1 Architect and installed software. I have started the TM1 Architect GUI and selected File | Options and in Admin Host I have written IP address of TM1 Admin server and clicked on OK button to close TM1 Options window. In the list of tm1 servers in TM1 Architect is empty (no server appears in the TM1 server list). I pressed <F5> to refresh server list many times and list is still empty.

I have also stopped TM1 Architect on my notebook and then manually copied the tm1p.ini file from Windows-server to my notebook C:\Documents and Settings\[user_name]\Application Data\Applix\TM1 folder and started TM1 Architect, tm1 server list is still empty.

Do I need to install some other tm1 component beside TM1 Architect? Do I need to configure any other parameter?

P.S. I have checked and firewall on both computers are off. I can ping TM1 Admin server. I can also establish telnet communication with TM1 admin server (telnet ip_address 5495 - so TM1 admin server is up and listening). Also TM1 Admin server on remote computer is started, TM1 server is started and from inside of remote computer TM1 Architect can connect to TM1 Admin server.
Regards

[moby91]

P.S. I have checked and firewall on both computers are off. I can ping TM1 Admin server. I can also establish telnet communication with TM1 admin server (telnet ip_address 5495 - so TM1 admin server is up and listening). Also TM1 Admin server on remote computer is started, TM1 server is started and from inside of remote computer TM1 Architect can connect to TM1 Admin server.

5495 is the Default TCP port used by the TM1 Admin Server for unsecured communication.

5498 is the Default TCP port used by the TM1 Admin Server for secured communication.

As you are using TM1 9.5.2, by default all communication between TM1 components is secured by SSL encryption, thus you have to perform the telnet test against the TCP Port 5498.


What are the TCP Ports set in your TM1 server configuration file tm1s.cfg by the parameters PortNumber and ClientMessagePortNumber ?

What happens when you perform a telnet test against these two TCP Ports ?

[abcuser]

Hi,
I have searched one more time and I see both ports 5495 and 5498 are used by "TM1 admin".

TM1s.cfg PortNumber is set to 12345 and ClientMessagePortNumber is set to 12346.

I have tried to telnet to remote ports from my notebook:
telnet ip_address 5495
telnet ip_address 5498
telnet ip_address 12345
telnet ip_address 12346
All connections are responding fine.

See attached picture - task manager PIDs and tcp ports numbers match.

Is there any other settings that I need to be aware of?

P.S. Today I have also installed IBM Cognos Framework Manager on my notebook to make it possible to publish TM1 package to IBM Cognos Business Intelligence product. When I access TM1 "Data Source" from Framework Manager (inside of server using remote desktop) list of TM1 cubes are displayed. But if I try to access using Framework Manager on my notebook using the same TM1 Data Source I get error: "TM1-ERR-0055 The TM1 server 192.168.55.71 is no longer responding." So localy on server everything works fine, but from my notebook error is produced. It looks like very similar problem I am facing with two products from my notebook.

Regards

[rmackenzie]

I agree that this is a problem with the way SSL communications have been configured in your environment.

Do you have an SSL folder in your install, e.g. C:\Program Files\Cognos\TM1\bin\ssl\? This folder will contain all the necessary certificates and so forth to allow your client (Architect) to talk to the server over an encrypted channel.

The TM1 installer has always had inconsistencies and my guess here is that trying to selectively install Architect, and not Perspectives, doesn't install the SSL items. I would suggest that if you un-install and re-install and select either the standard or full-blown installs then this problem will disappear.

[abcuser]

Hi,
I have checked the C:\Program Files\Cognos\TM1\bin\ssl\ folder and it exists and *.pem files are stored in there.
Now I have uninstalled TM1 Architect from my notebook and installed whole TM1 typical install (so now on my notebook are installed: tm1 architect, tm1 all APIs, tm1 perspectives, tm1 client, tm1 admin server and tm1 server).
Opened TM1 Architect and set IP address of TM1 admin server settings in File | Options. Then exit Architect to make sure this settings are stored in tm1p.ini file. Opened this file and also set the CognosGatewayURI settings.
Disabled TM1 admin server and TM1 server on local notebook and started TM1 Architect. The same problem. The server list is empty.

Do I need to set some other settings in TM1 Architect or in tm1p.ini file or somewhere else?

I am attaching the TM1 Architect Options window and a tm1p.ini file.

P.S. On my notebook I have also installed Wireshart - IP filtering tool - and when I start TM1 Architect on my notebook there is no entry displayed into Wireshart, so it looks like TM1 Architect does not even access any remote server.
Regards

[moby91]

What about the Port 137 used by NetBios Names Service ?
Is it open for both TCP and UDP ?

[abcuser]

Hi,
I see netbios was disabled on my PC, I was strongly convinced that nowdays there isn't any service that uses NetBios protocol. So in Windows XP I enabled it back by:
1. Start | Settings | Control Panel | Network Connection.
2. Right click on "Local Area Connection" and selected Properties.
3. From connection list I have selected "Internet Protocol" and cliked Properties button.
4. Clicked on Advanced button.
5. Clicked on WINS tab and checked "Enable LMHOST lookup" and set "NetBIOS setting" to "Defaul".

Then I started TM1 Architect and now I see some network traffic on Wireshark on my PC (see attached picture) and also on Wireshark on my server. But TM1 Architect server list is still empty.

Any idea what else is wrong? Why doesn't TM1 Architect returns any error/warning? It is difficult to tract what is wrong if no info is returned.
Regards

[Martin Erlmoser]

copy the ssl folder from server to the client pc and modify the tm1p.ini according to the other ssl folder path, does it work?
turn off ssl on tm1server & adminserver and try again, does it work?
can you also post the "services" file %windir%\system32\drivers\etc (at least the tm1 section, maybe there is some crazy stuff in it)
what says procmon if you start tm1a ? Maybe some failures or denies?
if you use the "gui" tm1 adminserver instead of the service, is the tm1server in the list? (maybe you have to remove the tm1adminsrvd dependency of the tm1server in registry)

did you try it on another pc?

[mike_pvs]

Good day!

I have the same issue but with only difference that I'm trying to access TM1 using .Net API (Applix.TM1.API.dll). When I run test application on the server where TM1 is installed everything is working fine and I can obtain the list of servers. When I try the same on different server in the same network the list is empty. Both servers are Windows Server 2008 R2 x64.

Have you resolved your issue? If so then how?

[Alan Kirk]

I have the same issue but with only difference that I'm trying to access TM1 using .Net API (Applix.TM1.API.dll). When I run test application on the server where TM1 is installed everything is working fine and I can obtain the list of servers. When I try the same on different server in the same network the list is empty. Both servers are Windows Server 2008 R2 x64.

When you see hoof prints, first think horses, not zebras. It's possible that your problem is as arcane as port settings and SSL, but it's more probable that it's something more mundane.

- Have you checked that you have the Admin Host set correctly in your API application on the second server?
- Have you used a standard TM1 client (Excel Client / Perspectives / Architect) on the second server and confirmed that the standard client can get the list of servers from the Admin Server?
- If it can't, have you tried specifying the Admin Host by IP address rather than server name?
- Have you confirmed that both servers have the correct .Net Framework on them? (3.5 the last time I checked, and given the amount of development effort that Iboglix has (not) put into the .Net API since its release I doubt that has changed.)