Page 1 of 1
Transaction Log Duration
Posted: Wed Aug 31, 2022 1:02 pm
by Andero
Hi everyone,
Sorry but I couldn't find another post related to this.
I've been asked by a client to increase the transaction log duration.
At the moment it seems that it keeps track for the last 2 weeks and I need to increase it to 30 days.
Is it possible to change it? If Yes, do you know which parameter should I change?
Thanks in advance
Re: Transaction Log Duration
Posted: Wed Aug 31, 2022 1:11 pm
by ascheevel
No parameter for transaction log retention. If you're only seeing 2 weeks of transaction logs, there must be a utility running that's deleting tm1s<datetimestamp>.log files older than a certain time. Theoretically, the transaction log could go as far back as you have saved tm1s log files.
You could search the chores on the tm1 model to see if there's any calling a "cleanup logs" type process or search TI processes that have ExecuteCommand somewhere in the TI and see if it's either calling an exe, batch file, or compiling the command to delete those transaction log files. The sort of command, assuming a windows box, to clear out specific files might be using a "ForFiles" command.
Since we're curious folk, please report back on where you end up finding the culprit.
Re: Transaction Log Duration
Posted: Wed Aug 31, 2022 1:14 pm
by Andero
Hi!
Thank you for your reply.
Indeed I have a nightly chore that cleans the logs older than 2 weeks.. I completely forgot about that.
I will increase it to one month so everything should go fine.
Thanks!
Andrea
Re: Transaction Log Durations
Posted: Wed Aug 31, 2022 7:22 pm
by Wim Gielis
ascheevel wrote: ↑Wed Aug 31, 2022 1:11 pm
No parameter for transaction log retention. If you're only seeing 2 weeks of transaction logs, there must be a utility running that's deleting tm1s<datetimestamp>.log files older than a certain time. Theoretically, the transaction log could go as far back as you have saved tm1s log files.
You could search the chores on the tm1 model to see if there's any calling a "cleanup logs" type process or search TI processes that have ExecuteCommand somewhere in the TI and see if it's either calling an exe, batch file, or compiling the command to delete those transaction log files. The sort of command, assuming a windows box, to clear out specific files might be using a "ForFiles" command.
Since we're curious folk, please report back on where you end up finding the culprit.
Or the AsciiDelete function in TI without external commands.
Re: Transaction Log Duration
Posted: Tue Sep 06, 2022 3:01 pm
by shahhere
Andero wrote: ↑Wed Aug 31, 2022 1:14 pm
Hi!
Thank you for your reply.
Indeed I have a nightly chore that cleans the logs older than 2 weeks.. I completely forgot about that.
I will increase it to one month so everything should go fine.
Thanks!
Andrea
The log files can be a bit large but once zipped they are not that large. We actually zip the files along with other nightly zips of the Data/Reports/Logs and then delete the logs....its a good idea to keep the zipped up version of the model for 30/60/90 etc.
Shahhere