Problems with Locked Item

[Chris Kelleher]

I am having a problem where our estimators are trying to
do a "Roll Current to Standard Cost" and getting an error
that says "Item in use by another user. I tried running
this query:

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
find first symix.item where item.item = "14981-44"
no-lock no-error.
if avail item then display recid(item).
[/code]

I get a recid back, but when I check with promon, there
is no user with a lock on that recid. Is there anything short
of running Crash Recovery that i can do to unlock this item ?

Thanks....Gary

Gary Jackson
MIS Administrator
Standard Iron & Wire Works
Monticello, MN 55362

 

[Chris Kelleher]

This is a BIG! Bug in SyteLine.
If you find the user that last had the record have them log out of
SyteLine it will release the record.
We do this about 20 times a day.
Symix has no idea why it happens or then it will be fixed.

 

[Chris Kelleher]

We are on Symix 4.1 and have had the same problem for a long time and have found that some times it is not the item record that is locked but the notes records for the item that is causing the lock. If someone is updating the notes for an item it causes the "Item in use by another user" error even though they do not actually have the item record itself locked up.
I assume that this may still be the case in Syteline. Just another place to look when trying to resolve the conflict.

TTFN
Gary Williamson
Systems Administrator
Milltronics Ltd.
garyw@milltronics.com

 

[Chris Kelleher]

What version are you talking about?

Syteline 4.00.02 has given us some locking issues. I did get from SYMIX a
set of programs that help me locate the locking user (promonjr.zip). It is
proving to be a big help. (We have nearly a 100 users). To free the locks
you need to find the user and have them completely log out. Symix has sent
us some patches, and claims the issue is resolved in 4.00.10. We don't want
to hear about another upgrade right now.

The programs to monitor users and record locks will help, you should ask for
it. I received the programs as the result of a case I logged in the first
half of July. The file sent to me was promonjr.zip, and their description
of the programs follows: "> The following programs allow you to monitor
users and records locks in a > SyteLine database. It will also help
determine what is causing persistent > record locks within SyteLine 3.5 or
4.0."

Hope that helps. I'd be interested in anyone elses experiences with
resolving these record locking issues.

 

[Chris Kelleher]

What version are you talking about?

Syteline 4.00.02 has given us some locking issues. I did get from SYMIX a
set of programs that help me locate the locking user (promonjr.zip). It is
proving to be a big help. (We have nearly a 100 users). To free the locks
you need to find the user and have them completely log out. Symix has sent
us some patches, and claims the issue is resolved in 4.00.10. We don't want
to hear about another upgrade right now.

The programs to monitor users and record locks will help, you should ask for
it. I received the programs as the result of a case I logged in the first
half of July. The file sent to me was promonjr.zip, and their description
of the programs follows: "> The following programs allow you to monitor
users and records locks in a > SyteLine database. It will also help
determine what is causing persistent > record locks within SyteLine 3.5 or
4.0."

Hope that helps. I'd be interested in anyone elses experiences with
resolving these record locking issues.