LDAP automatic refresh

What version of Vertica is this? This will help us track version-specific setups.
Are the users not listed in V_CATALOG.USERS table? Or if they are, is the LDAP_DN field blank?
Could you check vertica.log for any detail error messages that were not listed in LDAP_LINK_EVENTS? (Older versions of Vertica may also list a separate log file for LDAP sync)

We use Vertica 9.2.x ..Yes the users and group are not listed in users and roles table .There is no records in them.
Pasting the details from vertica log at a particular time when the LDAP refresh was successful but the user/role was not reflected
2020-08-03 05:56:01.149 Init Session:0x7f53987f8700-a000000045ea2c [Session] [Query] TX:a000000045ea2c(v_medicaid_node0001-15719:0x513a1) SELECT LDAP_LINK_SYNC_START();
2020-08-03 05:56:01.157 Init Session:0x7f53987f8700-a000000045ea2c [Util] Task 'LDAPLinkService' enabled
2020-08-03 05:56:01.157 LDAPLinkService:0x7f538ffff700 [Basics] LDAPLink Service: this is clerk. Will run on this node - v_medicaid_node0001.
2020-08-03 05:56:01.158 LDAPLinkService:0x7f538ffff700 @v_medicaid_node0001: 00000/6304: LDAP initialized on server ldap://mapsdemodmc01.demo.mapshc.com
2020-08-03 05:56:01.169 LDAPLinkService:0x7f538ffff700-a000000045ea2e [Txn] Begin Txn: a000000045ea2e 'LDAP Link service'
2020-08-03 05:56:01.175 LDAPLinkService:0x7f538ffff700-a000000045ea2e [Basics] Equivalent ldapsearch command (non-TLS format, with paging): ldapsearch -LLL -x -H 'ldap://mapsdemodmc01.demo.mapshc.com' -D 'CN=Sathya,CN=users,dc=demo,dc=mapshc,dc=com' -w '*****' -b 'CN=users,DC=demo,DC=mapshc,DC=com' -s 'sub' '(&(objectClass=group)(cn=Vertica))' 'sAMAccountName' 'sAMAccountName' 'member'
2020-08-03 05:56:01.175 LDAPLinkService:0x7f538ffff700-a000000045ea2e [Basics] Equivalent ldapsearch command (non-TLS format, with paging): ldapsearch -LLL -x -H 'ldap://mapsdemodmc01.demo.mapshc.com' -D 'CN=Sathya,CN=users,dc=demo,dc=mapshc,dc=com' -w '*****' -b 'CN=users,DC=demo,DC=mapshc,DC=com' -s 'sub' '(&(objectClass=user)(cn=)(memberof=CN=Vertica,CN=users,dc=demo,dc=mapshc,dc=com))' 'sAMAccountName' 'sAMAccountName' 'member'
2020-08-03 05:56:01.178 LDAPLinkService:0x7f538ffff700-a000000045ea2e [Basics] LDAPLink ((&(objectClass=group)(cn=Vertica))): search returned 1 entries.
2020-08-03 05:56:01.181 LDAPLinkService:0x7f538ffff700-a000000045ea2e [Basics] LDAPLink ((&(objectClass=user)(cn=)(memberof=CN=Vertica,CN=users,dc=demo,dc=mapshc,dc=com))): search returned 2 entries.
2020-08-03 05:56:01.182 LDAPLinkService:0x7f538ffff700-a000000045ea2e [Basics] LDAPLink: processing users.
2020-08-03 05:56:01.182 LDAPLinkService:0x7f538ffff700-a000000045ea2e [Basics] LDAPLink: processing roles.
2020-08-03 05:56:01.213 LDAPLinkService:0x7f538ffff700-a000000045ea2e [Txn] Rollback Txn: a000000045ea2e 'LDAP Link service'
2020-08-03 05:56:01.220 LDAPLinkService:0x7f538ffff700 @v_medicaid_node0001: 00000/3298: Event Posted: Event Code:14 Event Id:16934656 Event Severity: Warning [4] PostedTimestamp: 2020-08-03 05:56:01.220029 ExpirationTimestamp: 2020-08-03 05:56:16.220029 EventCodeDescription: Timer Service Task Error ProblemDescription: threadShim: Circular assignation of roles is not allowed DatabaseName: medicaid Hostname: mapsdemodbv01-clone1

@Sathya It looks like you have circular groups in your LDAP Server which is what causing the issue. Can you check with your LDAP Admin as in why you have circular dependency? Please fix the circular dependency issue in your LDAP Server and try Ldap Sync again.

2020-08-03 05:56:01.220 LDAPLinkService:0x7f538ffff700 @v_medicaid_node0001: 00000/3298: Event Posted: Event Code:14 Event Id:16934656 Event Severity: Warning [4] PostedTimestamp: 2020-08-03 05:56:01.220029 ExpirationTimestamp: 2020-08-03 05:56:16.220029 EventCodeDescription: Timer Service Task Error ProblemDescription: threadShim: Circular assignation of roles is not allowed DatabaseName: medicaid Hostname: mapsdemodbv01-clone1

The final error "Circular assignation of roles is not allowed" suggests there is an existing role name "VerticaDBA" or including "VerticaDBA" in the existing grants, are there any roles defined in V_CATALOG.ROLES?

@SruthiA thanks a lot , I worked with LDAP admin and got the group recreated and it worked but still could not get what the error circular groups about?

@Sathya Good to know that it worked. It is a known issue which we will fixed in future versions of vertica. Please open a support case. we will be able to provide more details.