Specialized Administration > Site Maintenance > Managing Windchill Logging > Configuring API-specific and User Session-based Loggers
  
Configuring API-specific and User Session-based Loggers
You can enable persistence layer logging for all Windchill modules using the wt.pom.SQL logger. However, it leads to a large number of log entries. Alternatively, for granular troubleshooting, you can use the API-specific loggers to restrict the persistence-layer logging to specific classes only.
To enable API-specific logging, configure the following properties in the wt.properties file located at <WT_HOME>/codebase.
wt.pom.logger.apilevel.classes
Specifies the classes for which you want to generate persistence layer log messages. The property takes a comma-separated list of fully qualified class names or API name, for example wt.dataops.purge.StandardPurgeService,wt.change2.listeners.ResultingChangeEventHandler
The configuration example shown above enables persistence layer logging specifically for the StandardPurgeService and ResultingChangeEventHandler classes. If any methods in these classes call APIs from other classes and so on, persistence layer logging is generated for the entire call hierarchy.
wt.pom.logger.userlevel.username
Specifies the users for which you want to generate persistence layer log messages. The property takes a comma-separated list of usernames, for example wcadmin, user1.
Refer the following table for information about the combination of logging mechanism for the above mentioned properties:
LogLevel Enabled
Configured API Name
Configured User Name
Logged Message for
0
NA
NA
Class
Class
NA
Nothing will log
0
NA
NA
Class
Class
Demo
Nothing will log
0
NA
NA
Class
Class
NA
Nothing will log
0
NA
NA
Class
Class
Demo
Nothing will log
1
NA
NA
Class
Class
NA
Demo
NA
Demo
Default Logging
Default Logging
Default Logging
Default Logging
1
NA
NA
Class
Class
NA
Demo
NA
Demo
Nothing will log
Demo
Nothing will log
Demo
1
NA
NA
Class
Class
NA
Demo
NA
Demo
Nothing will log
Nothing will log
Class
Class
1
NA
NA
Class
Class
NA
Demo
NA
Demo
Nothing will log
Demo
Class
Only Class if Demo is User
The persistence layer loggers affected by these property settings are given below:
wt.pom.sql
wt.pom.mapping
wt.pom.joinMapping
wt.pom.blob
wt.pom.statementCache
wt.pom.statementCache.summary
wt.pom.refreshCache
wt.pom.properties
wt.pom.accessControl
wt.pds.bind
wt.pds.concurrent
wt.pds.concurrent.statistics
wt.pds.exception
wt.pds.general
wt.pds.queryCancel
wt.pds.queryContext
wt.pds.meta
wt.pds.statementParameter
wt.query
wt.pom.paging
com.ptc.core.query.server
com.ptc.core.query.common
wt.pom.rowCount