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,

Can you clarify how your transform script referred to the old table? Was it not using "source"?

Thanks,

[Rama Chandra D]

Even though I updated the source table to new import table, the mapped fields still refere to the old table. When I click on the mapped fields, I see the source table as the old one itself.

[jose_valle]

Hi Darshak,

Yes, you will want to update those as well.

I took a closer look and it looks like you will need to update the individual transform entries as well to point to the correct source table and field name since they will still be using the original source table name

Re: How use an existing transform map for a new import table?

[Rama Chandra D]

Sounds like a lot of work. Is there any workaround without needing to create a new transform map?

[Mittal_M]

Hi Jose,

even i am facing the same issue for some of the users, as you mentioned i have checked the user's "samaccountname" i.e. user_name in sys-user table, the user is already existing which was created on 2016-06-28 . So ideally the record should be updated on 2016-08-29 but it didn't update the user.

Coalesce is on "u_objectguid --> u_ldap_uniqid" and "[Script] --> Company".

For other user records its working fine but I am not sure what could be the reason for this error.

Thanks,

Mittal Modh.