大家有没有碰到SSRS无故重启的案例啊?或者是访问超时导致SSRS不停的中断?

0
具体描述如下:我看了一下日志,request路径:/ReportServer/Reserved.ReportViewerWebControl.axd 总访问这个。
已邀请:
2

BIWORK - 热衷于微软BI技术,技术架构和解决方案! 2013-11-21 回答

@梁勇 @卢育峰 我怎么感觉你们说的不是同一个问题啊!

@卢育峰 我觉得应该是你的 SSRS 报表 SESSION 到期,前端连接到这个报表的时候因为找不到而发生的错误。


1.PNG

你在 ReportServer 那里找到相应的报表试着在它的属性那里设置一下 Do not timeout report。如果你的报表是以 rdl 文件形式放到 SharePoint 或者其它什么地方管理,你还需要找找在哪里能够控制一下报表的 Session 到期问题。

如果我上面图片中的设置还不管用的话,你还是可以沿着 SESSION Timeout 这个思路去检查一下其它能够管理 Session 的地方,尽量一试希望能够解决问题吧!
0

BIWORK - 热衷于微软BI技术,技术架构和解决方案! 2013-11-21 回答

能不能把全部日志都贴出来,有时错误信息前后可能是有关联的,看看其它 INFO 的信息大概都涉及到了哪些内容,然后再具体分析一下 ERROR 信息。
0

梁勇 - 天道酬勤、上善若水。爱好商业智能 2013-11-21 回答

@BIWORK 一直报这个错误
1.jpg
0

BIWORK - 热衷于微软BI技术,技术架构和解决方案! 2013-11-21 回答

这个应该不是造成 SSRS 无故重启的原因吧?这个是不是用的不是 IE 浏览器比如用的是Google,或者 Safari 浏览器导致传递参数丢失而发生的异常,但不是导致 SSRS 重启的根本原因。

你让这位朋友把他的日志中的 第一个 ERROR 前后的片段日志都拷贝出来看看有没有什么比较重要的异常信息。
0

brucelu - 大数据、数据仓库、数据挖掘均有涉猎 2013-11-21 回答

首先我在RS的SQLDUMPER_ERRORLOG.log里面发现这个
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 10100
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000001232EB0
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 10100
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000001232EB0
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(1964:1DC4) 11/20/13 14:30:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(1964:1DC4) 11/20/13 14:30:26, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(1964:1DC4) 11/20/13 14:30:26, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\SQLDmpr0521.mdmp
(1964:1DC4) 11/20/13 14:30:26, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(1964:1DC4) 11/20/13 14:30:26, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1964:1DC4) 11/20/13 14:30:26, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1964:1DC4) 11/20/13 14:30:26, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(1964:1DC4) 11/20/13 14:30:26, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1'
(1964:1DC4) 11/20/13 14:30:26, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1'
(1964:1DC4) 11/20/13 14:30:26, ACTION, ReportingServicesService.exe, Watson Invoke: No
0

brucelu - 大数据、数据仓库、数据挖掘均有涉猎 2013-11-21 回答

然后找了一个SQLDmprXXXX.log看了一下
webserver!ReportServer_0-1!13a8!11/20/2013-14:42:14:: i INFO: Processed report. Report='/市场报表', Stream=''
library!ReportServer_0-1!1e28!11/20/2013-14:42:23:: i INFO: RenderForNewSession('/公司统计报表')
library!ReportServer_0-1!1e28!11/20/2013-14:42:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , 报表服务器数据库内出错。此错误可能是因连接失败、超时或数据库中磁盘空间不足而导致的。;
session!ReportServer_0-1!1e28!11/20/2013-14:42:49:: e ERROR: Error in getting session data: Expired Session: cn1zljiqfw2z4uanm3c2pnmz
session!ReportServer_0-1!1e28!11/20/2013-14:42:49:: i INFO: LoadSnapshot: Item with session: cn1zljiqfw2z4uanm3c2pnmz, reportPath: , userName: XXXX\AAA not found in the database
library!ReportServer_0-1!1e28!11/20/2013-14:42:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: 报表执行操作 cn1zljiqfw2z4uanm3c2pnmz 已过期或找不到该操作。;
library!ReportServer_0-1!14dc!11/20/2013-14:44:07:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , 报表服务器数据库内出错。此错误可能是因连接失败、超时或数据库中磁盘空间不足而导致的。;
session!ReportServer_0-1!14dc!11/20/2013-14:44:07:: e ERROR: Error in getting session data: Expired Session: 2ghedzvhzelql255cdvb1pz0
session!ReportServer_0-1!14dc!11/20/2013-14:44:07:: i INFO: LoadSnapshot: Item with session: 2ghedzvhzelql255cdvb1pz0, reportPath: , userName: XXXX\AAAA not found in the database
library!ReportServer_0-1!14dc!11/20/2013-14:44:07:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: 报表执行操作 2ghedzvhzelql255cdvb1pz0 已过期或找不到该操作。;
library!ReportServer_0-1!21e0!11/20/2013-14:44:07:: i INFO: RenderForNewSession('/实时监控报表')
rpcserver!DefaultDomain!1d8c!11/20/2013-14:48:48:: i INFO: Managed server timed out possibly caused by slow GC. Granting additional timeout of 30 sec.
webserver!ReportServer_0-1!1e28!11/20/2013-14:49:18:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: , Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: 报表服务器在 HttpApplication 中遇到未处理的异常。 ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeClientDisconnectionException: 某个客户端已断开与报表服务器 Web 服务应用程序域 ReportServer_MSSQLSERVER_0-1-130294029791297011 的连接。不需要采取纠正措施。已将错误代码提交到 ASP.NET 以释放该连接。错误代码是 800708CA。 ---> System.Runtime.InteropServices.COMException (0x800708CA): 此网络连接不存在。 (Exception from HRESULT: 0x800708CA)
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.GetAuthType()
at ReportingServicesHttpRuntime.RsWorkerRequest.GetUserToken()
--- End of inner exception stack trace ---
at ReportingServicesHttpRuntime.BaseWorkerRequest.FilterAndThrowException(Exception e, String message)
at ReportingServicesHttpRuntime.RsWorkerRequest.GetUserToken()
at System.Web.HttpContext.get_ImpersonationToken()
at System.Web.ClientImpersonationContext.Start(HttpContext context, Boolean throwOnError)
at System.Web.HttpApplication.ThreadContext.SetImpersonationContext()
at System.Web.HttpApplication.ThreadContext.Enter(Boolean setImpersonationContext)
at System.Web.HttpApplication.OnThreadEnterPrivate(Boolean setImpersonationContext)
at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
--- End of inner exception stack trace ---;

要回复问题请先登录注册