Same codeunit executed at the same time by 2 users

Gonzalo · 2016-07-15

Hi there,
Do you know if is it possible to lock a codeunit for user? What I mean it's, if one user is executing a codeunit, I shouldn't allow another user to execute the same codeunit. This codeunit takes a few seconds because gets a xml from an external web service.

Thanks
(My version is nav 2016)

geordie · 2016-07-15

You can use "traffic light" boolean field in a setup table.
Set it to true at the beginning and back to false at the end; add a control on this field as first instruction of your codeunit.

kriki · 2016-07-15

Even better:
Use a any setup table and lock it like this at the beginning of the codeunit:

Setup.LOCKTABLE;
Setup.FINDFIRST;

If the session crashes, the transaction is undone and the record released.
If you use a traffic light and change it and COMMIT it and your session crashes, the traffic light remains red...

DenSter · 2016-07-15

You could also consider using the job queue

vaprog · 2016-07-15

DenSter wrote: »

You could also consider using the job queue

Really? Does this not just fire multipe backgrouns sessions which run in parallel?

DenSter · 2016-07-16

Do you mean a background session for each task? I think the standard job queue starts a single background session for each company and it executes the tasks one after the other for each company. I do think you can set it up in a number of ways though. You can direct a certain type of entry to a certain session, and that session will execute the entries one after the other. It's been a while since I've really looked at it, so it might have a bunch of new capabilities.

You could also create a custom queue that is based on the job queue and start that in its own NAS Service Tier.

Howdy, Stranger!

Quick Links

Categories

Same codeunit executed at the same time by 2 users

Answers