TI process which last long time and TM1Web = error

Post Reply
EP_explorer
Regular Participant
Posts: 202
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

TI process which last long time and TM1Web = error

Post by EP_explorer »

I created TI process which copies data from one Cube to another. Copying takes some time (approximately 5 minutes)
Then I made an Excel file with a button which run TI process and put the Excel file with the button in Tm1 application and opened it in TM1Web.

So when I clicked the button in TM1Web TI process launched and window of TM1Web started refreshing. It lasted near 2 minutes (110 seconds precisely) and after it window of TM1Web showed error (you can see error in attachment). TI process meanwhile ended without problems after 5 minutes. Problem is in TM1Web

Also I can add - if TI process lasts less than than the time I pointed (1,5 minutes for example) everything is ok. It seems I should change some settings in IIS or somewhere else but I don't know where.

Can anybody help?
Attachments
01.jpg
01.jpg (26.42 KiB) Viewed 4179 times
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: TI process which last long time and TM1Web = error

Post by Duncan P »

The first place to look is the "Connection Time-out" property of the web site. How you find this and what the default value is will depend on which version of IIS you are running. If you do an internet search for the property (and IIS) you should find some help. Failing that post your version information here. On my machine (IIS 7.5 on Windows 7) the parameter is set to 120 seconds.
AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Re: TI process which last long time and TM1Web = error

Post by AnthonyT »

Just checking - the button you added and use to run the TI process, is it an Action Button or an Object with VBA code behind it

As far as I know VBA doesn't work with TM1Web
Anthony

That's no moon - that's a space station
nick10598109
Posts: 3
Joined: Sat Feb 25, 2012 12:06 am
OLAP Product: TM1
Version: All
Excel Version: All

Re: TI process which last long time and TM1Web = error

Post by nick10598109 »

Hi,

There are 3 things that can be ending your session by timeout:
(1) IIS Connection timeout (as mentioned above)
(2) TM1 Server IdleConnectionTimeoutSeconds variable in tm1s.cfg file
(3) TM1Web active session timeout in Web.config

See the documentation for more information:
http://publib.boulder.ibm.com/infocente ... 511A3.html
Last edited by nick10598109 on Mon Mar 12, 2012 1:38 am, edited 1 time in total.
EP_explorer
Regular Participant
Posts: 202
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: TI process which last long time and TM1Web = error

Post by EP_explorer »

Thank you for answers but I found another reason:

It is parameter

Code: Select all

httpRuntime executionTimeout=X 
in web.config

By Default it was 110
Post Reply