got error - table lock - it is used by another person..

JAYESH

i got errror message ..like item journal table cannot be changes it is used by another user..while i import data.....

nunomaia

If another user is doing some task that locks item journal, other users must wait.
Can you confirm what the other user is doing?

JAYESH

they only tell me another user used this table..but not mention name...we have lot many user..it is difficult to find it out..

can u tell me ..it's is journal..fundamental..for navision. if another user working on same table..it locks ???

nunomaia

On posting it will lock journal batch in SQL Server and all table in native database.

If that message doesn't disappear you probally have a deadlock or another user is importing somesthing that lock that table. But that normally is custom development.

JAYESH

thanks

kine

You can find out more info who is blocking when you look into Session table (File - Database - Information - Sessions - Current Sessions - DrillDown).