Page 1 of 1

Slow Login in Architect

Posted: Fri Jun 07, 2019 12:14 pm
by macsir
Tm1 10.2.2 fp7
I noticed that for around two weeks, it will sometimes become very slow to login from Architect or Perspectives or Web. The Architect I was testing just sits on the TM1 server itself. Thus there shouldn't be any network issue. After a reboot, the duration of login went back to normal (less than 10 seconds). I am aware that the login duration is pretty much depend on the number of TM1 objects residing in the server.
However, after a period of time (days or weeks), it goes up to around 20 seconds, or 40 seconds or even 60 seconds randomly.
I checked the logs in every place and seems to be normal. No special findings. The only thing I can tell is when it happened, the server has many (~90-100) sessions concurrently although most of them are idle.
Could anyone share any idea on it? Thanks.

Re: Slow Login in Architect

Posted: Fri Jun 07, 2019 1:31 pm
by Edward Stuart
Which IntegratedSecurityMode are you using and are you using single sign on etc..?

Re: Slow Login in Architect

Posted: Fri Jun 07, 2019 4:18 pm
by gtonkin
Is there a difference when you use the server name vs the IP address? Have had numerous issues when the DNS is fritzed - it takes forever to connect the dots.

Re: Slow Login in Architect

Posted: Fri Jun 07, 2019 10:04 pm
by macsir
Edward Stuart wrote:
Fri Jun 07, 2019 1:31 pm
Which IntegratedSecurityMode are you using and are you using single sign on etc..?
Cam security mode 5 with sso. The cognos is installed on same server where TM1 is. Thanks.

Re: Slow Login in Architect

Posted: Fri Jun 07, 2019 10:05 pm
by macsir
gtonkin wrote:
Fri Jun 07, 2019 4:18 pm
Is there a difference when you use the server name vs the IP address? Have had numerous issues when the DNS is fritzed - it takes forever to connect the dots.
I tried using IP in architect. No difference and still slow. Thanks

Re: Slow Login in Architect

Posted: Mon Jun 10, 2019 12:11 pm
by Edward Stuart
Once you are logged in are there further issues or is it only login that sees the delays?

Do you have access to Cognos BI Security to see if anything odd is occuring at that end? My guess would be that the 'normal' identifiers for TM1 are clear so it could be a BI related issue?

Re: Slow Login in Architect

Posted: Mon Jun 10, 2019 8:55 pm
by macsir
Edward Stuart wrote:
Mon Jun 10, 2019 12:11 pm
Once you are logged in are there further issues or is it only login that sees the delays?

Do you have access to Cognos BI Security to see if anything odd is occuring at that end? My guess would be that the 'normal' identifiers for TM1 are clear so it could be a BI related issue?
Thanks, no further slowness issue after logged in as I observed.
I checked BI side and no special finding. What I can see from TM1 top is, after double clicking the server, it took around 5 seconds for showing "??? - SystemServerConnectWithCAM" and then after around 4 seconds, my logging name is shown correctly. After that, TM1 server took 1 or 2 seconds to show all objects. Therefore, the total duration is around 10 seconds now after a fresh reboot several days ago. Is it quite normal if someone can test it as well? Thanks. I don't think it is slow. When the issue really happened last time, the server took ages to show all objects after authenticating my user name with CAM.

Re: Slow Login in Architect

Posted: Mon Jun 10, 2019 8:56 pm
by macsir
By the way, TM1 web was also slow when I had the issue. Now it takes around 15 seconds to show applications and views after open the URL in Chrome.

Re: Slow Login in Architect

Posted: Tue Jun 11, 2019 11:34 am
by gtonkin
Anything suspicious in your tm1admsrv log files?

May be worthwhile adding some additional loggers in your tm1s-log.properties to see if there is anything untoward going on e.g.

Code: Select all

log4j.logger.TM1.Server.Network=DEBUG, STATS
log4j.appender.STATS=org.apache.log4j.SharedMemoryAppender
log4j.appender.STATS.MemorySize=5 MB
log4j.appender.STATS.File=tm1STATS.log
log4j.appender.STATS.MaxFileSize=5 MB
log4j.appender.STATS.MaxBackupIndex=5
log4j.appender.STATS.Timezone=Local
Have a look here for more loggers.

Re: Slow Login in Architect

Posted: Tue Jun 11, 2019 11:52 pm
by macsir
gtonkin wrote:
Tue Jun 11, 2019 11:34 am
Anything suspicious in your tm1admsrv log files?

May be worthwhile adding some additional loggers in your tm1s-log.properties to see if there is anything untoward going on e.g.

Code: Select all

log4j.logger.TM1.Server.Network=DEBUG, STATS
log4j.appender.STATS=org.apache.log4j.SharedMemoryAppender
log4j.appender.STATS.MemorySize=5 MB
log4j.appender.STATS.File=tm1STATS.log
log4j.appender.STATS.MaxFileSize=5 MB
log4j.appender.STATS.MaxBackupIndex=5
log4j.appender.STATS.Timezone=Local
Have a look here for more loggers.
Thanks, that's a good point. I will take action on them and report back.