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

[Pradeep Sharma]

Hi Darshak,

For testing purpose can you disable the "Run business rule" checkbox on transformation map and check once.

[Rama Chandra D]

Hey,

Can detail me what exactly disabling the BR does?

Regards,

Darshak

[jose_valle]

Hi Darshak,

I sometimes see this error when the coalesce does not find an existing user with the same user_name and decides to insert instead of update. This results in this error message.

To see if this is the case, you will want to check if the user_name from this import record already exists in in your sys_user table. If so, then you will want to review your coalesce to see if you can figure out why it did not find it.

Hope this helps!

[Rama Chandra D]

Jose,

I think I figured out why it must have come but still I would like to confirm it from you, as I'm new to SNOW.

I used existing transform maps which has few scripts running for certain fields. To run the transform on new import table, i just changed the source table to point to the new table. However, the source table in the scripts is still the old one. So I understand that SNOW was trying to do an insert and to pick up the data for the scripted field it still referred the old table where the new value didn't exist. So is that why an error is being returned?

Thanks

Darshak