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?
TI process which last long time and TM1Web = error
-
- 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
- Attachments
-
- 01.jpg (26.42 KiB) Viewed 4180 times
-
- 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
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.
-
- 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
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
As far as I know VBA doesn't work with TM1Web
Anthony
That's no moon - that's a space station
That's no moon - that's a space station
-
- 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
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
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.
-
- 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
Thank you for answers but I found another reason:
It is parameter
in web.config
By Default it was 110
It is parameter
Code: Select all
httpRuntime executionTimeout=X
By Default it was 110