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 delete a user record that is stuck in the User Activity window: "Get Change Operation on SY_Current Activity Record Was Already Locked"

Error message when you try to delete a user record that is stuck in the User Activity window: "Get Change Operation on SY_Current Activity Record Was Already Locked"

View products that this article applies to.

Symptoms

When you try to delete a user record that is stuck in the User Activity window in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you receive the following error message:
Get Change Operation on SY Current Activity Record Was Already Locked

↑ Back to the top

Resolution

To resolve this problem, delete the record that is associated with the stuck user from the ACTIVITY table by using SQL Server Management Studio or SQL Query Analyzer.

To delete the record from the ACTIVITY table, follow these steps:
  1. Determine the userid of the user who is stuck by viewing the User Activity window. To do this, follow the steps for your version of the program.

    Microsoft Dynamics GP 2010 or Microsoft Dynamics GP 10.0

    On the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to System, and then click User Activity.

    Microsoft Dynamics GP 9.0 or earlier versions

    On the Tools menu, point to Utilities, point to System, and then click User Activity.
  2. On the computer that is running Microsoft SQL Server, start SQL Server Management Studio or SQL Query Analyzer. To do this, follow the steps for the program that you use.

    SQL Server Management Studio 2008 or SQL Server Management Studio 2005
    1. Click Start.
    2. Click Programs.

    3. Point to Microsoft SQL Server 2005 or to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
      Note The Connect to Server window opens.
    4. In the Server name box, type the name of the instance of SQL Server.
    5. In the Authentication list, click SQL Authentication.

    6. In the User name box, type sa.


    7. In the Password box, type the password for the sa user.
    8. Click Connect.
    SQL Server 2000
    1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    2. In the Server name box, type the name of the instance of SQL Server.
    3. In the Authentication list, click SQL Authentication.
    4. In the User name box, type sa.
    5. In the Password box, type the password for the sa user, and then click Connect.
  3. Make a SQL backup copy of the ACTIVITY table by running the following script.
    SELECT * into DYNAMICS..ACTIVITY_BAK from DYNAMICS..ACTIVITY
  4. Run the following script against the DYNAMICS database. 
    DELETE DYNAMICS..ACTIVITY WHERE USERID = '<XXX>'
    Note Replace <XXX> with the userid that you want to remove. For example, run the following script:

    DELETE DYNAMICS..ACTIVITY WHERE USERID = 'John'
  5. Start Microsoft Dynamics GP.
  6. After you verify that the user was removed successfully from the ACTIVITY table, and you can log in successfully, run the following script to drop the backup table that you created in step 3.
    DROP table DYNAMICS..ACTIVITY_BAK

↑ Back to the top

Keywords: kbentirenet, kbmbsgp10,, kbfreshness2007, kberrmsg, kbexpertisebeginner, kbtshoot, kbprb, kbexpertiseinter, kbmbspartner, kbmbsmigrate, kb

↑ Back to the top

Article Info
Article ID : 849240
Revision : 1
Created on : 1/7/2017
Published on : 6/14/2012
Exists online : False
Views : 298