Post reply

Script Generate - Could not continue scan with NOLOCK due to data movement

  • March 18, 2011 at 4:16 am

    #236515

    Hi,

    When i generate the script i got the Could not continue scan with NOLOCK due to data movement error.

    Please any one can help me...

    Regards

    Kiruba

  • March 18, 2011 at 4:19 am

    #1300384

    Recently dealing with this error in another thread. You found a key via a nonclustered index lookup, and when it went back to the clustered index via keylookup, the row wasn't there.

    How often are you deleting data from the table that this is occuring on?

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • March 18, 2011 at 4:22 am

    #1300389

    'm not clear 'm just generate the script

  • March 18, 2011 at 4:27 am

    #1300394

    kirubamca09 (3/18/2011)

    'm not clear 'm just generate the script

    Then I'll help you find the point of the beginning of your investigation, we can't help you fix this, you MUST understand the database and what's happening in it to resolve this.

    You are either in READ UNCOMMITTED isolation level or have NOLOCKS on a table(s) in your query. These tables are being seeked via nonclustered indexes. Once it's located the rows it wants, it does a keylookup against the clustered index to find the rest of the information it needs for the remaining portion of the query.

    Between the finding of the rows in the NC index, and before it does the clustered index lookup, the rows are deleted/truncated. That's the cause of the error.

    Resolving it means understanding your database, the reasons it's occuring, and working around that problem by using different isolation levels (like serializable, which is very constricting), or removing the cause of the error.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply