报告执行''已过期或无法找到。 （rsExecutionNotFound） [英] The report execution '' has expired or cannot be found. (rsExecutionNotFound)
问题描述
团队，
用户正在获取"报告执行abc123已过期或无法找到。 （rsExecutionNotFound）"错误信息;零星地。
上述情况发生在全新的执行上。我粘贴报告的网址，然后收到该错误消息。
关闭/打开浏览器，IE，再次通过网址，报告执行成功。
在日志文件中，我看到：
library！ReportServer_0-363！3b90！12/07 / 2015-15：17：40 ::错误：抛出Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException :,报表服务器数据库中发生错误。 这可能是由于数据库中的连接失败，
超时或磁盘状况不佳所致。; $
session！ReportServer_0-363！3b90！12/07 / 2015-15：17 ：40 :: e错误：获取会话数据时出错：会话yle2fzamduv1w555sm4dwx55不属于LEFDOMAIN \SQLAdmin
session！ReportServer_0-363！3b90！12/07 / 2015-15：17：40 :: i INFO：LoadSnapshot：包含会话的项目：yle2fzamduv1w555sm4dwx55，reportPath：/ Shipping / Pick Ticket Status Summary（50 - 555-560），userName：LEFDOMAIN \ SQLAdmin在数据库中找不到
library ！ReportServer_0-363！3b90！12/07 / 2015-15：17：40 :: e ERROR：抛出Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException：，Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException：报告执行yle2fzamduv1w555sm4dwx55
已过期或无法找到。;
$
webserver！ReportServer_0-363！3b90！12/07 / 2015-15：17：40 :: e错误：Reporting Services错误Microsoft.ReportingServices。 Diagno stics.Utilities.ExecutionNotFoundException：报告执行yle2fzamduv1w555sm4dwx55已过期或无法找到。
更新：
我注意到的一件事是，前端报告为过期的会话仍然存在于ReportDataTempDB数据库上的SessionData表。
下午3:29的错误消息
- 报告执行hq1c2xy4h3lw3l2vmdzot245已过期或无法找到。（rsExecutionNotFound）
在ReportServerTempDB上运行以下内容：
SELECT * FROM [dbo]。[SessionData]
WHERE
SessionID ='hq1c2xy4h3lw3l2vmdzot245'
返回：
SessionID CompiledDefinition
SnapshotDataID IsPermanentSnapshot
ReportPath 超时
AutoRefreshSeconds 到期日
hq1c2xy4h3lw3l2vmdzot245 NULL
NULL NULL
/ Master / Daily Sales by hour 600
0 2015-12-07 15：39：09.497
Team,
Users are getting the "The report execution abc123 has expired or cannot be found. (rsExecutionNotFound)" error message; sporadically.
The above happens on brand new executions. I paste the URL of a report, and receive that error message.
Close/Open the browser, IE, past the URL again and the report executes successfully.
On the log files, I see:
library!ReportServer_0-363!3b90!12/07/2015-15:17:40:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure,
timeout or low disk condition within the database.;
session!ReportServer_0-363!3b90!12/07/2015-15:17:40:: e ERROR: Error in getting session data: Session yle2fzamduv1w555sm4dwx55 does not belong to LEFDOMAIN\SQLAdmin
session!ReportServer_0-363!3b90!12/07/2015-15:17:40:: i INFO: LoadSnapshot: Item with session: yle2fzamduv1w555sm4dwx55, reportPath: /Shipping/Pick Ticket Status Summary (50 - 555-560), userName: LEFDOMAIN\SQLAdmin not found in the database
library!ReportServer_0-363!3b90!12/07/2015-15:17:40:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: The report execution yle2fzamduv1w555sm4dwx55
has expired or cannot be found.;
webserver!ReportServer_0-363!3b90!12/07/2015-15:17:40:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: The report execution yle2fzamduv1w555sm4dwx55 has expired or cannot be found.
Update:
One thing that I have noticed is that the session that the front end is reporting as expired still exists on the SessionData table, on the ReportServerTempDB database.
Error Message from 3:29PM
- The report execution hq1c2xy4h3lw3l2vmdzot245 has expired or cannot be found. (rsExecutionNotFound)
Ran the below on ReportServerTempDB:
SELECT * FROM [dbo].[SessionData]
WHERE
SessionID = 'hq1c2xy4h3lw3l2vmdzot245'Returns:
SessionID CompiledDefinition SnapshotDataID IsPermanentSnapshot ReportPath Timeout AutoRefreshSeconds Expiration
hq1c2xy4h3lw3l2vmdzot245 NULL NULL NULL /Master/Daily Sales by Hour 600 0 2015-12-07 15:39:09.497
这篇关于报告执行''已过期或无法找到。 （rsExecutionNotFound）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
