Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Unable to resolve target record, coalesce values not present: u_emp_id

Johny1
Tera Expert

‎01-04-2022 02:35 AM

Hello Everyone,
In transform map when the Coalesce value not present on target table record I could see error (Unable to resolve target record, coalesce values not present: u_emp_id) on the transform history import set row errors.
Could you please help me on how to stop this error message. 

find_real_file.png

Thanks,

Johny

Preview file
93 KB
0 Helpfuls
  • 3,875 Views
10 REPLIES 10

Anil Lande
Kilo Patron
In response to Johny1

‎01-04-2022 04:43 AM

Hi,

This is OOB behavior, if Coalesce field is empty the record is ignored with the error message, this helps to debug if any record is ignored because of empty Coalesce.

Also you can check below KB article for the same issue.

 https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0547762

 

Thanks,
Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande
0 Helpfuls