Support Staff2 Posted by Tim on 06 Jun, 2012 08:18 PM
It's possible that this is a leftover legacy issue. I believe we
fixed some problems in more recent versions that will prevent this
from occurring again. In the meantime, you should be able to clear
the locks by executing the following SQL query:
delete from cxml_entitylock where who='[username]'
(where [username] is the user name in question)
Once those locks are no longer associated with the User, you
should be able to delete him/her.
Support Staff5 Posted by Tim on 07 Jun, 2012 06:38 PM
The '?' you mentioned that you noticed probably indicates that
the asset is which is locked is in the Recycle Bin (or has been
purged entirely). This could mean that the asset was locked by one
user, then recycled by another. We are aware of this scenario and
will be looking to prevent it in the future.
If the asset happens to have been completely removed from the
database, you could try running the Optimize Database tool with
only the Remove orphaned records option selected.
That should take care of it.
Having said that, you may have already resolved this using the
query I mentioned earlier.