1 Reply Latest reply on Mar 23, 2012 10:10 AM by Tim Latendress

    AD Group Import fails if User already on server?

    Tim Latendress

      Already sent this to Tableau Support yesterday but thought I would try the Forum. We are implementing multiple AD groups to manage access to Projects on TS V7.0 (upgrading to 7.0.1 tomorrow to see if that fixes the problem). In our configuration a user can be in more than one AD group. 

       

      The errors, below, lead me to believe the Import is failing because the user is already in the Users list.  Is this a bug or by design or am I missing something else altogether? 

       

      Our first stab at a small test Import fails:

      Found 3 active members of 'Tableau_MCBS_MAP_Publishers'

      ArJdbc::PostgreSQL::RecordNotUnique

       

       

      A look into the postgresql.log file reveals the following error:

       

      2012-03-22 10:42:15.255 EDT 5524 ERROR:  duplicate key value violates unique constraint "index_system_users_on_name_and_domain_unique"

      2012-03-22 10:42:15.255 EDT 5524 DETAIL:  Key (lower(name::text), domain_id)=(jane.doe, 2) already exists.

      2012-03-22 10:42:15.255 EDT 5524 STATEMENT:  INSERT INTO "system_users" ("name", "email", "hashed_password", "salt", "sys", "keychain", "domain_id", "friendly_name", "custom_display_name", "activation_code", "activated_at", "state", "admin_level", "created_at", "updated_at", "deleted_at") VALUES ('jane.doe',"jane.doe@ourdomainname",NULL, NULL, 'f', '', 2, NULL, 'f', NULL, NULL, 'active', 0, '2012-03-22 14:42:15.000000', '2012-03-22 14:42:15.000000', NULL) RETURNING "id"

      2012-03-22 10:42:16.239 EDT 5524 LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

       

      Thanks for any help you can give!

       

      Tim