You receive a "Server was unable to process request" error message when you try to change a Business Portal user record in Microsoft Great Plains or in Microsoft Dynamics SL


Symptoms


You receive the following error message when you try to modify a Microsoft Business Solutions Business Portal user record:
displayError: --- soap:Server System.Web.Services.Protocols.SoapException: Server was unable to process request.

Cause


This problem occurs because the Business Portal user record is associated with an invalid back office user record. The Business Portal user record becomes invalid when the following records are removed from the back office with which the Business Portal user record is associated:

  • Employee ID / Company
  • Salesperson ID / Company
  • Manager / Company
  • Vendor ID / Company
  • Customer ID / Company

Resolution


To resolve this problem, remove the MbfRoleUser records that contain the invalid user records from the MbfRoleUser table. To do this, follow these steps.

Note In Great Plains, the MbfRoleUser table is located in the Dynamics database. In Dynamics SL, the MbfRoleUser table is located in the system database.
  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  2. Find the ID of the Business Portal user. To do this, paste the following statement in Query Analyzer, and then click the green arrow button.
    select ID, Name from MbfUser where Name = 'UserName'
    Note Replace XXX with the actual name of the user in Business Portal. The statement returns output that is similar to the following:
    ID = 22723F13-9A89-4401-AF75-0988D09787BD
    Name = Pilar Ackerman
  3. Find the advanced roles to which the Business Portal user is assigned. To do this, run the following statement in Query Analyzer.
    select UserID, Constituent from MbfRoleUser where UserID = '22723F13-9A89-4401-AF75-0988D09787BD'
    The statement returns the following:
    UserID = 22723F13-9A89-4401-AF75-0988D09787BD


    Constituent <entityKey><Microsoft.Dynamics.Common.Company.Company ID="-1" /><Microsoft.Dynamics.Hrm.Entity.Employee ID="BARR0001" /></entityKey>
    Note The Constituent row lists the invalid user records.
  4. Remove the invalid user record. To do this, make a backup of the database, and then run the following statement in Query Analyzer.
    delete MbfRoleUser where Constituent like '%BARR0001%'
    Note Replace BARR0001 with the Constituent value returned in step 4.

More Information


Steps to reproduce the problem

  1. Start Business Portal.
  2. Click Site Settings, point to Users and Permissions, and then click Manage Business Portal Users.
  3. Click a user, and then click Modify in the Advanced Roles area.
  4. Assign the user to the Employee/Company advanced role and assign a specific employee. To do this, follow these steps:
    1. Click the Role/Company list.
    2. Click Employee/Your Company.
    3. Click an Employee Id in the Alias ID list.
    4. Click OK.
  5. Start Great Plains.
  6. Click Tools, point to Setup, point to System, and then click Company.
  7. Click the lookup glass, click the company that you specified in step 4, click OK, and then click Delete.
  8. In Business Portal, click Site Settings, point to Users and Permissions, and then click Manage Business Portal Users.
  9. Click the user whom you clicked in step 3.