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:
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.LdapSearchExceptionexcp_cause_has_error_info_0=0 java.util.concurrent.ExecutionException: com.tableausoftware.domain.ldap.LdapSearchException: failed to connect to any ldap server (errorCode=101009)