More than one target records exists for target table sys_user with query LDAP import warning message

[sathishakumara]

We have done LDAP integration in ServiceNow with below condiotions

1. Active directory attribure - "objectguid" as coalesce field 

2. Importing data scehduled configured for every 6 hours 

3. Connection is good but when we check the import set after we are getting warning as "More than one target records exists for target table sys_user with query" by mentioning objectguid field .

How to resolve this issue.

I have attached the transform map field mapping 

[Tanushree Maiti]

HI @sathishakumara 

Check  this KB KB0788959 Error during insert of sys_user 

Note: ObjectGUID is a globally unique identifier in Active Directory, similar to the sys_id in ServiceNow. It’s recommended to use ObjectGUID for coalescing and to avoid importing users without it.

[Tanushree Maiti]

Also refer this KB : KB0961314 How to configure LDAP integration for ServiceNow