Forum Discussion

Aditya_V_Vernek's avatar
Aditya_V_Vernek
Regular Visitor
3 years ago

Dataset refresh Failing at a particular time

Hello all ,
I have scheduled 3 refreshes , the problem is refresh is failing at a particuler time and its compleating perfectly in other times ... what could be the problem please help.

Need Help

4 Replies

  • cassidy's avatar
    cassidy
    Icon for Power Participant rankPower Participant
    3 years ago

    You'll need to provide the Error Message and Data Source types within the Dataset to receieve any help.

    • cassidy's avatar
      cassidy
      Icon for Power Participant rankPower Participant
      3 years ago

      So you hit the 5 hour Premium Capacity refresh limit, but since then it's refreshed normally at those same Start Times.

       

      How often do you hit the 5 hour limit?

       

      With SQL Server as the source, there can be activity on the Server that hurts your refresh, but I'd think that would result in a SQL Timeout error and not the Premium Capacity 5 hour limit.

  • luisrh's avatar
    luisrh
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    If you are hitting a transacational database,  I suggest you use dirty reads since your queries will not block or potentially be blocked by insert/update operations on databases.   This could be causing your timeouts as the dataset query may be blocked.      Use this on top of your dataset SQL --     

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED