About the PM, Prespective and Architect

Post Reply
Aruis.yu
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

Post by Aruis.yu »

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."
User avatar
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

Post by jim wood »

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
Aruis.yu
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

Post by Aruis.yu »

jim wood wrote:We'll need a little more info than that. For example are you using CAM?
http://www.tm1forum.com/viewtopic.php?f ... ect#p50678

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.
User avatar
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

Post by jim wood »

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
User avatar
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

Post by jim wood »

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
User avatar
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

Post by jim wood »

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
Aruis.yu
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

Post by Aruis.yu »

jim wood wrote:Which windows server version are you using??
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.
tomok
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

Post by tomok »

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?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
failurehappening
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

Post by failurehappening »

How far away (physically and network hops) is the desktop from the server?
RHR
Aruis.yu
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

Post by Aruis.yu »

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?
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.
Aruis.yu
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

Post by Aruis.yu »

failurehappening wrote:How far away (physically and network hops) is the desktop from the server?
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.
Aruis.yu
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

Post by Aruis.yu »

Aruis.yu wrote:
failurehappening wrote:How far away (physically and network hops) is the desktop from the server?
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.
Unfortunately, it doesn't catch any logs...
failurehappening
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

Post by failurehappening »

Aruis.yu wrote:
failurehappening wrote:How far away (physically and network hops) is the desktop from the server?
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.
Is the Data Center in the same city as you? How far away in km or miles?

If you run the command

Code: Select all

tracert {YOURSERVER} 
how many hops does it take to get from the desktop to the server?
RHR
Aruis.yu
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

Post by Aruis.yu »

failurehappening wrote:Is the Data Center in the same city as you? How far away in km or miles?

If you run the command

Code: Select all

tracert {YOURSERVER} 
how many hops does it take to get from the desktop to the server?
The data Center is not very far a away, it is in the same city. And tracert is about 8 steps.
Aruis.yu
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

Post by Aruis.yu »

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?

Aruis.yu wrote:
failurehappening wrote:Is the Data Center in the same city as you? How far away in km or miles?

If you run the command

Code: Select all

tracert {YOURSERVER} 
how many hops does it take to get from the desktop to the server?
The data Center is not very far a away, it is in the same city. And tracert is about 8 steps.
moby91
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

Post by moby91 »

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
BrianL
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

Post by BrianL »

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.
Aruis.yu
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

Post by Aruis.yu »

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".
Post Reply