You’re offline. This is a read only version of the page.
My users are getting the "the Selected Purchase Request is being modified by another user" error every now and then. If they close out of the system and wait a while, they are able to logon and finish editing the requisition. I found troubleshooting instructions in the REquisition Management Administrator's guide that the indicate that the domain account specified for the application pool must be set up as a Business Portal user. I thought I did that a while back but I'm still getting this error. Does the user also have to member of a sharepoint group? If so, what group? What permissions? A user of the site collection?
Thanks!
*This post is locked for comments
So far this trigger appears to have solved the issue. Please note in our case that only one person is designated as the requisition purchaser at any given time so this works fine for us. However if you have multiple people pushing over requisitions at one time to GP then you could have issues where duplicate PO #'s are generated for a requisition that has already been pushed over. I haven't tested this per se to see if that is actually what happens, but it may be what occurs...
CREATE TRIGGER MaintainClearMultiUserManagerTable ON MultiUserManager
AFTER INSERT
AS
delete MultiUserManager where SessionID in (select SessionID from inserted)
Also, this is totally unsupported and may break other things, but so far for us it seems to be working. We've tested with entering, approving, rejecting, and pushing requisitions up the approval tree without issue.
This is a severe design flaw with the way business portal and requisition management works. I have no idea why it doesn't detect who it is that is locked in the table and then clear it out if it is the same user that is accessing the requisition as the person who has it locked based on the MultiUserManager table.
This data does get cleared out I think after 20 minutes, however that isn't a very acceptable proposition to 99% of companys to tell their users to wait 20 minutes and try again. I'm investigating putting on a trigger to the MultiUserManager table to just keep it cleared out as it causes more problems then it solves.
I have entered a feedback request to get this fixed. Please go vote on it here: https://connect.microsoft.com/dynamicssuggestions/feedback/details/534256/fix-issues-with-multiusermanager-table-in-requisition-management
It's on server 2003. I do think the multiusermanage table is not getting cleared. That's the problem. Does anyone know of a permanent fix for this problem? Clearing the table is not something I want to keep doing on a regular basis.
What OS are you using on the server? If you are using 2000, then the application pool owner must be added manually to BP.
Have you checked the 'multiusermanager' table in your DYNAMICS database?
Sometimes users are not cleared from this table. Run a query against it and watch it being cleared every half hour or so. Some user may not be clearing. You can then run a delete query against the table (delete multiuser etc. where userid = '?????'.
Other than that?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (