web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Script Error in Manage Portal Users - Business Portal

(0) ShareShare
ReportReport
Posted on by 1,257

Script Error in Manage Portal Users.

Please advice on the script error attached in Business Portal.

 

*This post is locked for comments

I have the same question (0)
  • Rob Bernhardt Profile Picture
    on at
    Re: Script Error in Manage Portal Users - Business Portal

    Mike,  the message suggests that a user with that name already exists.  Is this an error that you receive for a specific user or all users?  You could take a look at DYNAMICS..MBFUser, MBFUserWindowsIdentity, MBFRoleUser, and MBFRole.  They might offer clues if the user already exists.

    Thanks

    Rob

  • Mike2011 Profile Picture
    1,257 on at
    Re: Script Error in Manage Portal Users - Business Portal

    Hi Rob,

     

    If it exist on the table should i delete them on the back end?

    What would be key relationship for each table?

     

    Is there a stored proc that business portal use to delete specific user that we can execute?

     

    Thanks,

    Mike

  • Rob Bernhardt Profile Picture
    on at
    Re: Script Error in Manage Portal Users - Business Portal

    Mike,

    I'm confused as to why it would be in the table, but you would also be adding it through BP.  Is it not showing in the UI?  Nonetheless, you could try deleting in the following order:  MbfRoleUser, MbfUser, and MbfUserWindowsIdentity.  I'm not aware of a stored proc for this.

    Make sure you take a backup first.

    Thanks

    Rob

  • Mike2011 Profile Picture
    1,257 on at
    Re: Script Error in Manage Portal Users - Business Portal

    Thanks Rob it helps,

    We were unable to successfully add user in Business Portal because of the error that appears on Modify Advanced Roles.

    Looking on the Manage Business Portal Users it does not exist,

    But on the table it exist.

    What ussually cause this problem?

    Regards,

    Mike

  • Rob Bernhardt Profile Picture
    on at
    Re: Script Error in Manage Portal Users - Business Portal

    Mike,

    It's hard to say.  You're using a version of BP that is quite old.  I haven't seen that sort of issue in awhile.  Did you try resolving by modifying the sql tables?

    Thanks

    Rob

  • Mike2011 Profile Picture
    1,257 on at
    Re: Script Error in Manage Portal Users - Business Portal

    Hi Rob,

    It resolves by deleting the orphaned user in the database.

    Also can we use the tables above to remove specific users in the backend?

    Because In Manage Business Portal Users it takes time to remove a user, you have to scroll the button to find the users to be deleted.

    It lacks the search interface.

    Regards,

    Mike

  • Rob Bernhardt Profile Picture
    on at
    Re: Script Error in Manage Portal Users - Business Portal

    MIke,

    It wouldn't be recommended to regularly manipulate your data through SQL.  There are cases where sql tables and their relationships could get out of sync by doing this.  It's certainly your choice and an option when things aren't working correctly.

    Thanks

    Rob

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans