During EndOfDay Customer facing the error"Could not continue scan with NOLOCK due to data movement".

During EndOfDay Customer facing the error"Could not continue scan with NOLOCK due to data movement".

Environment:

iVend 6.5 Update 6


Problem Statement: 

At the time of End of day Customer was facing below message “Could not continue scan with NOLOCK due to data movement” 




Proposed Solution:

 For this type of issue always check the management console log file. 


If MC log file shows error Message: 

Cannot open database "CXSHighwayTest" requested by the login. The login failed.Login failed for user 'sa'


Suggest to check database health checkup with the help of DBA. 


Steps if any: 

Require to check database health checkup by running the below command after backup of database 


 DBCC CHECKDB 


If it shows any inconsistency, then require to check with the help of DBA. 


Constraints / Scenarios: 

NA