Table locking problem.

sunct
sunct Member Posts: 72
edited 2007-04-18 in NAV/Navision Classic Client
How to prevent table locking while posting simultaneously? can any one help? Thanks in advance.
Regards,
Sunil

Comments

  • nunomaia
    nunomaia 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/
  • sunct
    sunct 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
  • nunomaia
    nunomaia 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_Singleton
    David_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
  • sunct
    sunct Member Posts: 72
    Thank you all ....
    Regards,
    Sunil

Categories