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. You receive "The selected company is being modified by another user" error message when you try to modify company data in Business Portal

You receive "The selected company is being modified by another user" error message when you try to modify company data in Business Portal

Symptoms

When you try to modify company data in the Manage Company Setup window, you receive the following error message:
The selected company is being modified by another user
This problem occurs when you use Requisition Management in Business Portal for Microsoft Dynamics GP and for Microsoft Business Solutions - Great Plains.

When this problem occurs, no other users are accessing this company data in Business Portal.

↑ Back to the top

Cause

The error message is caused by a user record that is not being cleared from the MultiUserManager table. The MultiUserManager table is located in the Dynamics database.

↑ Back to the top

Resolution

To resolve this problem, follow these steps:
  1. Run the following script in SQL Query Analyzer to see which user records are not being cleared in the MultiUserManager table.

    SELECT * FROM  DYNAMICS..MultiUserManager
    Note The MultiUserManager table should be cleared every 20 minutes. However, user records sometimes remain in the table.
  2. To delete the user record from the table, run the following script.



    Note Back up the Dynamics database before you run the script.
    DELETE DYNAMICS..MultiUserManager WHERE UserID = XXX
    Note Replace XXX with the user ID of the user record that was returned in step 1.

↑ Back to the top

More Information

Steps to reproduce the problem

  1. Start Business Portal.
  2. Click Sites Settings, point to Application Settings, point to Requisitions, and then click Company Setup.
  3. Select a company, and then click Modify.

↑ Back to the top

Keywords: kbfreshness2007, kbmbsgp10,, kbgreatplainsbp, kbmbsmigrate, kbprb, kb

↑ Back to the top

Article Info
Article ID : 906720
Revision : 1
Created on : 1/7/2017
Published on : 7/14/2012
Exists online : False
Views : 117