jumebv

Bouke Groenescheij

My personal adventures in the quest for virtual perfectness.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Login
    Login Login form

VCOPS: Cannot import LDAP users

on
  • Font size: Larger Smaller
  • Hits: 13351
  • 0 Comment
  • Subscribe to this entry
  • Print

When trying to import users from LDAP I'm getting:

One or more users already exist and haven't been imported.

This issue isn't new and in fact there are multiple blog post can be found (like Zsoldier's Tech Blog) and there is a good KB (2017641). However, the KB notes a point 5:

delete from uistate where userid=10;
delete from useraccount_setting where userid=10;
delete from useraccount userid=10;

Besides the fact the last query is wrong (it needs a 'where'), I've found it much faster to just delete everything above userid 1 (userid 1 = admin account, which I wouldn't touch), granted: only if you havn't imported LDAP users already.

delete from uistate where userid > '1';
delete from useraccount_setting where userid > '1';
delete from alertcontrol where userid > '1';
delete from useraccount where description like 'VC%';

Saved me from deleting like 30 x 4 individual queries Cool.

 

 

Last modified on
Tagged in: VCOPS

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Thursday, 20 July 2017