Material in use by another user

Chris Kelleher

Administrator
Staff member
Progress 8.3a
SL 4.0.2
WinNT SP5

Howdy all -
Interesting. When we try to generate a job pick list, we get the following
non-standard SL error:

"Material in use by another user."

At this point you can't get around the error dialog-box. You have to end
the task.
Now, I can access the co record and it's corresponding coitem.item fields,
as well as these items in the item master (item.item).
What "material" is in use, and how do I unlock it?
TIA-

~~~~~~~~~~~~~~~~~~~~
Michael Fisher
IT Developer
Wallingford Electronics
~~~~~~~~~~~~~~~~~~~~
 
Message text written by Michael Fisher
>"Material in use by another user."
<

I think "another user" is a process running in a background queue,
otherwise it would gave you a specific Symix logon name.

Ed Hon
ABB Power T&D Co Inc.
 
If you have access to the Symix web page, this is an noted bug that deal
with record locking and scope. There at least two areas that "lock" the
record until the user logs out. One is customer service, the other is
blanket purchase orders.

To verify who is "using" the item, you can run a quick Progress program:

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
for each database.item exclusive:
pause 0 before-hide.
display item.item.
[/code]

Then ask the offending people to log out and back in or just "disconnect"
them.

Then wait for the next version of Symix to fix this problem.
 
Back
Top