TM1 instance doesn't show up in Perspectives list

[Learn_TM1]

Hi guys,

There is very strange situation by me. Our TM1 version is 10.2. Yesterday it worked fine. But today, one instance doesn't show up in Perspective list. I tried to restart its service. It is able to restart service. And the log file shows: TM1 Server is ready. I also tried to delete this instance in IBM Cognos Configuration, then add this instance again. The Configuration shows that the instance works fine. But the instance doesn't show up anyway.

The other instances on this server show correctly in Perspective list. Could someone help me out? Very urgent.

Best regards,

Learn_TM1

[pandinus]

Does the instance show when you fire up Architect on the server itself? In that case, the problem may be in the firewall configuration between the server and your PC.

[Learn_TM1]

Hi pandinus,

Thanks for your reply. Unfortunately the instance doesn't show in Perspectives on the server itself, too.

Best regards,

Learn_TM1

[Elessar]

1. Check "adminhost": maybe it points to another (eg. test) server
2. Check that the server is not still starting (there must be a "TM1 Server is ready" line it tm1server.log)

[Learn_TM1]

Hi Elessar,

Thanks for your tips.
1. The adminhost is correct, since all other instances on the same server show up correctly
2. tm1server.log also shows "TM1 Server is ready"

Best regards,

Learn_TM1

[mattgoff]

Also, make sure all TM1 servers have unique ports.

[gtonkin]

May be worthwhile checking in %systemroot%\System32\drivers\etc\services that the TM1 entries exist and are mapped to the correct ports:

Code: Select all

TM1     5495/tcp
TM1SSL  5498/tcp

These are probably correct as you are seeing other instances.
Try NETSTAT -a from the command prompt too to see what ports are listening and if they match the tm1s.cfg

[gtonkin]

Also, make sure all TM1 servers have unique ports.

I use the following batch script to try and check across the multiple systems I have configured on our dev server:

Code: Select all

@echo off
reg query HKLM\SYSTEM\ControlSet001\Services /S | FindStr ConfigPath >tm1.txt

FOR /F "tokens=3* delims=	 " %%S in (tm1.txt) do (

IF EXIST "%%S %%T\tm1s.cfg" (
	for /F "usebackq" %%P in (`type "%%S %%T\tm1s.cfg" ^|FindStr PortNumber`) do (
		echo %%P %%S %%T
	  )
    )
)

IF EXIST tm1.txt del /Q tm1.txt
PAUSE

It may return some errors due to long strings but generally writes out something you can read through and interpret and hoepfully find duplicate assignments.

[Learn_TM1]

Hi gtonkin,

Thanks for your help. I checked tm1s.cfg, and found that
PortNumber=12345
LDAPport=636

This number is not in the list, which comes from the command
NETSTAT -a

And in %systemroot%\System32\drivers\etc, the "services" file has no
TM1 5495/tcp
TM1SSL 5498/tcp

But it does have
ldaps 636/tcp sldap #LDAP over TLS/SSL

This server is a test server. There is also one production server, which is configured exactly same as test server. Fortunately, the production server has no such problem. Maybe because the TM1 instance is not restarted so frequently.

Best regards,

Learn_TM1

[Alan Kirk]

Hi gtonkin,

Thanks for your help. I checked tm1s.cfg, and found that
PortNumber=12345
LDAPport=636

...

This server is a test server. There is also one production server, which is configured exactly same as test server. Fortunately, the production server has no such problem. Maybe because the TM1 instance is not restarted so frequently.

When you say "is configured exactly same", do you mean that it too has the PortNumber of 12345 in its tm1s.cfg file? Because if so, that is the problem. As Matt Goff noted above, the Port Number MUST be unique for every server.

[Learn_TM1]

Hi Alan,

Thanks for your reply. I noticed that the tip Matt mentioned above. The port number should be unique for every TM1 server. However, the port number in my case is strange. It is 12345, which looks like a fake number. Is it O.K. to use the fake number as port number? Or should I change it to 5495 as above?

How should I handle %systemroot%\System32\drivers\etc, the "services" file. There is no
TM1 5495/tcp
TM1SSL 5498/tcp
in this file.

Best regards,

Learn_TM1

[Alan Kirk]

Hi Alan,

Thanks for your reply. I noticed that the tip Matt mentioned above. The port number should be unique for every TM1 server. However, the port number in my case is strange. It is 12345, which looks like a fake number. Is it O.K. to use the fake number as port number? Or should I change it to 5495 as above?

How should I handle %systemroot%\System32\drivers\etc, the "services" file. There is no
TM1 5495/tcp
TM1SSL 5498/tcp
in this file.

Best regards,

Learn_TM1

5495 is the port number used by the TM1 Admin server (not the TM1 server, but the ADMIN server, that is, the service that registers all running TM1 server instances) for non-SSL communication. 5498 is the port used by the ADMIN server for SSL communication.

With regard to the TM1 server itself, please see the installation documentation:

Cognos TM1 server port number: The port on which the Cognos TM1 server runs. This parameter is used to distinguish multiple Cognos TM1 servers running on the same computer. Valid port values fall between 5000 and 49151. The default is 12345. This value is set wih the PortNumber parameter in the Tm1s.cfg server configuration file.

So as Matt said, change the number on one of your servers. And as the manual says, the way you do that is by editing your tm1s.cfg file. It has nothing at all to do with the "services file". I would not recommend using 5495 or 5498, for reasons that should be obvious.

[Learn_TM1]

Hi Alan,

Our production server and test server are 2 separated physical computers. I think it should be O.K., if they has the same port number settings. But in the test server, which has the problem, there are multi TM1 instances. Unfortunately, there are 2 instances use the same port number 12345. All the other instances have their unique port number. It should be the root cause of the problem.

I will change the tm1s.cfg of one instance, so that it use other port number, instead of 12345.

Best regards,

Chunyan

[Alan Kirk]

Hi Alan,

Our production server and test server are 2 separated physical computers. I think it should be O.K., if they has the same port number settings.

Not if they point to the same Admin Server it won't be.

First thing you do when you set up a new TM1 system; make a list of port number assignments. Assign number ranges that will never coincide. NEVER use the same ones for two different servers, because the servers that run on different boxes today may not tomorrow, or next week, or next year.

[dsproffitt]

Is it registered in the pmpsvc_cong.xml file?
If not, then re-register in servername:port/pmpsvc

If it does, then remove it and then re-register in servername:port/pmpsvc

Are you running Planning Sample or SDAta as well. I cant remember which, but one of those runs on port 12345 the other on 12346
If that is running, then change your port number and restart the instance.
You can use any uncontended port number above 1023

[Alan Kirk]

Is it registered in the pmpsvc_cong.xml file?

I think you mean pmpsvc_config.xml, which is the Applications config file. However the question was about Perspectives, which does not use that file.

Are you running Planning Sample or SDAta as well. I cant remember which, but one of those runs on port 12345 the other on 12346
If that is running, then change your port number and restart the instance.
You can use any uncontended port number above 1023

I'm not saying that that absolutely won't work, but since the manual states (as noted above) that:

Valid port values fall between 5000 and 49151

I'd rather not tempt fate by wandering outside that range.

[gtonkin]

Another thing to check and let us know about is multiple IP addresses i.e. multiple NICs on the server-I have had issues where I have needed to update the TM1S.CFG with all IP Adresses allocated to the server to ensure connectivity.
Please run IPCONFIG and see if there are multiple active NICs with multiple IP Addresses assigned.