excluding events from tm1 message log file?

[fleaster]

Ok, we're just upgrading to TM1 9.5.2, and have been dabbling a bit with the tm1 log properties file while simultaneously reading the IBM site ...a few questions i have are:

1/ what is the difference between the 2 parameters, and do they need to be set the same? e.g. could I have WARN in one and INFO in the other?
log4j.rootLogger=INFO, S1
log4j.logger.TM1=INFO

2/ i think there is a section in the IBM documentation on including certain messages, but what if I want to exclude messages

e.g. the below message will appear 100s of times for every line returned by a user performs a cube to SQL drill
6624 [f] INFO 2012-08-03 06:16:53.036 TM1.SQLAPI fetched 1 row

..am wondering if there is a command for this..?

...any tips would be much appreciated

Thanks,

Matt

[Duncan P]

In the online doc for LOG4J (http://logging.apache.org/log4j/1.2/manual.html) it has levels WARN, ERROR and FATAL which are higher than INFO. There is also OFF which will disable all messages for a particular logger.

As it is the TM1.SQLAPI logger for which you want to turn off INFO you could try

Code: Select all

log4j.logger.TM1.SQLAPI=WARN

[fleaster]

thanks for that - good to know where that logging script really comes from

...well i tried putting it to "WARN", but ended up coming up with thousands of these errors:

1036 [] ERROR 2012-08-04 04:15:47.939 TM1.Audit.PostProcessor Failed to open audit store in AppendRawStoreToAuditStore

will probably keep experimenting / rebooting to see if it fixes itself...

[Duncan P]

Have you tried any of the other settings?

The other thing is that you don't have to reboot. Simply saving the tm1s-log.properties file is enough for TM1 to pick up the new settings.