Configure and View SharePoint and Diagnostic Logging
APPLIES TO: SQL Server Analysis Services Azure Analysis Services Power BI Premium
Power Pivot server operations, events, and messages are recorded in SharePoint log files. Use the information in this topic to configure logging levels and view log file information. You can control which Power Pivot server events are logged to the file. You can also control the severity of messages that are logged. For more information, see Configure Usage Data Collection for (Power Pivot for SharePoint.
In this topic:
Log File Location
By default, SharePoint log files are saved to the following location:
C:\Program files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS
The LOGS folder contains log files (
.log), data files (
.txt), and usage files (
.usage). The file naming convention for a SharePoint trace log is the server name followed by a date and time stamp. SharePoint trace logs are created at regular intervals and whenever there is an IISRESET. It is common to have many trace logs within a 24 hour period.
Modify diagnostic logging levels for individual event categories
By default, ULS logging of Power Pivot events is set at Medium. This setting is new for SQL Server 2012. If you upgraded a server from the prior release, the logging level might still be set at Verbose, the default level in SQL Server 2008 R2. If you are accustomed to reviewing the ULS logs for Power Pivot server usage information, you will notice that as a result of this change, there is less information about Power Pivot server operations.
Except for exceptions, which are of type High, all Power Pivot messages fall into the Verbose category. If you want log entries for routine server operations such as connections, requests, or query reporting, you must change the logging level to Verbose.
To modify diagnostic logging levels for individual event categories:
In SharePoint Central Administration, click Monitoring.
Click Configure diagnostic logging.
Scroll to Power Pivot Service.
Expand the category and select individual categories.
Application Page Request specifies events triggered by the service application when locating a Analysis Services service for loading a Power Pivot data source and communicating with other servers in the farm.
Request Processing specifies events triggered by query requests against a Power Pivot database that is loaded on a server in the farm.
Usage specifies an event related to Power Pivot usage data collection.
In Least critical event to report to the event log, select None to disable event logging for the category, or Error to limit logging for just errors.
Select Verbose to log all events to the event log.
In Least critical event to report to the trace log, select None to disable tracing for the category, or Error to limit tracing for just errors.
Select Verbose to log all events to the trace log.
How to View SharePoint Log Files
Log files are text files. You can open them in any text editor. You can also use third-party log viewer applications.
Use a Text Editor
If you are using a text editor to troubleshoot a Power Pivot server error, the following tips can help you locate relevant information in the file:
For errors related to publishing, viewing, or refreshing a Power Pivot workbook, search the log file for the name of the workbook.
For errors that provide a correlation ID, copy the ID and use it as a search term in the log file.
Search for error status "High" or "Exception". Search for "Power Pivot Service".
If you know when the error occurred, use the date and time information to narrow the scope of entries you must scroll through.
Use a Log Viewer Application
Although you can use a text editor to view the trace logs individually, a log viewer application that enables you to view several log files together can be far more useful. Fortunately, there are several third-party log viewer applications available for download on the Codeplex site that can help you view multiple trace logs in a single workspace.
The following instructions include links to popular SharePoint ULS Log Viewers that you can download from Codeplex.
Click the Downloads tab.
Click the executable file. It will either be SharePointLogViewer.exe or ULS Viewer 2.0 Binary.
Read and accept the licensing terms.
Click Save to download the software to your local system.
If you are downloading SharePoint ULS Log Viewer, save ULSViewer.zip to the Downloads folder.
In the Downloads folder, right-click ULSViewer.zip and select Extract All.
Specify a destination folder, and then click Extract.
In the folder that contains the extracted program files, double-click ULSViewer and run the application.
Click the folder icon at the top left corner of the application window.
Browse to \Program files\Common Files\Microsoft Shared\Web Server Extensions\14\Logs.
Select one or more trace logs. By default, trace log file names consist of the computer name plus date and time information. The file type is Text Document.
Click Open and wait for the files to load.
Use the built-in filters to select records based on severity, process, category, or a user-defined text file. You can also click column headings to change the sort order.
Entries for Power Pivot Services
The following table describes entries for Power Pivot server operations most likely to be found in a SharePoint log file.
|w3wp.exe||Power Pivot Service||Usage||Verbose||There are no current request statistics, nothing to log.||At predefined intervals, the service reports query response statistics as a usage event to the usage data collection system. This message indicates there were no query statistics to report.|
|w3wp.exe||Power Pivot Service||Web front end||Verbose||Starting to locate an application server for data source=<path>||When it receives a connection request, the Power Pivot service identifies an available Analysis Services service to handle the request. If there is only one server in the farm, the local server accepts the request in all cases.|
|w3wp.exe||Power Pivot Service||Web front end||Verbose||Locating the application server succeeded.||The request was allocated to a Power Pivot service application.|
|w3wp.exe||Power Pivot Service||Web front end||Verbose||Redirecting request for the <PowerPivotdata source> to the Analysis Services service.||The request was forwarded to the Analysis Services service.|
|w3wp.exe||Power Pivot Service||Request Processing||Verbose||Redirecting request for UserName<SharePoint user> to the database||An impersonated connection to the Power Pivot data source was created on behalf of the SharePoint user.|