Navision 4.0 SP1: "Locked by another user" Errors

r0d0t
r0d0t Member Posts: 3
edited 2008-10-15 in NAV/Navision Classic Client
Hi,

Does anyone know what causes these errors and how to prevent them?

Locked by another user -> Journal Line Dimension Table
-> General Journal Dimension Table

We are running on SQL2000 and Windows Server 2003.

Any help or breadcrumbs would be appreciated.

tks,
d.

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Are you an enduser or a navision partner?

    If you are enduser you should contact your navision partner and he should sent you a specialist to review the locking.

    If you are a partner you need to search the forum about locking and deadlocking issues. There are performance tuning guides provided by Microsoft.
    Marije Brummel | Freelance Business Central Specialist
  • r0d0t
    r0d0t Member Posts: 3
    Hi,

    Thanks for the reply.

    I'm an end user who supports Navision from within our companies I.T. department. I sent an email to our MS Navision Partner who customized the system for us but have had no replies.

    I'll search the forum in more detail to see what can be found.

    Thanks,
    d.
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    OK.

    Locking issues can be very complicated and have to be looked at by a profesional in order not to make it worse.

    If you have more information on how the locking is created maybe we can work out a solution,
    Marije Brummel | Freelance Business Central Specialist
  • kine
    kine Member Posts: 12,562
    1) The locking message is connected to new feature in 4.00SP1 - Lock timeout. This timeout can be set in File-Database-Alter dialog. There is 10seconds by default (in previous versions it was 0 - infinite)

    2) If you have too much locking errors, you can:

    a) set longer timeout (but this is not solution, it is just shifting the time limit)
    b) optimize your server Hardware (you need to do the work as fast as possible to not lock others...)
    c) optimize your DB
    d) optimize the application
    e) reorganize the processes
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • gdkve9
    gdkve9 Member Posts: 161
    kine wrote:
    2) If you have too much locking errors, you can:

    a) set longer timeout (but this is not solution, it is just shifting the time limit)
    b) optimize your server Hardware (you need to do the work as fast as possible to not lock others...)
    c) optimize your DB
    d) optimize the application
    e) reorganize the processes
    Mr.kine..

    Can you please describe How to do the each one so that we all will be very thankful to you? Zst waiting for your wonderful explanation on each one.

    Regards in advance
    Dilip
    Falling down is not a defeat..defeat is when you refuse to get up.
  • kine
    kine Member Posts: 12,562
    Sorry gdkve9, but that's all what I will write. There is more info about each point on this forum, and all this is know-how which cannot be transfered through forum posts... May be someone other will give you the info there, but I recommending to go through this forum, downloading videos about the optimization etc.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    gdkve9 wrote:
    Mr.kine..

    Can you please describe How to do the each one so that we all will be very thankful to you? Zst waiting for your wonderful explanation on each one.

    I think this pretty much sums up where we are heading.

    If we start to answer a question when we know that the answer will be used wrongly by someone else, it starts a chain of events.

    Forums are a great place to learn and to find tricks and tips, but they can never replace proper training.

    You need to go to your boss, and tell him that the company needs to either A/ invest in proper training, or B/ get out of the software business, and sell something else.

    PS Kamil sorry to say it, but you brought this on your self. :mrgreen:
    David Singleton
  • David_Singleton
    David_Singleton Member Posts: 5,479
    kine wrote:
    1) The locking message is connected to new feature in 4.00SP1 - Lock timeout. This timeout can be set in File-Database-Alter dialog. There is 10seconds by default (in previous versions it was 0 - infinite)

    2) If you have too much locking errors, you can:

    a) set longer timeout (but this is not solution, it is just shifting the time limit)

    Since I know how some "developers" read posts in this forum, I just want to emphasize this :
    kine wrote:
    but this is not solution

    Because I just know that in a months time someone will read this post, set time out to 10 minutes and say "Hey boss look how great I am I solved it".
    David Singleton
  • kapamarou
    kapamarou Member Posts: 1,152
    David Singleton wrote:
    Because I just know that in a months time someone will read this post, set time out to 10 minutes and say "Hey boss look how great I am I solved it".

    Indeed... [-X
  • gdkve9
    gdkve9 Member Posts: 161
    Thank U all guys :(
    Dilip
    Falling down is not a defeat..defeat is when you refuse to get up.

Categories