tm1 log file delete

Post Reply
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

tm1 log file delete

Post by manu0521 »

Hi ,

I have a vb script that deletes the logs which are older than 3 days,

I have 3 instances and the task has 3 steps which deletes the logs from 3 instances .

I am having issue where the task goes to running state and not completes. When looked at it there is some tm1event log which it canot delete.

Any one had similar issue .
Script is below

option explicit
Dim rootFolder, files, File, f1, fso

set fso = createObject("Scripting.FileSystemObject")

'change folder here
set rootFolder = fso.GetFolder("D:\APAC\Logs\")
set files = rootFolder.Files

For each File in files
'On Error Resume Next
Set f1 = fso.GetFile("D:\APAC\Logs\"&File.Name)
'change amount of days here; files where last modification was longer ago than 5 days will be deleted
if File.DateLastModified < (date-3) then
'wscript.echo "deleted"
f1.delete
end if
NEXT



Thanks
User avatar
orlando
Community Contributor
Posts: 167
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365

Re: tm1 log file delete

Post by orlando »

manu0521 wrote: Tue May 26, 2020 1:14 am
When looked at it there is some tm1event log which it canot delete.
Hi,

The tm1event.log can only be deleted when the services are finished.
I see this file since i use the "IBM Cognos TM1 Operations Console" - but can also be coincidence, because at that time we also went on a new TM1 version.

If you want to delete the file you have to stop the services - delete - restart.

best regards,
orlando
User avatar
scrumthing
Posts: 81
Joined: Tue Jan 26, 2016 4:18 pm
OLAP Product: TM1
Version: 11.x
Excel Version: MS365

Re: tm1 log file delete

Post by scrumthing »

Why would you want to delete that particular file? Just don’t do it. It is a nice and short log of shutdowns and startups of your server.
There is no OLAP database besides TM1!
User avatar
ykud
MVP
Posts: 148
Joined: Sat Jan 10, 2009 10:52 am
Contact:

Re: tm1 log file delete

Post by ykud »

orlando wrote: Tue May 26, 2020 9:05 am
I see this file since i use the "IBM Cognos TM1 Operations Console" - but can also be coincidence, because at that time we also went on a new TM1 version.
This is a PA 2.0.3 feature https://www.ibm.com/support/knowledgece ... ogger.html
you can disable it by using EventLogging=F in tm1s.cfg (it's on by default), kudos to Andy Key for pointing this out to me a while back.

Y
User avatar
orlando
Community Contributor
Posts: 167
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365

Re: tm1 log file delete

Post by orlando »

ykud wrote: Wed May 27, 2020 11:17 pm

This is a PA 2.0.3 feature https://www.ibm.com/support/knowledgece ... ogger.html
you can disable it by using EventLogging=F in tm1s.cfg (it's on by default), kudos to Andy Key for pointing this out to me a while back.

Y
there is no icon, so: thumbs up!
MarenC
Regular Participant
Posts: 436
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: tm1 log file delete

Post by MarenC »

ykud had done very well not to have become an MVP! :D
Alan Kirk
Site Admin
Posts: 6647
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: tm1 log file delete

Post by Alan Kirk »

MarenC wrote: Thu May 28, 2020 8:00 am ykud had done very well not to have become an MVP! :D
15 posts short of getting into the voting cycle as of the time of writing.
"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