大网数据广告活动
数据库与应用安全

Deadlocks occur when you view an SSRS report

· 52CE 我爱测

This article provides resolutions for the deadlocks that occur when you try to view an SSRS report in SharePoint integrated mode. You receive a time-out error when you try to view the report from a customized SharePoint page.

This article provides resolutions for the deadlocks that occur when you try to view a SQL Server Reporting Services (SSRS) report in SharePoint integrated mode.

Original product version:   SQL Server
Original KB number:   2691331

Symptoms

Consider the following scenario:

  • You configure an instance of Microsoft SSRS to use the SharePoint integrated mode.

  • You create a report that has multiple data sources.

  • You deploy the report to a SharePoint website.

  • You update one of the data sources.

  • You try to view the report from a customized SharePoint page. The report is embedded in an IFrame control of the page by using direct URL access to the SSRS proxy endpoint as follows:

    http://<Server Name>/<Site Name>/_vti_bin/ReportServer/<Report Name>.rdl?<Report URL Parameters>

In this scenario, you may experience one or more of the following symptoms.

  • Symptom 1

    Database deadlocks occur on one of the following stored procedures in the back-end Report Server database:

    • [dbo].[GetDataSources]
    • [dbo].[DeleteDataSources]
  • Symptom 2

    You receive one of the following error messages:

    • Error Message 1

      An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)

    • Error Message 2

      Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

  • Symptom 3

    The SharePoint pages are very slow to load when you try to access SharePoint site content.

Cause

This issue occurs because the data source is not synchronized correctly after you update it.

Resolution

To work around this issue, use one of the following methods:

  • Method 1

    View the report directly from the SharePoint document library after you update the report data source. This makes sure the data source is synchronized correctly before you view the report through the SSRS proxy endpoint.

  • Method 2

    Use a Report Viewer web part to display the report.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 07/22/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。