SSRS - 运行存储过程时出现严重错误消息
我有一个运行存储过程的报告，该存储过程需要大约一个小时才能运行。
大约 30 分钟后，我在报告正文上收到此错误消息：
An error has occurred during report processing.
Query execution failed for data set 'DEV'.
A severe error occurred on the current command. The results, if any, should be discarded. Operation cancelled by user.
当我从 SQL Server Management Studio 运行相同的存储过程时（使用与报告运行相同的登录凭据），该存储过程运行良好。
有什么想法可能导致这种情况吗？我尝试增加报告上的超时值，但这没有帮助。
I have a report that runs a stored procedure that takes about an hour to run.
After about 30 minutes I get this error message on the report body:
An error has occurred during report processing.
Query execution failed for data set 'DEV'.
A severe error occurred on the current command. The results, if any, should be discarded. Operation cancelled by user.
The same stored procedure runs fine when I run it from SQL Server management studio (with the same login credentials the report runs under).
Any ideas what could be causing this? I tried increasing the timeout value on the report but that didn't help.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
这听起来像是超时。我建议您不要将 SSRS 报告基于需要很长时间才能运行的存储过程。您可以安排一项日常作业来填充包含此报告数据的表（或多个表）并将报告指向此表。这样就不必每次都重新计算数据。
This just sounds like a timeout. May I suggest you don't base a SSRS report on a stored proc that takes so long to run. You could schedule a daily job to populate a table (or tables) containing this report data and point the report at this table. That way it doesn't have to recalculate the data every time.
您可以在 SQL Server 安装目录中找到日志。示例：C:\Program Files\Microsoft SQL Server\MSRS10.REPORTING\Reporting Services\LogFiles
You can find the logs in your SQL Server installation directory. example: C:\Program Files\Microsoft SQL Server\MSRS10.REPORTING\Reporting Services\LogFiles
这可能会有所帮助。
http://blogs. msdn.com/b/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
This might help.
http://blogs.msdn.com/b/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
检查报告的连接字符串。当我使用格式错误的连接字符串时，出现此错误。即当我应该有“Data Source=”时我有“Server=”。
Check your connection string for the report. I got this error when I had used a malformed connection string. i.e. I had "Server=" when I should have had "Data Source=".