Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you try to retire an asset in Microsoft Dynamics GP: "This asset is being retired by another user. Please try later."

Error message when you try to retire an asset in Microsoft Dynamics GP: "This asset is being retired by another user. Please try later."

View products that this article applies to.

SYMPTOMS

When you try to retire an asset in Microsoft Dynamics GP, you receive the following error message:

          This asset is being retired by another user. Please try later

↑ Back to the top

CAUSE

This problem may occur when a record is locked in the Activity table.

↑ Back to the top

RESOLUTION

To resolve this problem, follow these steps:
1.

Make a backup of the company database in case unwanted data loss occurs.

Note You have the option to restore your backup to a test company database so that you can perform these steps in the test environment. If you do this, users will not have to log off of Great Plains immediately. When users are logged off, you can then process these steps against your live company database.

For more information about how to set up a test company that has a copy of live company data, click the following article number to view the article in the Microsoft Knowledge Base:

871973 How to set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, or SQL Server 2005
2. Have all users log off of Microsoft Dynamics Great Plains.
3. Delete the locked records. To do this, follow these steps:
a.

Do one of the following things:

• If you use Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start , point to All Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio .

• If you use Microsoft SQL Server 2000, start SQL Query Analyzer. To do this, click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer .

• If you use SQL Server Desktop Engine (also known as MSDE 2000), start Support Administrator Console. To do this, click Start , point to All Programs , point to Microsoft Administrator Console , and then click Support Administrator Console .



     
b. Run the following statement against the DYNAMICS database:

DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE DYNAMICS..ACTIVITY
c. Run the following statement against the TEMP database:

DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
d. Run the following statement against the company database:

DELETE FA01500
DELETE FAINDEX
DELETE FA00701
4. Retire the asset. To do this, point to Fixed Assets on the Transactions menu, and then click Retirement .

↑ Back to the top

Keywords: kb, kbnosurvey, kbMBSPartner, kbMBSMigrate, BemisKB860373, kberrmsg, kbtshoot, kbprb, kbExpertiseBeginner

↑ Back to the top

Article Info
Article ID : 860373
Revision : 1
Created on : 3/1/2017
Published on : 3/1/2017
Exists online : False
Views : 256