Forum Discussion

nmohanraja's avatar
nmohanraja
Frequent Visitor
5 years ago

Scheduled refresh failure across reports

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 with...
refresh error
Report Server
Scheduled data refresh
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
5 years ago

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's avatar
nmohanraja
Frequent Visitor
5 years ago

I ran DBCC CHECKDB and the results shows:

CHECKDB found 0 allocation errors and 0 consistency errors in database