Scheduled refresh failure across reports

[nmohanraja]

Hi,

I have got data refresh scheduled for many reports on the on-premise report server. Different reports fail on each refresh cycle with error message as one of the below. On manual refresh without any change, it runs fine on the first or second try. Please assist.

[d_gosbell]

Have you checked the Windows Event viewer on the database server? The fact that the refresh works after a few re-tries is very strange and means that it's probably not a configuration or permissions issue since those should cause consistent failures with the same error message. I'm wondering if maybe you have a failing RAM module or something like that.

If you can't find anything in the event logs then you might need look at raising a help ticket with Microsoft support.

[d_gosbell]

Those errors about not being able to find certain stored procedures are a worry. I've never seen anything like that before. I'd suggest running a DBCC CHECKDB over your ReportServer database. You might have a corruption in your database or some sort of hardware issue on your SQL Server.

[nmohanraja]

I ran DBCC CHECKDB and the results shows:

CHECKDB found 0 allocation errors and 0 consistency errors in database