Question

LF 9.2 database table for Locked Open docs?

Laserfiche

Updated February 5, 2015

asked on February 5, 2015

In 9.0.2 our client used two database queries on a scheduled basis identifying documents checked out or locked open (but not checked out).

They used this to automatically email users and remind them of open files or checked out documents. These queries accessed the ENTRY_LOCK table in the LF database in 9.0.2. After the upgrade to 9.2, that table no longer exists. It appears that information on checked out documents is now available in PLOCK, but I cannot identify where open document information is stored.

0 0

Replies

replied on February 5, 2015

For performance reasons that table is now only used to store information about documents that are checked out (i.e., persistent locks, or "plocks"). Most entry locks (those which are not "plocks") are now stored in memory only. Using the Laserfiche SDK libraries you can query the same information from LFS. If you are using LFSO, the ILFDatabase.GetLockListing method will return information about entry locks, and if you're using RepositoryAccess your code can call the EntryLockListing.GetListing static method to retrieve an EntryLockListing instance to enumerate the entry locks.

1 0

replied on February 5, 2015

I presume that also means if the LF server service is restarted while someone has a document open, LF will lose that entry lock information when it comes back up leaving the user in limbo. Can you confirm this?

1 0

replied on February 5, 2015

Only persistent locks are stored outside of the active server session.

2 0

You are not allowed to follow up in this post.

Question

Question

LF 9.2 database table for Locked Open docs?

Replies

Sign in to reply to this post.