KNOWLEDGE BASE

Group synchronisation fails with error "failed to connect to any ldap server (errorCode=101009)"


Published: 03 Feb 2023
Last Modified Date: 03 Feb 2023

Issue

Some tasks in group synchronization fail with error:

"failed to connect to any ldap server (errorCode=101009)"

Environment

  • Tableau Server 2021.2.19
  • Oracle Linux 7

Resolution

Work with your network and authentication team to verify all ldap servers for the domains specified in wgserver.domain.ldap.domain_custom_ports are valid and reachable.
 

Cause

Tableau is unable to connect to all ldap servers for the domains specified in wgserver.domain.ldap.domain_custom_ports

Additional Information

  • To view domains, run below command:
tsm configuration get –k wgserver.domain.ldap.domain_custom_ports
  • If the result of above command returns below, verify Tableau Server is able to reach all ldap servers in the below domains:  
ldaptest1.domaintest.com:636, ldaptest2.domaintest.com:636, ldaptest3.domaintest.com:636
  • Example of error in the backgrounder can be similar to below:
    2023-01-30 21:56:08.397 -0600 (People Analytics,,,,5827525,:sync_ad_group,c7ab4aae-549f-4581-ab09-2cab68d78982) pool-11-thread-1 backgrounder: WARN  com.tableausoftware.ldap.ADLdapConnectionManager - Failed to connect to any LDAP server in domain: ldaptest3.domiantest.com
    
    2023-01-30 21:56:08.397 -0600 (People Analytics,,,,5827525,:sync_ad_group,c7ab4aae-549f-4581-ab09-2cab68d78982) pool-11-thread-1 backgrounder: INFO  com.tableausoftware.ldap.ADLdapConnectionManager - Refreshing LDAP server list and retrying connections
    
    2023-01-30 21:56:08.397 -0600 (People Analytics,,,,5827525,:sync_ad_group,c7ab4aae-549f-4581-ab09-2cab68d78982) pool-11-thread-1 backgrounder: INFO  com.tableausoftware.ldap.ADLdapConnectionManager - Querying DNS server to refresh LDAP server list for domain: 
ldaptest3.domiantest.com
    
    2023-01-30 21:56:08.399 -0600 (People Analytics,,,,5827525,:sync_ad_group,c7ab4aae-549f-4581-ab09-2cab68d78982) pool-11-thread-1 backgrounder: INFO  com.tableausoftware.ldap.ADLdapConnectionManager - LDAP server hostnames have been updated

    2023-01-30 21:56:08.399 -0600 (People Analytics,,,,5827525,:sync_ad_group,c7ab4aae-549f-4581-ab09-2cab68d78982) pool-11-thread-1 backgrounder: INFO  com.tableausoftware.ldap.TabLdapConnector - Attempting to bind
    .... 

    2023-01-30 21:56:12.728 -0600 (People Analytics,,,,5827525,:sync_ad_group,c7ab4aae-549f-4581-ab09-2cab68d78982) scheduled-background-job-runner-1 backgrounder: ERROR com.tableausoftware.backgrounder.runner.BackgroundJobRunner - activity=backgrounder-job-error job_id=5827525 job_type=SyncActiveDirectoryGroup request_id=c7ab4aae-549f-4581-ab09-2cab68d78982 args="[Tableau_Global_TEST, THISDOMAIN.DOMIANTEST.COM, VIEWER, on-login]" site="People Analytics_Test" site_id=3 excp_msg="com.tableausoftware.domain.ldap.LdapSearchException: failed to connect to any ldap server (errorCode=101009)" excp_type=java.util.concurrent.ExecutionException excp_has_error_info=0 excp_cause_msg_0="failed to connect to any ldap server (errorCode=101009)" excp_cause_type_0=com.tableausoftware.domain.ldap.LdapSearchException excp_cause_has_error_info_0=0
    java.util.concurrent.ExecutionException: com.tableausoftware.domain.ldap.LdapSearchException: failed to connect to any ldap server (errorCode=101009)


Configuration reference table
Did this article resolve the issue?