How to resolve Error Unique key violation detected by database(Duplicate entry for key Username) ?

VIKAS45 · ‎11-15-2023

We are receiving the below Error while Import using Transform Map on User Table.

"FAILED TRYING TO EXECUTE ON CONNECTION glide.24 (connpid=****): Update sys_user SET u_legal_first_name = ***

Unique key violation detected by database(Duplicate entry '*****' for key 'Username'.

Please let me know how to resolve the Error.

Bert_c1 · ‎11-15-2023

See:

https://docs.servicenow.com/bundle/vancouver-integrate-applications/page/administer/import-sets/conc...

Seems you are trying to create a new record with the same value for a field that is defined as a 'unique index'. You probably want to update the existing record and not create a new record.