Turn on Reporting Services events for the SharePoint trace log (ULS)Turn on Reporting Services events for the SharePoint trace log (ULS)

SQL Server 2008 R2SQL Server 2008 R2開始,SharePoint 模式的 Reporting ServicesReporting Services 伺服器可以將 Reporting ServicesReporting Services 事件寫入 SharePoint 統一記錄服務 (ULS) 追蹤記錄。Starting with SQL Server 2008 R2SQL Server 2008 R2, Reporting ServicesReporting Services servers in SharePoint mode can write Reporting ServicesReporting Services events to the SharePoint Unified Logging Service (ULS) trace log. Reporting ServicesReporting Services 特定類別目錄。specific categories are available on the Monitoring page of SharePoint Central Administration.

本主題內容:In this Topic:

一般 ULS 記錄建議General ULS Log Recommendations

下表將針對監視 Reporting ServicesReporting Services 環境,列出建議的事件類別目錄和層級。The following table lists event categories and levels that are recommended for monitoring a Reporting ServicesReporting Services environment.. 記錄事件時,每個項目都會包含記錄事件的時間、處理序名稱,以及執行緒識別碼。When an event is logged, each entry includes the time the event was logged, the process name, and the thread ID.

類別目錄Category levelLevel [描述]Description
[資料庫]Database 「詳細資訊」Verbose 記錄涉及資料庫存取權的事件。Logs events that involve database access.
一般General 「詳細資訊」Verbose 記錄涉及下列項目之存取權的事件:Logs events that involve access to the following items:

Reporting ServicesReporting Services 網頁Web pages

報表檢視器 HTTP 處理常式Report Viewer HTTP handler

報表存取 (.rdl 檔)Report access (.rdl files)

資料來源 (.rsds 檔)Data sources (.rsds files)

SharePoint 網站的 URL (.smdl 檔)URLs on the SharePoint site (.smdl files)
Office Server 一般Office Server General ExceptionException 記錄登入失敗。Logs logon failures.
拓撲Topology 「詳細資訊」Verbose 記錄目前的使用者資訊。Logs current user information.
Web 組件Web Parts 「詳細資訊」Verbose 記錄涉及報表檢視器 Web 組件之存取權的事件。Logs events that involve access to the Report Viewer Web Part.

開啟和關閉 Reporting Services 類別目錄中的 Reporting Services 事件To turn on and off Reporting Services events in the Reporting Services Category

  1. 在 SharePoint 管理中心內From SharePoint Central Administration

  2. 按一下 [監視]Click Monitoring.

  3. 按一下 [報表] 群組中的 [設定診斷記錄]Click Configure Diagnostic Logging in the Reporting group.

  4. 在類別目錄清單中找到 [SQL Server Reporting Services]Find SQL Server Reporting Services in the category list.

  5. 按一下加號 (+) 展開 [SQL Server Reporting Services] 之下的子類別目錄。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.


不支援 [回報至追蹤記錄的最低緊急事件] Reporting ServicesReporting Services選項。The option Least critical event to report to the event log is not supported by Reporting ServicesReporting Services. 已忽略此選項。The option is ignored.

建議您使用下列記錄選項做為標準組態:The following logging options are recommended as a standard configuration:

  • HTTP 重新導向程式HTTP Redirector

  • SOAP 用戶端 ProxySOAP Client Proxy

  • 如果您遇到組態設定方面的問題,請加入 [組態頁面]If you are experiencing issues with configuration, add Configuration Pages.

您可以使用下列 PowerShell 指令程式來檢閱所有目前伺服器陣列診斷記錄設定:You can review all of the current farm diagnostic log settings with the following PowerShell cmdlet:


讀取記錄項目Reading the logs entries

記錄中的 Reporting ServicesReporting Services 項目會以下列方式格式化。The Reporting ServicesReporting Services entries in the log are formatted in the following way.

  1. 產品:SQL Server Reporting ServicesProduct:SQL Server Reporting Services

  2. 類別目錄: 與伺服器相關的事件其名稱開頭會有 "Report Server" 字元。Category: Events related to the server will have the characters "Report Server", at the beginning of the name. 例如 "Report Server Alerting Runtime",這些事件會記錄到報表伺服器記錄檔。For example "Report Server Alerting Runtime" These events are also logged to the report server log files.

  3. 類別目錄: 與 Web 前端元件相關或從中進行通訊的事件不會包含 "Report Server"。Category: Events related to or communicated from a web front-end component do not contain "Report Server". 例如 "Service Application Proxy"、"Report Server Alerting Runtime"。For example "Service Application Proxy" Report Server Alerting Runtime". WFE 項目會包含 CorrelationID,但伺服器項目不會包含。The WFE entries do contain a CorrelationID but the server entries do not.

SQL Server Reporting Services 事件清單List of SQL Server Reporting Services Events

下表為 SQL Server Reporting Services 類別目錄中事件的清單: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 重新導向程式HTTP Redirector
本機模式處理Local Mode Processing
本機模式轉譯Local Mode Rendering
SOAP 用戶端 ProxySOAP Client Proxy
UI 頁面UI Pages
Power ViewPower View 已寫入 LogClientTraceEvents API 中的記錄項目。Log entries that were written to the LogClientTraceEvents API. 這些項目來自於用戶端應用程式,包括適用於 Power ViewPower ViewEnterprise Edition 的 SQL Server 2014SQL Server 2014 Reporting ServicesReporting Services 增益集功能 MicrosoftMicrosoftSharePoint Server 2010SharePoint Server 2010These entries are sourced from client applications, including Power ViewPower View, a feature of SQL Server 2014SQL Server 2014 Reporting ServicesReporting Services Add-in for MicrosoftMicrosoftSharePoint Server 2010SharePoint Server 2010 Enterprise Edition.

所有來自於 LogClientTraceEvents API 的記錄項目都會記錄在 "SQL Server Reporting Services" [類別目錄] 和 "Power View" [區域] 之下。All log entries from the LogClientTraceEvents API will be logged under the Category of "SQL Server Reporting Services" and the Area of "Power View".

使用 "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 報表伺服器內部 URL http://localhost:80/ReportServer 。MediumUsing report server internal url http://localhost:80/ReportServer.

UnexpectedMissing 或是無效的 ExtendedProtectionLevel 設定UnexpectedMissing or Invalid ExtendedProtectionLevel setting
報表伺服器密碼編譯Report Server Crypto
報表伺服器資料延伸模組Report Server Data Extension
報表伺服器資料庫輪詢Report Server DB Polling
報表伺服器預設值Report Server Default
報表伺服器電子郵件延伸模組Report Server Email Extension
報表伺服器 Excel 轉譯器Report Server Excel Renderer
報表伺服器延伸模組 FactoryReport Server Extension Factory
報表伺服器 HTTP 執行階段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 啟動 SKU:評估版MediumReporting Services starting SKU: Evaluation

MediumEvaluation 複本:剩下 180 天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
報表伺服器 WCF 執行階段Report Server WCF Runtime
報表伺服器 Web 服務Report Server Web Server
服務應用程式 ProxyService Application Proxy
共用服務Shared Service 範例項目:Sample entries:

MediumUpdating ReportingWebServiceApplicationMediumUpdating ReportingWebServiceApplication

MediumGranting 對內容資料庫的存取。MediumGranting access to content databases.

ReportingWebServiceApplication 的 MediumProvisioning 執行個體MediumProvisioning instances for ReportingWebServiceApplication

ReportingWebServiceApplication 的 MediumProcessing 服務帳戶變更MediumProcessing service account change for ReportingWebServiceApplication

MediumSetting 資料庫權限。MediumSetting database permissions.

利用 PowerShell 檢視記錄檔View a Log file with PowerShell

PowerShell 相關內容您可以使用 PowerShell 從 ULS 記錄檔傳回 Reporting ServicesReporting Services 相關事件的清單。PowerShell related contentYou can use PowerShell to return a list of the Reporting ServicesReporting Services related events from a ULS Log file. 從 SharePoint 2010 管理命令介面鍵入下列命令,從包含 "sql server reporting services" 的 ULS 記錄檔 UESQL11SPOINT-20110606-1530.log 傳回已篩選資料列清單: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"  

您可以下載多種可用來讀取 ULS 記錄的工具。There are also many tools you can download which will allow you read ULS logs. 例如, SharePoint LogViewerSharePoint ULS 記錄檢視器For example, the SharePoint LogViewer or SharePoint ULS Log Viewer. 兩者都在 CodePlex 上提供。Both are available on CodePlex.

如需有關如何使用 PowerShell 來檢視記錄資料的詳細資訊,請參閱 檢視診斷記錄 (SharePoint Server 2010)For more information on how to use PowerShell to view log data, see View diagnostic logs (SharePoint Server 2010)

追蹤記錄位置Trace Log Location

追蹤記錄檔通常位於 c:\Program Files\Common files\Microsoft Shared\Web Server Extensions\14\logs 資料夾中,但是您可以從 SharePoint 管理中心的 [診斷記錄] 頁面中驗證或變更此路徑。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.

如需詳細資訊以及在 SharePoint 2010 管理中心內設定 SharePoint 伺服器之診斷記錄的步驟,請參閱 設定診斷記錄設定 (Windows SharePoint Services)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).