包含会话的项目：、reportPath：、userName：在数据库中找不到

发布于 2024-11-02 15:26:08 字数 1921 浏览 1 评论 0原文

在 ReportManager 中，我有很多用户抱怨这个错误。当我筛选 RS 日志时，不同用户多次看到以下错误：

session!ReportServer_0-2!1e40!04/20/2011-09:13:56:: i INFO: LoadSnapshot: Item with session: zlq0epfrvvvfagbyyda2drbm, reportPath: , userName: PROD\user not found in the database
library!ReportServer_0-2!1e40!04/20/2011-09:13:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'zlq0epfrvvvfagbyyda2drbm' cannot be found, ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'zlq0epfrvvvfagbyyda2drbm' cannot be found
ui!ReportManager_0-1!216c!04/20/2011-09:13:56:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'zlq0epfrvvvfagbyyda2drbm' cannot be found (rsExecutionNotFound)
   at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
   at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
   at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

再次单击“查看报告”，或返回浏览器并再次运行报告似乎经常有效 - 但我不认为这些可行的解决方案。

我在网上找到了几十个帖子，大部分都尝试过但没有成功。其中包括提高 SessionAccessTimeout 和ReportServer.ConfigurationInfo 数据库中的 SessionTime 值以及将报告设置为不使报告执行超时并在 RS Web.config & 中增加超时。 rsreportserver.config。

需要几秒钟才能运行的报告以及运行时间较长的报告都会发生此错误。我们正在运行 SSRS 2008，并通过 SSL 进行 RSWindowsBasic 身份验证（这是最近从 RSWindowsNTLM 更改的）。

任何想法/意见将不胜感激。

原文

In ReportManager I have many users complaining about this error. When I sift through the RS logs I see the following error many times for different users:

session!ReportServer_0-2!1e40!04/20/2011-09:13:56:: i INFO: LoadSnapshot: Item with session: zlq0epfrvvvfagbyyda2drbm, reportPath: , userName: PROD\user not found in the database
library!ReportServer_0-2!1e40!04/20/2011-09:13:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'zlq0epfrvvvfagbyyda2drbm' cannot be found, ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'zlq0epfrvvvfagbyyda2drbm' cannot be found
ui!ReportManager_0-1!216c!04/20/2011-09:13:56:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'zlq0epfrvvvfagbyyda2drbm' cannot be found (rsExecutionNotFound)
   at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
   at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
   at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Clicking on view report again, or hitting back on the browser and running the report again often seems to work - but I don't consider these viable solutions.

I've found dozens of postings on the web and have tried most of them without success. These included upping the SessionAccessTimeout & SessionTime values in the ReportServer.ConfigurationInfo database as well as setting reports to not timeout report execution and upping timeouts in the RS Web.config & rsreportserver.config.

This error will happen on reports that take seconds to run as well as longer running ones. We're running SSRS 2008 with RSWindowsBasic auth over SSL (this was recently changed from RSWindowsNTLM).

Any thoughts/input would be greatly appreciated.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

谈场末日恋爱 2024-11-09 15:26:08

请尝试以下操作，这应该可以解决问题：

在服务器上，编辑 C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config
将 rsreportserver.config 中的 EnableAuthPersistence 设置为 False

问候，
先生

回复收藏 0 原文