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?
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.
Comments
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
Sunil
Can you give detailed Navision client / objects and Server ?
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
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.
Sunil