ldap user import: Error during insert of sys_user
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2017 08:18 AM
Similar to stale unanswered question here, I have errors related to to the LDAP Import. I am looking for the code that generates this error so I can add additional logging to determine the cause, or another debugging technique.
For this user there is a mismatch on our coalesce field Employee ID. I am confused as to why this errors as opposed to doing an insert rather than update on the coalesce field.
- Labels:
-
Integrations
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2017 10:07 AM
The example you provided was domain issue. You also have domain sep but import isn't happening? is there an existing inactive account that it's trying to update? Did you check transform map scripts for something that's preventing insert? Does the ldap_import show the record being inserted, but doesn't complete?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2020 12:17 PM
Hi Michael,
I am facing the same issue you have mentioned in your cooment.
ldap_import shows "Complete with errors";
Error: Error during update of sys_user(User Name)
Error:Error during insert of sys_user(User Name)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2020 02:38 PM
Is there a record already with the same coalesce value?
Is there a transform map script blocking the insert/update?
Does the record exist but the source and objectguid are different that the record in SN?
It's a time consuming task to troubleshoot them one by one.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2020 09:43 PM
Hi Michael,
Coalesce value: Employee number , onbefore tranform script is running to add the user to the group if it matches with the existing user record.
And one more thing the "Run business rule " checkbox is true.