Item Locked causing orders to Lock.

[smtoomey3]

I have a problem with an individual item that is locked and seems to be causing orders with this item on them to be locked as well,,,,because of this we can not ship the orders,,,how do I unlock the item no one is in the item.

 

[smtoomey3]

Rebooted server, problem fixed.

 

[twillett40]

Are you running in a Pervasive enviroment or SQL?
In Pervasive locked records can be identified with an lck extension.

Rebooting is one way to solve the problem.

Terry

 

[abaldwin]

Also you need to check for ghost users in Macola and keep them cleaned up. In SQL you need to be watching the enterprise manager and can see when you have users in there that are locking records and do not correspond to a current Macola user.



Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[kstickler]

Andy,

Does SQL have some sort of inactivity timeout for these users? Whereby, it will clear them? Or is it a manual process?

Since moving to SQL, I struggle with being able to identify which users could be the culprit in a locked record problem, and I hate having to get them all to log out. Any suggestions?

 

[abaldwin]

Manual process.

You can write a script that will do it but the problem would be that their macola screens would still be active and when they tried to do anything they would get a COM/ADO error because they were no longer attached to the DB.

I will hunt up a script that will display the users that are utilizing recrords in macola. For now though the Enterprise manager / Management/ Active process will tell you a lot and will allow you to kill the user. "Kill" in this case is to disconnect the user, not the way most of us would like too.



Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[grossow]

Use this query to find locked records in Macola.

use msllockdb
go
select sessionid, tablename, rowid from maclocks

exec sp_who

greg