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 without any change, it runs fine on the first or second try. Please assist.

 

 

 

refresh error
Report Server
Scheduled data refresh

3 Replies

  • d_gosbell's avatar
    d_gosbell
    Super 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

  • d_gosbell's avatar
    d_gosbell
    Super User
    5 years ago

    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.