Delete a user with locked asset

a-vennerstrom's Avatar

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

    Ryan Griffith's Avatar

    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!

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

    e-jameson's Avatar

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

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

    Ryan Griffith's Avatar

    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!

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

    e-jameson's Avatar

    Worked great thanks!

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac