Could not continue scan with NOLOCK due to data movement

Could not continue scan with NOLOCK due to data movement

Post by V2VlTGV » Wed, 23 Nov 2005 10:33:01


Hi all,
I'm facing some critical problems on my WSUS server. When i open the WSUS
console on my browser, the Status will be refreshing for a long period. After
that, there will be web page error dialog that says "Could not continue scan
with NOLOCK due to data movement." I believe this should be an error from the
SQL agent but could not find a solution for it. Appreciate if anybody could
help on this. Thanks!
 
 
 

1. Could not continue scan with NOLOCK due to data movement.

2. 601 - Could not continue scan with NOLOCK due to data movement.

Hi,

Lately, I have been getting this problem with a client. The query returns
around 6 thousand records, there is one user only and it's a select statement
with a temporary table in the join.

The server has a sp4 installed. It's a 2003 server.


CREATE TABLE #Temp (Temp_Id INT,
Temp_Id_Count INT NULL,
Temp_Id_Dt DATETIME NULL)

INSERT INTO #Temp (Temp_Id, Temp_Id_Count, Temp_Id_Dt)
SELECT T.Temp_Id, COUNT(TR.Temp_Id_Count), MAX(TR.Temp_Id_Dt)
FROM Test T WITH (NOLOCK)
LEFT JOIN Test_History TR WITH (NOLOCK) ON TR.Temp_Id = T.Temp_Id
WHERE T.Status_Cd = 1234
GROUP BY T.Temp_Id

SELECT DISTINCT T.Temp_Id, S.Client_Id, S.Subject_Id,
FROM SavedData S WITH (NOLOCK)
JOIN #Temp T ON T.Temp_Id = S.Temp_Id

The error after a few seconds is 601 - Could not continue scan with NOLOCK
due to data movement.

Any ideas?

Thanks in advance

3. Could not continue scan with NOLOCK due to data movement

4. I reach this message : "Could not continue scan with NOLOCK due to data movement

5. Could not continue scan with NOLOCK due to data movement error

6. Urgent: 601 - Could not continue scan with NOLOCK due to data movement.

7. Urgent:601 - Could not continue scan with NOLOCK due to data movem

8. "Could not continue scan with NOLOCK due to data" error during Replication Synchronization

9. Urgent:601 - Could not continue scan with NOLOCK due to data m

10. Could not continue scan with NOLOCK due to data movement. when del

11. Could not continue scan with NOLOCK due to data movement. when delete a record

12. Httpd.dll Data Aborts due to embedded NULL in request header found during vulnerability scan

13. textscan doesn't scan data, but does scan similar data

14. Bushism, Bushist movement is not a clown movement.