Restarting TM1 Server Automatically

Post Reply
crash0verride
Posts: 5
Joined: Mon Oct 20, 2008 10:03 am
Version: TM1 9.0.1.181 SP3
Excel Version: MS Excel 2003 SP3
Location: Manila, Philippines

Restarting TM1 Server Automatically

Post by crash0verride »

Our server is now suffering from an "Out of memory" issue. We are using 32bit OS and we understand that we really reached the limit during processing. I know one way to resolve this is to restart the tm1 server / recycle the memory but I don't want to keep on restarting this once everyday. Is there a way to schedule a restart of TM1 Server so it will be automatically restarted once a day? Please help. thanks in advance
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Restarting TM1 Server Automatically

Post by Martin Ryan »

Are you running as a service? If so, there's some ideas here: http://applixforum.olapforums.com/viewP ... adID=12802

If you're running as an application then no, there's no way to automatically restart.

HTH,
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Restarting TM1 Server Automatically

Post by lotsaram »

I'm sure it's in the link Martin posted but the most common way is to use a batch file called by the ExecuteCommand function in TI script.

Batch file very simple just:
Net Stop "tm1 service name"
Net Start "tm1 service name"

If the batch file is in the root directory of the tm1 database directory then only the file name needs to be passed without any path.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
TJMurphy
Posts: 74
Joined: Mon May 12, 2008 12:25 pm
OLAP Product: TM1
Version: PA 2.0.6 Local
Excel Version: Excel 2016

Re: Restarting TM1 Server Automatically

Post by TJMurphy »

We had a play with the "Restart.bat" approach mentioned on that thread, on a test system. In my experience it was more reliable if you did a "SaveDataAll" first. I guess it's a timing issue, the batch file gave up waiting for the cubes to save and hit the start bit too early. Anyone else have a similar experience?
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Restarting TM1 Server Automatically

Post by Alan Kirk »

TJMurphy wrote:We had a play with the "Restart.bat" approach mentioned on that thread, on a test system. In my experience it was more reliable if you did a "SaveDataAll" first. I guess it's a timing issue, the batch file gave up waiting for the cubes to save and hit the start bit too early. Anyone else have a similar experience?
Yup, since we moved from applications to services a couplea-few months back. The very first time I did a shutdown (manual, not by batch file) I expected it to finish saving then shut down in a nice orderly fashion.

It didn't happen that way.

If all of our cubes need saving then it can take 5 or 6 minutes to finish the process. Long before then I got an error 1053 (from memory) - something along the lines of "the service did not stop in a timely fashion". At that point it just left me with a half-saved .cu$ file from the cube that it was working on at the time. When I cleared the dialog the service started up again but of course it had to reload everything from the log files.

Ever since then I've just made sure that I've done a data save first. Being on 8.2.12 using SaveDataAll in a TI isn't an option for us since it will periodically freeze your server. Accordingly I haven't experimented with using Net Stop.

It does sound like your problem was similar to mine; it may not have been that the Start happened too early but rather that the Stop gave up on trying to save the cubes.

I do recall (dimly) reading something in Windows documentation about how you can increase the wait time for services, but it hasn't been a high enough priority for me to try to track it down again. If I find it, I'll post it.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply