SQL Server reporting services scheduler loops, running amok

0

We have a Windows Server 2008 R2, Service Pack 1 with an SQL Server 2008 R2 (Microsoft SQL Server Standard Edition (64-bit), version 10.50.4042.0) for creating scheduled reports in SSRS. The Report Server services didn't start up after a server restart a while ago and when I noticed that after several days, I started the service. Then it began to loop thru all reports constantly, as if the server not was aware of that it had already done that report.

When I look in the table [ReportServer].[dbo].[ExecutionLogStorage] I can see that new reports are created constantly as fast as the previous report is ready. It looks to loop thru all reports.

I found two errors in Windows application log which maybe are connected to the problem, or not.

Failed to unload app domain DefaultDomain. The following exception occurred: Error while unloading appdomain. (Exception from HRESULT: 0x80131015).

ProcessName: ReportingServicesService ProcessId: 4308 Failed to trace event: System.AppDomainUnloadedException: Attempted to access an unloaded AppDomain.

I really don't understand what to do. The server has been running for several years, doing the scheduled jobs without any problem. I have restarted SQL Server Agent, Reporting Services as well as the whole server and it doesn't make any difference.

I am thankful for any help.

Lage

sql-server
reporting-services
sql-server-2008-r2
ssrs-2008-r2
asked on Stack Overflow Feb 11, 2017 by user2379527 • edited Jun 20, 2020 by Community

1 Answer

0

User contributions licensed under CC BY-SA 3.0