User Id on sys_user table is not updating, why?

[praaaaaaaa]

I am trying to load user records from AD.

It is creating user records in servicenow but User ID field on sys_user table is not updating as there is a record with same User ID value and giving Unique key violation. I understood that the field is Unique field.

So I modified User Id value of Old record and tried to update the newly added user record but it is still not updating the newly added record with User ID value even there is no other record with the same value.

Please help me here. also attaching images for referrence.

[Shishir Srivast]

for that I think you can have the validation on onBefore() transform script with ignore object. When it set to true, the current row transformation will be skipped and the remaining rows will be processed.

[praaaaaaaa]

I will try and let you know.