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

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:

 

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

Thanks and best regards,

Hai

  • 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.
  • In reply to Yuneek Singh:

    Thanks for your reply.

    I'd restarted many times and this still happens.

    Thanks.
  • In reply to Hai:

    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
  • In reply to Steve Baird:

    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
  • In reply to Hai:

    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.

  • In reply to Steve Baird:

    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
  • In reply to Hai:

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

    Thanks and best regards,
    Hai
  • 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

  • In reply to maneesha de silva:

    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
Related