Dataset refresh Failing at a particular time

[Aditya_V_Vernek]

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.

[luisrh]

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

[Aditya_V_Vernek]

Data Source is Sql Server 

[cassidy]

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.

[cassidy]

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