Transform map issue

[E_19]

Hi All,

I have created a transform map to load users into sys_user table. The handoff file has 8000 users when I run the transform it only loads 2100 users for the remaining 5900 records I get:

Error during insert of sys_user (Brad Pitt)   for each user record with unique user name.

I checked staging table field size and load data but see nothing unacceptable.

I have deselected the business rule flag to see if that makes a difference but no.

Anyone have any idea what might be causing this?   I realise this is very vague but maybe there are some thought someone could share.

Many thanks,

Ellie

[E_19]

Hi Alikutty,

There are no data policies on sys_user table and the user_name (user_id) is the only unique field in the table.

I have just done a test load into my personal dev instance same transform map configuration etc and had no problem at all loading all 8000 records.

Any other idea on this?

Thanks,

Ellie

[Alikutty A]

When you tested it last time, did you unchecked the run business rules flag on transform map?

The error message is displayed when you insert a record on a unique key and while trying to duplicate it. Can you try to insert the record which you detected directly on the table and see if it is related to that entry or not?

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

[E_19]

Hi Alikutty,

Yes business rule flag was unchecked.

I added a user manually that had the sys id error with no problem. User id did not exist.

I am really stumped with this.

Thanks,

Ellie

[Alikutty A · Accepted solution]

Can you remove all the data and reload in once again with user id as the coalesce?

If you want to delete users, you can run this script as a background script. The script deletes all users created today in less time.

var usr = new GlideRecord('sys_user');

user.addEncodedQuery('sys_created_onONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)');

user.deleteMultiple();

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

[E_19]

Hi Alikutty,

I have found the problem. It was my bad. I already have a staging table for user load into a u_customer table and the customer does not want to extend sys user table but now wants the same customer records to be added to the sys_user table in addition to u_customer table I thought I could use the same import set table but that was it seems the problem. I create a new import set table solely for sys_user import and its working fine now. I learned something at least.

Thank you for all your effort on this you have been a great help!

Thanks,

Ellie