Query logging

For troubleshooting, you may want to log SQL queries to the database.

To enable query logging, open the Configuration Editor and select the Logging configuration. Browse to the QueryLogger node (under Loggers) and set the Enabled attribute to True. Make sure the Log Level attribute is set to Info.

Next, select the QueryDbAppender node under the QueryLogger node. Again, set the Enabled attribute to True and set the Log Level attribute to Info.

Query logs are written to the CORE.QUERYLOG table in the Infor Public Sector database.

Note: Query logging has a performance impact. It should only be used for troubleshooting, and not in a production environment.