Oracle^® Business Intelligence Server Administration Guide > Query Caching in the Oracle BI Server > Cache Event Processing with an Event Polling Table >

Troubleshooting Problems with an Event Polling Table

If you experience problems with cache polling, you can search the Oracle BI Server activity logs for any entries regarding the server's interaction with the event table.

• The NQServer.log file logs activity automatically about the Oracle BI Server. The default location for this file is the Log folder in the Oracle BI Server software installation folder (\OracleBI\Log). Log entries are self-explanatory and can be viewed using a text editor.
• When the Oracle BI Server polls the event table, it will log the queries in the NQQuery.log file using the Oracle BI Administrator user ID unless the logging level for the Oracle BI Administrator is set to 0. You should set the logging level to 2 for the Oracle BI Administrator user ID to provide the most useful level of information. The default location for the NQQuery.log file is the Log folder in the Oracle BI Server software installation folder (\OracleBI). For more information about user-level logging, refer to Query Caching in the Oracle BI Server.