Forum Discussion
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.
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