Include user names and memory usage in TM1 Web logs

Local only User names and memory usage are included in TM1® Web logs. This update makes it easy to see when a user runs an active form, workbook, or cube that renders too many rows. To turn on this optional logging, the logging level of log4j.logger.com.ibm.cognos.tm1 must be set to DEBUG in the \tm1_64\webapps\tm1web\WEB-INF\configuration\log4j.properties file. You can review the audit logs and reduce the number of rows in the rendering.

The following information is included in logs:

  • Timestamp
  • Application and Active Form name
  • Number of rows that were generated
  • User name
  • Current heap memory after the websheet renders

Example log when you open an active form

"<TIMESTAMP>:CLASSNAME:Constructed view for <ActiveFormViewid> contains <#> rows, by user '<username>'. 
<TIMESTAMP>:CLASSNAME:Current heap memory usage: <MB>".

Example log when you open a workbook

"<TIMESTAMP>:CLASSNAME:Creating WorkbookMetaData for <sheet name>, by user '<username>'. 
<TIMESTAMP>:CLASSNAME:Current heap memory usage: <MB>".

Example log when you open a cube view

"<TIMESTAMP>:CLASSNAME:Exit from getUpdatedCubeViewData, updatedData: class name, username: <username>. 
<TIMESTAMP>:CLASSNAME:Current heap memory usage: <MB>".