No Lock due to data movement.

RV_18

Hello everybody,

I am using Nav 2009 with SQL server 2008 R2.

While running order planning in Navision, system is throwing this error :-

"The following SQL Server error or errors occurred when accessing the Reservation Entry table:
601,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data movement."

I checked all the possible reasons and their solutions, but i am unable to find the root cause for this and its solutions.

Can anyone please help me out of it.

Many thanks.

swati_india

Trying replicate your problem on Standard Database. If the problem persist then contact Microsoft else check for bug in your customization/setup.