Hi
I have my TM1 server running as a windows service.
If I make changes (like changing a value) and then Stop the service, TM1 automatically saves this change.
Is there a way to avoid this behavior???
Thanks
Disable autosaving??
- 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: Disable autosaving??
I can't see how; if there were such an option it would be way too easy to allow the service to shut down without doing the changes when you really wanted it to.armas wrote: I have my TM1 server running as a windows service.
If I make changes (like changing a value) and then Stop the service, TM1 automatically saves this change.
Is there a way to avoid this behavior???
The only workaround that I can think of is to:
- Go to the Windows server task manager;
- Kill the process relating to the service; and
- Move the tm1s.log file out of its folder before you restart the service so that it won't reload.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Regular Participant
- Posts: 152
- Joined: Fri May 23, 2008 12:08 am
- OLAP Product: TM1 CX
- Version: 9.5 9.4.1 9.1.4 9.0 8.4
- Excel Version: 2003 2007
- Location: Melbourne, Australia
- Contact:
Re: Disable autosaving??
There are 2 options that I can think of that are less severe than killing the process and moving the log file.
1/ Run tm1 as an application rather than a service, then on server load you will be prompted whether to load the log file or not
2/ Turn cube logging off!
(Although I have to say that loading log files to restore the server in the event of not saving before the server goes down is functionality that most people would want! I am curious as to why you would not want this default functionality?)
1/ Run tm1 as an application rather than a service, then on server load you will be prompted whether to load the log file or not
2/ Turn cube logging off!
(Although I have to say that loading log files to restore the server in the event of not saving before the server goes down is functionality that most people would want! I am curious as to why you would not want this default functionality?)
- Olivier
- Community Contributor
- Posts: 159
- Joined: Thu Jun 26, 2008 5:46 am
- OLAP Product: TM1
- Version: Tm1 10.2.2fp4 -> 2.09
- Excel Version: Excel 2013 - 2019
- Location: Sydney
Re: Disable autosaving??
Same here .)I am curious as to why you would not want this default functionality?)
I can't imagine why you would have this turned off ?
Olivier
HTH
Olivier
Olivier
-
- Community Contributor
- Posts: 125
- Joined: Wed May 28, 2008 1:22 pm
- OLAP Product: TM1, Cognos Express,..
- Version: 9.1.4 FP1
- Excel Version: 2010
- Location: Vienna
- Contact:
Re: Disable autosaving??
don't understand why you don't want this feature (i think this is a real feature .. not one of the bug features)armas wrote:Hi
I have my TM1 server running as a windows service.
If I make changes (like changing a value) and then Stop the service, TM1 automatically saves this change.
Is there a way to avoid this behavior???
Thanks
- some older versions didn't save the db when stopping the tm1service( you can downgrade )
- kill the tm1process with the taskmgr / killprocess command
the question is what's your objective..
- 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: Disable autosaving??
Well, yeah... but it's a little late if he's already RUNNING it as a service and has logged the transactions, and needs to know how to do it for the current session.ScottW wrote:There are 2 options that I can think of that are less severe than killing the process and moving the log file.
1/ Run tm1 as an application rather than a service, then on server load you will be prompted whether to load the log file or not
2/ Turn cube logging off!
As a future option it's certainly viable.
(Though I think you mean, say "No" when asked whether you want to save changes when you shut down the server. You're only asked the question on server load if the previous session crashed and the tm1s.log wasn't renamed, and therefore still exists.)
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Re: Disable autosaving??
Thanks all
I had never really thought about doing this before until I sent a great amount of values to a certaing cube, through an Excel file, then lost that file and realized those values were not correct at all and I was not able to recall the exact locations where those values were sent.
Or probably there is a way to roll back??
I had never really thought about doing this before until I sent a great amount of values to a certaing cube, through an Excel file, then lost that file and realized those values were not correct at all and I was not able to recall the exact locations where those values were sent.
Or probably there is a way to roll back??
- 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: Disable autosaving??
Yep. If you're logged in as an administrator:
- Right click on the server
- Select "View Transaction Log"
- Fill out the details. Choose since when you wish to see changes, the cube and you can narrow the area of the cube down too but note it's a case of one element or all of them in each dimension.
- Note the server time is in GMT
- Click ok
- Go to Edit -> Select All
- Go to Edit -> Back out
They're all backed out.
Often a good idea to back the server up before you do this, particularly as it's the first time you've done it.
Cheers,
Martin
- Right click on the server
- Select "View Transaction Log"
- Fill out the details. Choose since when you wish to see changes, the cube and you can narrow the area of the cube down too but note it's a case of one element or all of them in each dimension.
- Note the server time is in GMT
- Click ok
- Go to Edit -> Select All
- Go to Edit -> Back out
They're all backed out.
Often a good idea to back the server up before you do this, particularly as it's the first time you've done it.
Cheers,
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
Jodi Ryan Family Lawyer