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:

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