Reporting Service 2008 R2 報表突然無法連線,重啟Reporting Service服務後就恢復正常。
經查看log檔(.\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles\~)
發現了下列Error message:
rshost!rshost!e54!11/01/2012-10:20:12:: e ERROR: Failed to create HttpRuntime 80131530.
rshost!rshost!e54!11/01/2012-10:20:12:: e ERROR: Failed to get appdomain 80131530, pipeline=0x000000000062FA40.
rshost!rshost!e54!11/01/2012-10:20:12:: e ERROR: Error state. Internal abort for pipeline=0x000000000062FA40 ...
查了一下Google發現應該是記憶體的issue,若不能加記憶體就只能從調整記憶體設定著手處理。
Reference:
http://social.msdn.microsoft.com/Forums/en-NZ/sqlreportingservices/thread/4c7e144f-64ca-4a4f-9ead-fc451f1bf371
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/52c8f51c-b72a-4525-a474-81d4f61d80c2/
http://msdn.microsoft.com/en-us/library/ms159206.aspx