Home → How Do I... →

Delete a user with locked asset

• Edit

a-vennerstrom

20 May, 2015 01:45 PM

I'm trying to delete a user but when I go to their 'locked asset's tab in the user administration area it says there is one locked asset with a strike through it (I believe this means it has been deleted). There is no clickable link for the asset so I can't navigate to the asset to break the lock.

When I login as the user and looked at the 'locked assets' widget or tab on the dashboard, there's nothing there.

How do I delete this user?

Thanks!

1. 1 Posted by Ryan Griffith on 20 May, 2015 04:42 PM

   

   Hi,

   I think the easiest thing to do is going to be to manually remove the lock from the database.

   Before we go ahead and remove the lock, I want to verify that the lock is ok to delete. When you have a moment, can you (or your DBA) try running this query against the database and attach the results:

   select l.id, fc.id, fc.cachepath, fc.iscurrentversion, fc.isworkingcopy, fc.isrecycled, fc.draftoriginalid, fc.draftuserid from cxml_entitylock l left join cxml_foldercontent fc on l.contentid=fc.id where l.who='USERNAME';
   

   Note: replace USERNAME with the username of the User you are unable to delete.

   Thanks!

   • Edit

2. 2 Posted by e-jameson on 21 May, 2015 12:53 PM

   

   Attached is the query results. Everything is null except for ID

   • export.csv 154 Bytes
   • Edit

3. 3 Posted by Ryan Griffith on 21 May, 2015 03:53 PM

   

   Thank you for providing the results of the query.

   It looks like the user's lock does not reference anything in the cxml_foldercontent table. So, let's go ahead and try deleting the lock from the database by running the following query:

   delete from cxml_entitylock where who='USERNAME';
   

   Note: replace USERNAME with the username of the User you are unable to delete.

   After running the query, confirm the one row was affected and attempt to delete your user within Cascade and let me know if the delete is successful.

   Please let me know if you have any questions.

   Thanks!

   • Edit

4. 4 Posted by e-jameson on 21 May, 2015 04:12 PM

   

   Worked great thanks!

   • Edit

5. a-vennerstrom closed this discussion on 21 May, 2015 04:13 PM.