Page 1 of 1
TM1 instance doesn't show up in Perspectives list
Posted: Tue Jun 21, 2016 11:01 am
by 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
Re: TM1 instance doesn't show up in Perspectives list
Posted: Tue Jun 21, 2016 11:50 am
by 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.
Re: TM1 instance doesn't show up in Perspectives list
Posted: Tue Jun 21, 2016 11:53 am
by 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
Re: TM1 instance doesn't show up in Perspectives list
Posted: Tue Jun 21, 2016 12:07 pm
by 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)
Re: TM1 instance doesn't show up in Perspectives list
Posted: Tue Jun 21, 2016 12:14 pm
by 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
Re: TM1 instance doesn't show up in Perspectives list
Posted: Tue Jun 21, 2016 2:22 pm
by mattgoff
Also, make sure all TM1 servers have unique ports.
Re: TM1 instance doesn't show up in Perspectives list
Posted: Tue Jun 21, 2016 3:01 pm
by gtonkin
May be worthwhile checking in
%systemroot%\System32\drivers\etc\services that the TM1 entries exist and are mapped to the correct ports:
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
Re: TM1 instance doesn't show up in Perspectives list
Posted: Tue Jun 21, 2016 5:56 pm
by gtonkin
mattgoff wrote: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.
Re: TM1 instance doesn't show up in Perspectives list
Posted: Wed Jun 22, 2016 8:08 am
by 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
Re: TM1 instance doesn't show up in Perspectives list
Posted: Wed Jun 22, 2016 8:23 am
by Alan Kirk
Learn_TM1 wrote: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.
Re: TM1 instance doesn't show up in Perspectives list
Posted: Wed Jun 22, 2016 9:03 am
by 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
Re: TM1 instance doesn't show up in Perspectives list
Posted: Wed Jun 22, 2016 9:13 am
by Alan Kirk
Learn_TM1 wrote: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:
TM1 Installation Manual wrote: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.
Re: TM1 instance doesn't show up in Perspectives list
Posted: Wed Jun 22, 2016 9:23 am
by 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
Re: TM1 instance doesn't show up in Perspectives list
Posted: Wed Jun 22, 2016 9:26 am
by Alan Kirk
Learn_TM1 wrote: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.
Re: TM1 instance doesn't show up in Perspectives list
Posted: Fri Jun 24, 2016 4:52 am
by 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
Re: TM1 instance doesn't show up in Perspectives list
Posted: Fri Jun 24, 2016 5:01 am
by Alan Kirk
dsproffitt wrote: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.
dsproffitt wrote: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:
Tm1 Installation Manual wrote:Valid port values fall between 5000 and 49151
I'd rather not tempt fate by wandering outside that range.
Re: TM1 instance doesn't show up in Perspectives list
Posted: Fri Jun 24, 2016 5:21 am
by 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.