A get/change operation on table RM_Open failed. A record was already locked

Article ID: 856095 - View products that this article applies to.
Expand all | Collapse all

TechKnowledge Content

Question:

The error A get/change operation on table 'RM_Open' failed. A record was already locked appears when I go into the Apply Sales Document window (Transactions - Sales - Apply). I am trying to select a payment to apply to an invoice. How do I fix this?

Answer:

1.Be sure you have a current, restorable backup of your databases.

2. Exit all users from eEnterprise.

3. In Query Analyzer run the following statements:

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE tempdb..DEX_LOCK

DELETE tempdb..DEX_SESSION

4. Go back into eEnterprise and attempt to apply documents.



This article was TechKnowledge Document ID: 25095

Properties

Article ID: 856095 - Last Review: July 12, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Dynamics GP 2010
Keywords: 
kbmbsmigrate KB856095

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com