Table locking problem.

sunctsunct Member Posts: 72
How to prevent table locking while posting simultaneously? can any one help? Thanks in advance.
Regards,
Sunil

Comments

  • nunomaianunomaia Member Posts: 1,153
    I don’t understand your question. Table locking normally it’s used to prevent to users to post at same time in same table (numbering, etc).
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • sunctsunct Member Posts: 72
    We are using Navision 4.0 . The end users have to wait for minutes to post documents like PO, GRN etc. The message shown is "The table is locked by other users". Is there any way to reduce this waiting time?
    Regards,
    Sunil
  • nunomaianunomaia Member Posts: 1,153
    I guess you are experience deadlocks. Check custom development and in partnersource if there is a fix for your problem.

    Can you give detailed Navision client / objects and Server ?
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • David_SingletonDavid_Singleton Member Posts: 5,479
    sunct wrote:
    We are using Navision 4.0 . The end users have to wait for minutes to post documents like PO, GRN etc. The message shown is "The table is locked by other users". Is there any way to reduce this waiting time?

    Firstly take a look at this thread. (It doesn't matter if its SQL or Native, the principle is the same.

    I think in reality locking is not your key issue here. The core is probably that you system in general is not fast enough for the work load.

    The short term solution is to boost your hard ware, by identifying key bottle necks and fixing them. But in reality this issue needs to be resolved by system tuning, and most importantly user training.
    David Singleton
  • sunctsunct Member Posts: 72
    Thank you all ....
    Regards,
    Sunil
Sign In or Register to comment.