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 an error message when you open the "Manage Business Portal Users" page in Business Portal

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

View products that this article applies to.

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:

displayError: --- soap:Server System.Web.Services.Protocols.SoapException:Server was unable to process request. ---> Microsoft.BusinessFramework.Data.EntityDataNotFoundException: Microsoft.Applications.BusinessDesk.Dynamics.User

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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')

↑ Back to the top

Keywords: kbprb, kbmbsmigrate, kberrmsg, kbinfo, kbgreatplainsbp, kbsolomonbp, kb, kbmbsgp10,, kbfreshness2007, kbnosurvey, kbmbspartner

↑ Back to the top

Article Info
Article ID : 913827
Revision : 1
Created on : 3/25/2017
Published on : 1/3/2015
Exists online : False
Views : 267