TI process timing out in TM1Web

[kaazimraza]

Hi all,

I have a web sheet with a hyper link set to call a TI process. As the data size has grown, the turn around time for this TI process has increased as well. The weird part is that since a couple of days, whenever a user executes the TI process from the web sheet by clicking the link, after a point in time, nothing happens. I have looked at the server log file, and TM1 Top, and Ops Console, and it just shows a call to a bedrock process and nothing happens. My ultimate resolution is to kill the tm1sd process from task manager as I am not able to kill the thread from TM1 Top.

If I execute the same process from Architect, the process does end logically or the way it is supposed to end.

My environment is:

TM1 10.1.1
TM1 Web
IE 8
Excel Version 2010.
Windows 7 Professional

Thanks,

Kaz

[lotsaram]

One strategy that works well is to "release" the web session immediately by having the action button not run the data load process itself but rather use ExecuteCommand to run a batch file which in turn calls RunTI which does the data loading. That way the load runs in the background and there is no waiting in the user's session.

[kaazimraza]

One strategy that works well is to "release" the web session immediately by having the action button not run the data load process itself but rather use ExecuteCommand to run a batch file which in turn calls RunTI which does the data loading. That way the load runs in the background and there is no waiting in the user's session.

Hi Lotsaram

Thanks for the reply, it does make sense what you said but what makes me pondering is that why other processes are not timing out, and what's so special or wrong with this process itself. another thing is that from usability point of view, we'd like the end users to know that their data/numbers are updated. Making a call to a batch file to run the load process will push it in the background as opposed to the current strategy where clicking upon the action button tells them either the data is saved or process failed.

[amin]

2 Things:

1- Use batch file that calls data load TI. You then call another TI in the data load TI to send email notification, in epilog, so the user is aware the data load is complete.

2- Update the httpRuntime executionTimeout parameter in your web config file.

Hope that helps.

[kaazimraza]

Hi Amin

Thanks for the reply am going to check out the parameter. I have been able to resolve it by improving the ecexution time of the process. Earlier it was taking about 300 seconds when it was failing. Its now taking 120 seconds.