Locked Table General Journal Line Dimension

ta5
ta5 Member Posts: 1,164
edited 2006-03-15 in NAV/Navision Classic Client
Hi
We have an interface report that fills records in Table "General Journal Line".
While it is running, nobody else can insert records in that table, because they get the Error "Table General Journal Line Dimension is locked by user xy".

My questions:
1) Is there a way to find out, which operation is causing the lock (implicitly or explitly)?
2) It seems this is a standard problem. Anybody has a workaround for that?

Regards
Thomas

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Is your report filling that table directly or does that happen because of field validation? You may want to try committing every so many journal lines, that releases locks and may allow other processes to jump in between.

    You'd use the client monitor to identify what is going on.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ta5
    ta5 Member Posts: 1,164
    Hi Daniel
    Thx for your answer. The Journal Line Dimensions are inserted through field validation.
    Commit is imho no option, because all or no lines should be imported by the interface.

    Client monitor: Do I need to start this on the machine that executes the code that causes the lock -- or on the machine that is locked out?

    Regards
    Thomas
  • DenSter
    DenSter Member Posts: 8,307
    I woud run it on both machines and see what happens. A lock is not a bad thing you know, it just takes time. You could maybe consider running the import on a faster machine (or a server even, or maybe in an instance of NAS), or schedule it at a time that people are not as busy in the system.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories