Table locking problem.

sunct

How to prevent table locking while posting simultaneously? can any one help? Thanks in advance.

nunomaia

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).

sunct

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?

nunomaia

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 ?

David_Singleton

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.

sunct

Thank you all ....