Error during the Import using datasource

Nithya Devi
Tera Contributor

Dears friends,

 

When I do import on Contact files through the Data Source,throwing some errors.Could anyone help to fix this error to run smooth transform.

NithyaDevi_0-1749646951493.png

 

1 ACCEPTED SOLUTION

@Nithya Devi 

nope, it will reject.

As per your screenshot the Choice action is reject, that's what I informed earlier

That's the reason the entire row is rejected.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

@Nithya Devi 

the error clearly says record was rejected as company was not found

Did you check the field map for company target field?

Since company field on sys_user is Reference, the choice action must be set as "Reject"

When there is no matching company found then that row will be rejected

AnkurBawiskar_0-1749647784734.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

NithyaDevi_0-1749648104665.png

As per choice action,it has to ignore/skip the change.but it is throwing an error.

Source field-erpVendorId (Import set table)

Target field-Vendor(company)(Contact table)

reference field- u_erp_vendor_id (refering to Company table).

 

@Nithya Devi 

nope, it will reject.

As per your screenshot the Choice action is reject, that's what I informed earlier

That's the reason the entire row is rejected.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader