1. You have to get the object ID of the object that is having a problem. To do this, click on the object, in the File System ABOVE the object having the problem. On the right hand of the display, copy the "File System ID" which is a UUID. Also note the BEGINNING characters of the child item you are having problems with (in this example). The execute the following SQL statement on the SITE database:

SELECT * FROM objectStore WHERE objParent='[theUuidFromAbove]' AND objTitle LIKE '[firstchars]%'

The above should give you a single record (normally) which is the object having the problem. You should see that objCoFlag=1, objCoSetID=something, and objCoUsername = the user that has the object partially checked out (you'll confirm this in the next step).

2. Copy the OBJID from the query results above and user the the following TWO queries:

SELECT * FROM objectStore WHERE objid='[UUID]'
SELECT * FROM objectTemp WHERE objid='[UUID]'

You should have a record for the first query but NOT for the second one, if this is, in fact, the problem we noted in this instance.

3. Lastly, to clear the problem, execute the following query, using the UUID from the above step, to clear the partial checkout situation:

UPDATE objectStore SET objcoflag=0, objcosetid=null, objcousername=null
WHERE objid='[UUID]'