Please help in understanding the following error log: "Error during update of sys_user ()"

[Sajan3]

Hi all,

We are getting the following types of errors being logged in our instance regularly:

"Error during insert/update of sys_user" followed by the user name. This error log does not have any other information as to what is causing the issue. I checked the community and tried the following:

1. Disabled the "Run business rule" checkbox on transformation map and checked.

2. Checked on field coalesce

3. Tried running the Node Log file browser to get additional information on the error.

These errors are logged in a large number, on a daily basis due to a LDAP user import.

Please provide information as to where i should start looking to debug the errors.

Any help is greatly appreciated!!

[SanjivMeher]

You can check the import set error log. It will have the reason it is failing. I think mostly it would be because of the user name. Do you have a coalesce in your transform map on username field?

[Abhinay Erra]

user_name is a unique field on sys_uyser table. You are seeing this error due to insert of user record with same user name