Skip to main content
Turn on Reporting Services events for the SharePoint trace log (ULS)

Starting with SQL Server 2008 R2, Reporting Services servers in SharePoint mode can write Reporting Services events to the SharePoint Unified Logging Service (ULS) trace log. Reporting Services specific categories are available on the Monitoring page of SharePoint Central Administration.

In this Topic:

  • General ULS Log Recommendations

  • Turn Reporting Services events on and off.

  • Recommended Configuration

  • Reading Log Entries

  • List of Reporting Services Events

  • View a log with PowerShell

  • Trace Log file Location

General ULS Log Recommendations

The following table lists event categories and levels that are recommended for monitoring a Reporting Services environment.. When an event is logged, each entry includes the time the event was logged, the process name, and the thread ID.

Category

Level

Description

Database

Verbose

Logs events that involve database access.

General

Verbose

Logs events that involve access to the following items:

  • Reporting Services Web pages

  • Report Viewer HTTP handler

  • Report access (.rdl files)

  • Data sources (.rsds files)

  • URLs on the SharePoint site (.smdl files)

Office Server General

Exception

Logs logon failures.

Topology

Verbose

Logs current user information.

Web Parts

Verbose

Logs events that involve access to the Report Viewer Web Part.

To turn on and off Reporting Services events in the Reporting Services Category

  1. From SharePoint Central Administration

  2. Click Monitoring.

  3. Click Configure Diagnostic Logging in the Reporting group.

  4. Find SQL Server Reporting Services in the category list.

  5. Click the plus symbol (+) to expand the sub categories under SQL Server Reporting Services.

  6. Select the subcategories to be added to the trace log.

  7. At the bottom of the categories list, select an event level for the Least critical event to report to the trace log. Select None to disable tracing.

Note Note

The option Least critical event to report to the event log is not supported by Reporting Services. The option is ignored.

Arrow icon used with Back to Top link Top

Recommended Configuration

The following logging options are recommended as a standard configuration:

  • HTTP Redirector

  • SOAP Client Proxy

  • If you are experiencing issues with configuration, add Configuration Pages.

You can review all of the current farm diagnostic log settings with the following PowerShell cmdlet:

Get-SPDiagnosticConfig

Arrow icon used with Back to Top link Top

Reading the logs entries

The Reporting Services entries in the log are formatted in the following way.

  1. Product: SQL Server Reporting Services

  2. Category: Events related to the server will have the characters “Report Server”, at the beginning of the name. For example “Report Server Alerting Runtime” These events are also logged to the report server log files.

  3. Category: Events related to or communicated from a web front-end component do not contain “Report Server”. For example “Service Application Proxy” Report Server Alerting Runtime”. The WFE entries do contain a CorrelationID but the server entries do not.

Arrow icon used with Back to Top link Top

List of SQL Server Reporting Services Events

The following table is a list of the events in the SQL Server Reporting Services Category:

Area Name

Description or sample entries

Configuration Pages

HTTP Redirector

Local Mode Processing

Local Mode Rendering

SOAP Client Proxy

UI Pages

Power View

Log entries that were written to the LogClientTraceEvents API. These entries are sourced from client applications, including Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition.

All log entries from the LogClientTraceEvents API will be logged under the Category of “SQL Server Reporting Services” and the Area of “Power View”.

The content of entries logged with the area of “Power View” is determined by the client application.

Report Server Alerting Runtime

Report Server App Domain Manager

Report Server Buffered Response

Report Server Cache

Report Server Catalog

Report Server Chunk

Report Server Cleanup

Report Server Configuration Manager

Sample entries:

MediumUsing report server internal url http://localhost:80/ReportServer.

UnexpectedMissing or Invalid ExtendedProtectionLevel setting

Report Server Crypto

Report Server Data Extension

Report Server DB Polling

Report Server Default

Report Server Email Extension

Report Server Excel Renderer

Report Server Extension Factory

Report Server HTTP Runtime

Report Server Image Renderer

Report Server Memory Monitoring

Report Server Notification

Report Server Processing

Report Server Provider

Report Server Rendering

Report Server Report Preview

Report Server Resource Utility

Sample Entries:

MediumReporting Services starting SKU: Evaluation

MediumEvaluation copy: 180 days left

Report Server Running Jobs

Report Server Running Requests

Report Server Schedule

Report Server Security

Report Server Service Controller

Report Server Session

Report Server Subscription

Report Server WCF Runtime

Report Server Web Server

Service Application Proxy

Shared Service

Sample entries:

MediumUpdating ReportingWebServiceApplication

MediumGranting access to content databases.

MediumProvisioning instances for ReportingWebServiceApplication

MediumProcessing service account change for ReportingWebServiceApplication

MediumSetting database permissions.

Arrow icon used with Back to Top link Top

View a Log file with PowerShell

PowerShell related contentYou can use PowerShell to return a list of the related events from a ULS Log file. Type the following command from the SharePoint 2010 Management Shell to return a filtered list of rows from the file a ULS log file UESQL11SPOINT-20110606-1530.log, that contain “sql server reporting services”:


          
Get-content -path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\UESQL11SPOINT-20110606-1530.log" | select-string "sql server reporting services

There are also many tools you can download which will allow you read ULS logs. For example, the SharePoint LogViewer or SharePoint ULS Log Viewer. Both are available on CodePlex.

For more information on how to use PowerShell to view log data, see View diagnostic logs (SharePoint Server 2010)

Arrow icon used with Back to Top link Top

Trace Log Location

The Trace Log files are usually found in the folder c:\Program Files\Common files\Microsoft Shared\Web Server Extensions\14\logs but you can verify or change the path from the Diagnostic Logging page in SharePoint Central Administration.

For more information and steps to configure diagnostic logging on a SharePoint server in SharePoint 2010 Central Administration, see Configure diagnostic logging settings (Windows SharePoint Services).

Arrow icon used with Back to Top link Top