Please help on the following error, "Error during insert of sys_user"

[Rama Chandra D]

Hello,

I have just performed data import into an existing sys_user table using transform map. The transform is complete with errors. I have checked to log and here is what I have found,

"Error during insert of sys_user"

There is no error code mentioned in the log. Can someone help me understand why there has been an error during insert?

Regards,

Darshak

[jose_valle]

Hi Darshak,

It sounds like you might have a Unique index on your Employee number field. The coalesce for your transform should include any fields that have a unique index enforced to avoid having troubles like this.

Hope this helps

[levin]

Were you checking the import log to find out the error?

Are you able to browse the localhost log "System Logs" -> "Node Log File Browser" to see if you can locate more information? Assuming you have only one node.

If you have multiple nodes, only the node which ran the import has corresponding logs.

[TejasriK]

Hi @Rama Chandra D  

We will get this error when we didn't check coalesce for sys_id field map if it is a script and returning '-1' as well.

Please check the field maps and make coalesce true if necessary.

Regards,

Tejasri