While running a program, I am getting the error 107 - record is locked.

1) Is there a way to figure out which process is locking up this record?

2) Is there a way to remove this record lock?

Thanks,
Ajit.

Use Tools/Database Management/Misc/Remove Application Locks.

- Bader

Hi Bader,

Thanks for the response.

I have used this session to remove application locks.
However, the user is getting a problem with record locks and not application locks.

Can I use this session to figure out record locks as well?

Thanks for your time.

Ajit.

Unfortunately, No. That session will not tell you anything about record or table locks. I don't know of an easy way to find what is responsible for the lock (hopefully someone else will help). Here are two threads that deal with record locks but I doubt they will help. error 107 (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=119) record lock (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=978)

If your database is Oracle, the attached script might give you some insight into your locking problem.

Hi Gordon,

Yes, we have an oracle database.
I will get with our DBA to make use of this script.

Also,
The record lock has gone away and our user could run her session.

Thanks again for the script.

Ajit.