Locked Table General Journal Line Dimension

ta5

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

DenSter

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.

ta5

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

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.