IBM Support

Log which Websheets and Cubeview are used in TM1Web

Troubleshooting


Problem

This Technote explains how to log the names of Websheets and Cubeviews that are accessed in TM1Web. This logging can also help to determine which users were logged into TM1Web as the user account names will be displayed in the tm1web.log file. This logging is useful to determine if a TM1Web performance or JVM memory utilization problem is specific to one or more Websheets. Note that the heap memory usage is included in the logging.

Resolving The Problem

Update the ..\tm1_64\webapps\tm1web\WEB-INF\configuration\log4j.properties file to include the following lines (shown in bold below).

log4j.logger.com.ibm.cognos.tm1.web.services.TM1Service=INFO
log4j.logger.com.ibm.cognos.tm1.web.services.TM1ExportService=DEBUG
log4j.logger.com.ibm.cognos.tm1.publish.Workbook=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services.TM1ServerSessionInfo=DEBUG

The full log4j.properties file should look like this:

# System logging settings
log4j.rootLogger=ERROR, TextFile
log4j.logger.com.ibm.cognos=ERROR
log4j.logger.com.cognos=ERROR
log4j.logger.com.cognos.org=ERROR
log4j.logger.com.ibm.cognos.perf=ERROR
log4j.logger.com.ibm.cognos.tm1=ERROR
log4j.logger.com.ibm.cognos.tm1.web.services.TM1ExportService=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services.TM1Service=INFO
log4j.logger.com.ibm.cognos.tm1.publish.Workbook=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services.TM1ServerSessionInfo=DEBUG

log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p (%x) %c - %m%n

log4j.appender.TextFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.TextFile.File=logs/tm1web.log
log4j.appender.TextFile.DatePattern=.yyyy-MM-dd
log4j.appender.TextFile.layout=org.apache.log4j.PatternLayout
log4j.appender.TextFile.layout.ConversionPattern=%d [%t] %-5p (%x) %c - %m%n

log4j.appender.XMLFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.XMLFile.File=logs/tm1web_log.xml
log4j.appender.XMLFile.DatePattern=.yyyy-MM-dd
log4j.appender.XMLFile.layout=org.apache.log4j.xml.XMLLayout


Restart the IBM Cognos TM1 Applications server.

When a user opens a Cubeview or Websheet the following logging will be written to the ..\tm1_64\webapps\tm1web\WEB-INF\logs\tm1web.log file.

2016-03-31 14:55:25,143 [http-9515-6] INFO () com.ibm.cognos.tm1.web.services.TM1Service - New object id requested for websheet 'Applications/Websheets/Budget Input Detail Websheet'.
2016-03-31 14:55:25,246 [http-9515-6] DEBUG () com.ibm.cognos.tm1.publish.Workbook - Creating com.aspose.cells.Workbook for TM1://Planning Sample/blob/PUBLIC/.\}Externals\Book2.xlsx_20160208182055.xlsx.
2016-03-31 14:55:25,247 [http-9515-6] DEBUG () com.ibm.cognos.tm1.publish.Workbook - Current heap memory usage: 289 MB
2016-03-31 14:55:25,504 [http-9515-6] DEBUG () com.ibm.cognos.tm1.publish.Workbook - Finished creating com.aspose.cells.Workbook for TM1://Planning Sample/blob/PUBLIC/.\}Externals\Book2.xlsx_20160208182055.xlsx.
2016-03-31 14:55:25,504 [http-9515-6] DEBUG () com.ibm.cognos.tm1.publish.Workbook - Current heap memory usage: 294 MB
2016-03-31 14:55:25,505 [http-9515-6] DEBUG () com.ibm.cognos.tm1.publish.Workbook - Creating AsposeWorkbook for TM1://Planning Sample/blob/PUBLIC/.\}Externals\Book2.xlsx_20160208182055.xlsx.
2016-03-31 14:55:25,896 [http-9515-6] DEBUG () com.ibm.cognos.tm1.publish.Workbook - Finished creating AsposeWorkbook for TM1://Planning Sample/blob/PUBLIC/.\}Externals\Book2.xlsx_20160208182055.xlsx.
2016-03-31 14:55:25,896 [http-9515-6] DEBUG () com.ibm.cognos.tm1.publish.Workbook - Current heap memory usage: 300 MB

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"TM1 Web","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.2","Edition":""}]

Document Information

Modified date:
15 June 2018

UID

swg21980348