Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

NOLOCK, READPAST and SQL table locking

Hi all,

I have a bit of a tricky problem that seems to be happening in QV but not SQL Management Studio.

I have been using NOLOCK previously for extracting data from a frequently used database (I know table hints are a last resort!). As I have been using this, one of the problems I encounter is occasionally there is a "dirty read" of uncommitted data. This isn't very often but enough to wonder if there is another solution.

I have seen that using the READPAST table hint can solve issues with table locking and also mean that I do not extract any uncommitted data. Testing this in SQL Management Studio confirms that READPAST does not extract data still open (in an uncommitted transaction).

Great!

But the problem seems to be that when I try this in QV it doesn't work like that (is this due to OLEDB?). QV will extract to a point and then wait until the open transaction has been committed or rolled back.

Does anyone have any ideas why this is?

Thanks,

Chris

1 Reply
Highlighted
Partner
Partner

Re: NOLOCK, READPAST and SQL table locking

Hey,

 

Did you by chance ever find a solution/work around? Having same issue.