You receive an error message when you open the "Manage Business Portal Users" page in Business Portal

Symptoms

When you open the Manage Business Portal Users page in Business Portal in Microsoft Dynamics GP or in Microsoft Dynamics SL, you receive the following error message:

Cause

This issue occurs when the following conditions are true:

• The record of a customer, a vendor, a salesperson, an employee, a user, or a manager was deleted from the back office databases.

• A Business Portal user is mapped to this record through an advanced role.

Because the record was deleted from the back office databases, the Advanced Roles Web Part does not appear when you open the Manage Business Portal Users page. Therefore, the assigned advanced role cannot be unassigned. Because the advanced role cannot be unassigned, you receive the error message that is mentioned in the "Symptoms" section.

Resolution

To resolve this issue, search for assigned advanced roles that are no longer valid. To do this, run one of the following scripts:

• For Microsoft Dynamics GP or for Microsoft Business Solutions - Great Plains, download the AdvdRoleOrphaned_GP.sql script. Then, run the script against the Dynamics database.The following file is available for download from the Microsoft Business Solutions File Exchange Server:
  
  
  

  AdvdRoleOrphaned_GP.sql Release Date: January 24, 2006
  
  
  
  
  Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
  
  

• For Microsoft Dynamics SL or for Microsoft Business Solutions - Solomon, download the AdvRoleOrphaned_SL.sql script. Then, run the script against the system database. The following file is available for download from the Microsoft Business Solutions File Exchange Server:
  
  
  

  AdvRoleOrphaned_SL.sql Release Date: January 24, 2006
  
  
  
  
  Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
  
  

Note A report is generated when you run the script. If the script finds assigned advanced roles that are no longer valid, a clean-up script is provided in the report. For example, the report in the "More Information" section provides a clean-up script that describes how to delete a record.

More Information

The script generates a report that is similar to the following:Searching for User ID: LESSONUSER1 of type: Microsoft.Applications.BusinessDesk.Dynamics.User

The Back Office/Enterprise Role LESSONUSER1 was not found in the User master table (SY01400).
UserID: 110A1DC6-F1E8-4892-B517-4DE353D63DDE
RoleID: 97EFA56C-75A9-489D-9ACA-2BF0DCFCA1B0
Container ID: D98C1DD4-008F-04B2-E980-0998ECF8427E
Constituent Role: <entityKey><Microsoft.Applications.BusinessDesk.Dynamics.User ID="LESSONUSER1" /></entityKey>

To delete this record, execute the following:
delete from MbfRoleUser where (UserID = '110A1DC6-F1E8-4892-B517-4DE353D63DDE' and
RoleID = '97EFA56C-75A9-489D-9ACA-2BF0DCFCA1B0' and ContainerID = 'D98C1DD4-008F-04B2-E980-0998ECF8427E')