NAV 2016 - Workflow problem (table locked) when send multiple approval requests at the same tiem

Business Central/NAV User Forum
1

Dear all,

I got this problem when implementing standard Workflow template ‘Sales Order Approval Workflow’ to my client.

The case is that 3 or 4 users send Approval Request at the same time, then this happened:

Workflow_Error.png

Any one got this problems before? Please share your ideas about this.

Thanks and best regards,

Hai

2

This is basically due to the buffer storage of navision which locks the transaction, all you need to do is restart the nav instance and it will work.

3

Thanks for your reply.

I’d restarted many times and this still happens.

Thanks.

4

Increase the interval time on your Workflow job queue entry to enable the process to complete before starting a new iteration of the job.

Cheers
Steve

5

Hi Steve,

Thanks for your reply.
Can you please be more specific how to setup the Interval Time? My workflow setup make no Job Queue Entry when running?

Thanks,
Hai

6

My workflows are all controlled by a job queue supporting the send of the approval requests. Under the job queue in the job queue entries we run the relevant codeunit with a specific interval time between occurrences as such.

pastedimage1485221566472v1.png
pastedimage1485221566472v1.png1216×126 5.1 KB

7

Dear Steve,

That’s a way to control but that’s not standard.
What I want to ask about is how Standard NAV handle these situations.

Thanks and best regards,
Hai

8

I’m sorry to bring this up again. Please share your ideas about this problem.

Thanks and best regards,
Hai

9

Hi ,
This is not a issue , its like batch posting(on the same batch only one user can post ast the same time)
This is also like that this message you get a user sand the approval request at the same time , other wise its ok
just ask user to try post after same seconds it will be posted

10

Hi Mr. Silva,

Thanks for your reply.
I think it’s not practical at all if user have to wait a few second for each request. For example, my clients has 2 offices so how the users of each office know when it’s suitable to send the request??

I think this is a NAV standard issue.

Thanks,
Hai