About the PM, Prespective and Architect
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
About the PM, Prespective and Architect
Hi All:
Currently, I faced a problem. When I open the Architect and refresh the database in TM1, all the databases can be shown on the screen. But it will take a long time to the screen on entering the password unitl it shows the "Not responding".
The PM also found the same issue "Unable to connect to Planning Service."
Currently, I faced a problem. When I open the Architect and refresh the database in TM1, all the databases can be shown on the screen. But it will take a long time to the screen on entering the password unitl it shows the "Not responding".
The PM also found the same issue "Unable to connect to Planning Service."
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: About the PM, Prespective and Architect
We'll need a little more info than that. For example are you using CAM?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the PM, Prespective and Architect
http://www.tm1forum.com/viewtopic.php?f ... ect#p50678jim wood wrote:We'll need a little more info than that. For example are you using CAM?
I found my situation is quite similary with this one. I use the cafe to connect to the server and it can be visited(Beacuse I think the cafe authenication is based on the web). But when I use the Perspecitve and PM and Architect it will not pop the entering the passwd screen until it get the error "not responding". I had check with my firewall, all the ports is passed. But when I use the wireshark to catch the package from my client to server. The port like 60xxx always can't establish TCP connection with the server. So I have no idea now.
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: About the PM, Prespective and Architect
Where are you architect? On your machine or on the server? Have you tried on the server?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: About the PM, Prespective and Architect
Are you using DNS long names, short names or the IP address??
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: About the PM, Prespective and Architect
Which windows server version are you using??
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the PM, Prespective and Architect
Tthe architect on my server works fine. But on the remote machine can't work just as the mention above. I do the test both on DNS long name and IP address still not working. My windows server is 2008R2 and the remote desktop system is win7 enterprise.jim wood wrote:Which windows server version are you using??
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: About the PM, Prespective and Architect
How many TM1 server services are you running on your server machine? Did you remember to assign each one a different IP port in the tm1s.cfg?
-
- Posts: 78
- Joined: Tue Nov 30, 2010 1:18 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: About the PM, Prespective and Architect
How far away (physically and network hops) is the desktop from the server?
RHR
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the PM, Prespective and Architect
This is a new environment now. Only one TM1 server one port now. And I had check the port on my local desktop and found that it doesn't establish any listening status with the server.tomok wrote:How many TM1 server services are you running on your server machine? Did you remember to assign each one a different IP port in the tm1s.cfg?
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the PM, Prespective and Architect
The desktop is in office, and the server is in Data Center. Currenly I let the firewall team to extract some log whether there are any package pass the firewall.failurehappening wrote:How far away (physically and network hops) is the desktop from the server?
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the PM, Prespective and Architect
Unfortunately, it doesn't catch any logs...Aruis.yu wrote:The desktop is in office, and the server is in Data Center. Currenly I let the firewall team to extract some log whether there are any package pass the firewall.failurehappening wrote:How far away (physically and network hops) is the desktop from the server?
-
- Posts: 78
- Joined: Tue Nov 30, 2010 1:18 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: About the PM, Prespective and Architect
Is the Data Center in the same city as you? How far away in km or miles?Aruis.yu wrote:The desktop is in office, and the server is in Data Center. Currenly I let the firewall team to extract some log whether there are any package pass the firewall.failurehappening wrote:How far away (physically and network hops) is the desktop from the server?
If you run the command
Code: Select all
tracert {YOURSERVER}
RHR
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the PM, Prespective and Architect
The data Center is not very far a away, it is in the same city. And tracert is about 8 steps.failurehappening wrote:Is the Data Center in the same city as you? How far away in km or miles?
If you run the commandhow many hops does it take to get from the desktop to the server?Code: Select all
tracert {YOURSERVER}
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the PM, Prespective and Architect
Maybe I know the reason, but it still need some one who had the experience to help me.
Because maybe it is the firewall port. I only open the port 5495,5498,80,9300,9510,9513,9655,49152~65535,12345~12360. But there must some other invisible ports doesn't catch my eye. So Is there any one know this?
Because maybe it is the firewall port. I only open the port 5495,5498,80,9300,9510,9513,9655,49152~65535,12345~12360. But there must some other invisible ports doesn't catch my eye. So Is there any one know this?
Aruis.yu wrote:The data Center is not very far a away, it is in the same city. And tracert is about 8 steps.failurehappening wrote:Is the Data Center in the same city as you? How far away in km or miles?
If you run the commandhow many hops does it take to get from the desktop to the server?Code: Select all
tracert {YOURSERVER}
-
- MVP
- Posts: 227
- Joined: Fri Mar 11, 2011 2:18 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2003 2007
Re: About the PM, Prespective and Architect
Aruis.yu wrote:Maybe I know the reason, but it still need some one who had the experience to help me.
Because maybe it is the firewall port. I only open the port 5495,5498,80,9300,9510,9513,9655,49152~65535,12345~12360. But there must some other invisible ports doesn't catch my eye. So Is there any one know this?
Does your list of open TCP ports include the one used by the TM1 server configuration parameter ClientMessagePortNumber ?
What happens when you explicitely set ClientMessagePortNumber to a free TCP port being a member of your list of open TCP ports ?
If you run two or more TM1 instances on the same machine, every TM1 instance must have it's own unique ClientMessagePortNumber.
http://www-01.ibm.com/support/knowledge ... ation.html
TM1 Installation and Configuration Guide 10.2.2
Planning your Cognos TM1 installation >
Default installation values
http://www-01.ibm.com/support/knowledge ... rtNumber_1
TM1 Installation and Configuration Guide 10.2.2
The Tm1s.cfg Server Configuration File > Parameters in the Tm1s.cfg File >
ClientMessagePortNumber
-
- MVP
- Posts: 264
- Joined: Mon Nov 03, 2014 8:23 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2 PA2
- Excel Version: 2016
Re: About the PM, Prespective and Architect
Also see http://www-01.ibm.com/support/docview.w ... wg21459257.
Make sure whatever PortNumber is set to in your tm1s.cfg is open through the firewall.
Make sure whatever PortNumber is set to in your tm1s.cfg is open through the firewall.
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the PM, Prespective and Architect
BrianL wrote:Also see http://www-01.ibm.com/support/docview.w ... wg21459257.
Make sure whatever PortNumber is set to in your tm1s.cfg is open through the firewall.
Thanks. But actually in the final. The reason is not the port issue. It is a parameter in the .cfg need to config which is "IP ADDRESS".