Page 1 of 1

TI process which last long time and TM1Web = error

Posted: Fri Mar 09, 2012 7:44 am
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?

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

Posted: Fri Mar 09, 2012 12:23 pm
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.

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

Posted: Fri Mar 09, 2012 1:50 pm
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

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

Posted: Fri Mar 09, 2012 5:31 pm
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

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

Posted: Sat Mar 10, 2012 4:35 pm
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