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.

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.

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.

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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×