<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="monospace">Here are my responses. Most of these things
happen and it depends on the kind of database and users on your
system so I can not say any are more likely than others.</font><br>
<br>
<div class="moz-cite-prefix">On 4/12/2021 8:45 PM, Jose Lerebours
via Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:0daa37be-fb71-17fa-a6e6-9a26c1408c1b@gmail.com">What do
you attribute your record locking issues most often to
<br>
<br>
A. Two or more users trying to update the same record
<br>
</blockquote>
This depends on the type of data and the construction of the
database. I would see this more often on databases where 2 users
had to access the same customer or item in the nature of the data
entry. Not so much when people are doing orders or adding inventory
or something where the jobs of the people are focused on one
category of work.<br>
<blockquote type="cite"
cite="mid:0daa37be-fb71-17fa-a6e6-9a26c1408c1b@gmail.com">B.
Running a report while a user is in update mode
<br>
</blockquote>
I would say this is the most common. But I would make 2
observations, I use -u when the report is not required to update
records as it passes. But I do not use -u when that is necessary,
so the report should wait for the user to finish what they are doing
before continuing.<br>
I wish filepro had a better way of handling this, than just
waiting. It can be very confusing for the users.<br>
<br>
<blockquote type="cite"
cite="mid:0daa37be-fb71-17fa-a6e6-9a26c1408c1b@gmail.com">C.
Rebuilding indexes while user is in update mode
<br>
</blockquote>
Scary bad, I try to rebuild things off work hours, if they need that
kind of attention.<br>
<br>
<blockquote type="cite"
cite="mid:0daa37be-fb71-17fa-a6e6-9a26c1408c1b@gmail.com">D. User
closed connection leaving a lock file behind
<br>
</blockquote>
Lock file is different than a record lock. This is somewhat common
and can be annoying, but it is also bad to just do an unlock without
checking to see if two functions will collide.<br>
<br>
<blockquote type="cite"
cite="mid:0daa37be-fb71-17fa-a6e6-9a26c1408c1b@gmail.com">E.
Lookup processing that locks but does not release record
<br>
</blockquote>
I see this often on Windows Server versions and the only way to
release this is to reboot windows. On a project where the data
entry is done from a dummy file, it is obvious when locks are stuck
that it came from lookups. I am of the opinion that filepro is too
fast for Windows Server systems. I will often have to put in sleep
commands to give Windows time to update data and remove record locks
before I continue. It is a shame but it saves quite a bit of
problems in the long run.<br>
<br>
I have seen invoice numbers that need to be generated sequentially,
and when 2 users are pulling numbers, it will get duplicates even
when the record is opened with a lock and written when updated to
release the locks. Somehow both users are able to get the same
number. My conclusion is that the lock was not seen by the second
user, who was able to access the record before the lock was
applied. Even though the lock command was sent before the data was
pulled. I had to invent a workaround for this to insure it never
happened, but it should have worked without that being necessary.<br>
<br>
<br>
<br>
<blockquote type="cite"
cite="mid:0daa37be-fb71-17fa-a6e6-9a26c1408c1b@gmail.com">
<br>
To me, (B) was the most common record lock instances till I
decided to run reports ignoring this and just keep on moving.
<br>
<br>
I rarely ever heard of two users trying to update the same record
- I do remember seeing situation where a user will use the arrow
up/down and
<br>
reach a record where a user was sitting in update mode and the
"waiting for record to be unlocked ..." came up; even without any
processing being triggered.
<br>
<br>
Do not hold me to "even without any processing being triggered"
part of the above statement but I am at least 80% sure of it.
<br>
<br>
What about you? What would be your most frequent reason?
<br>
<br>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: <a class="moz-txt-link-freetext" href="http://www.vss3.com">http://www.vss3.com</a>
</pre>
</body>
</html>