75,730
I have a routine that imports PO's via eConnect. It works fine 99% of the time. Every now and then one comes across reporting this error.
9184 Document is currently being edited by another user.
How can this be possible since I am importing a new PO?
This happens totally randomly and the import process does POs in mass. Less than 0.1% of the time this happens. Trying to catch this will be very difficult.
could you run a SQL trace while running the import process to try figure out what happens right before the error comes up ?
dynamicsgpland.blogspot.com/.../trace-database-triggers-using-sql.html
Are you using straight eConnect calls or the MSMQ services ?
community.dynamics.com/.../using-the-econnect-incoming-and-outgoing-services-with-msmq
The PO numbers come from a database in a linked server. There is no way that a PO can exist in GP and in this other database until they are brought over to GP. All POs start in this external database. In eConnect all import routines are set to update if they already exist in GP so this makes this even stranger.
Richard,
You say "PO Number is supplied from an external database".. what do you mean by this ?
Are you using any lookup to grab the next PO number or does the numbering differ completely from the setup in GP ?
If a lookup is used with the eConnect SP's to grab the next number, it could be conflicting with a new PO that is just created by another user as suggested by Josh..
Otherwise, I'd double check some of the PM table to check if there isn't already the same document number used in the past.
PS: what tools are used to process the import to eConnect ?
The PO number is supplied from an external database to eConnect so that would not be what is causing this.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (