Transform Map Coalesce Fields not Applied post Zurich
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
We have a weekly transform map that has decided to break one day after updating to Zurich. We have the coalesce fields set to include "assigned_to" but when you check the activity stream of the records created they would jump from one user to another. (it also seems to have broken how we interpret which user, in the past it would give just it to "John Doe" it now creates a new "John.Doe" user record and assigns it to them)
We're receiving this warning on our import sets:
More than one target records exists for target table sn_grc_task with query cmdb_ci=61c1dcaf4759721085758e0b516d43cf^active=true^u_category=training
However, this query doesn't include "assigned_to" which is an enabled coalesce field
Additionally, validating the coalesce fields on the transform map fails even after changing the fields around
It seems as if since the Zurich update ServiceNow is simply ignoring "assigned_to" as a coalesce field
