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.

Problem with users

Hello,

I have a problem with Alfresco 1.4.

Before I was in 1.2.1 version.

I have updated to the 1.3.1 scheme and I'm using the 1.4 version.

Everything seems to work fine, but I have a bug with users.

I have three times the same user and I can't delete them.

I'm using NTLM (only one user "psi" in Active Directory).

How can I delete them ?

[img]http://img95.imageshack.us/img95/8453/alf01yj9.jpg[/img]

[img]http://img88.imageshack.us/img88/5262/alf02jk9.jpg[/img]

Thanks

Find more posts tagged with

Comments

Please

derek

Hi,

You didn't notice the 1.4 schema upgrade scripts running on first startup? I take it they worked, then 😉

Query:

select * from alf_node_properties where qname = '{http://www.alfresco.org/model/user/1.0}username' order by string_value;‍‍

If the user doesn't occur multiple times in the database, then the indexes can be rebuilt. Otherwise you can rename the users in the database and rebuild the indexes to reflect the changes.

To rebuilt indexes, move the Lucene index folder away and in repository.properties, change the following:

index.recovery.mode=FULL‍‍

At any rate, let us know what the query returned.

Regards

Hello,

The result :

mysql> select * from alf_node_properties where qname = '{http://www.alfresco.org/model/user/1.0}username' order by string_value;
+———+————-+————–+—————-+—————+————+————-+————–+————–+——————–+————–
————————————+
| node_id | actual_type | multi_valued | persisted_type | boolean_value | long_value | float_value | double_value | string_value | serializable_value | qname
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
+———+————-+————–+—————-+—————+————+————-+————–+————–+——————–+————–
————————————+
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7 | STRING&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 | STRING&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 | admin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | {http://www.a
lfresco.org/model/user/1.0}username |
+———+————-+————–+—————-+—————+————+————-+————–+————–+——————–+————–
————————————+
1 row in set (0.09 sec)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

With "index.recovery.mode=FULL" it was ok.

I have deleted the 3 users, but the problem is that with other users I had the same problem (2 admin for example).

And I can't connect or disconnect :

"org.alfresco.error.AlfrescoRuntimeException: Found more than one user for admin (case insensitive)"

After a restoration, I still have the problem of the 3 users.

Is it possible to delete them manually ?

Thanks

ajshaw

i have had this issue before (but duplicate persons not users). I found all the duplicate person objects for a particylar user using the nodebrowser

@cm\:userName:"joe smith"‍

and then ran all those uuids through a script to remove them

function doIt() {

str =  ""+document.id+"<—-gone";
document.remove();

return str;
}


doIt();
‍‍‍‍‍‍‍‍‍‍‍‍