nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Query to delete duplicate users from DB end

m_praki

Hi

Can anyone please tell the query to delete the duplicate users from the database side. I cannot do it from the application. I have already tried the script (remove-duplicate-users.sh) but that got failed. So we planned to delete the dup users from back end.

FYI : We are using Alfresco 3.2.

Thanks
Prakash

Find more posts tagged with

Comments

romschn

Are you getting any error when you try to remove the user through alfresco web client?

However, below is the way through which you can delete the duplicates that can no longer be removed using the UI.

1. Create a javascript in Data Dictionary -> Javascripts with the following.

people.deletePerson("UserNameToDelete");

2. Browse to Company Home > More Actions > View Details.

3. On the details screen, select Run Action > Execute Script, and then select the script that you have created.

Check if this is working for you.

Hope this helps.

Thanks,

m_praki

Hi Romschn,

We didn't get any errors while deleting the user from UI. But the user cannot be deleted from UI.

And for the said three steps, I am afraid of doing that in production environment. Because we don't want to lose any user.

Sorry, for the late reply.

Thanks,
Prakash

m_praki

Hi,

Waiting for your's reply. Is that possible to do. without loosing any user. Or any someother way to do?. :?:

Thanks,
Prakash.

romschn

As per my understanding, Directly performing the operations into alfresco database must be avoided.

I am not aware of any other ways to delete duplicate users apart from the one I mentioned earlier of using javascript.

I am not sure about how we can achieve this using database query as I am not aware about the database design/dependency of tables part.

However, just for a trial - you may want to run below 2 queries and see if it is returning you the records you expect or not. Queries might not be absolutely correct.

select count(*), node_id from alf_node_properties where (node_id in (select id from alf_node where type_qname_id='5') and qname_id=11) group by node_id having count(*) >1 

select count(*), id from alf_node  where id in (select node_id from alf_node_properties where qname_id=11) group by id having count(*) >1
‍‍‍‍

m_praki

Hi Romschn

The script you have suggested works well in Alfresco 3.4 windows environment but not working in Alfresco 3.2 Linux environment. Please help me on this. The query you have given didn't fetch any record from my DB. But thanks for the query.

Regards
Prakash