Transform Map ignoring updates?

[JP-ODU]

I'm trying to do a very simple import to a table: I have an Excel with IDs and addresses, I load the data, I create a transform map that maps ID:ID and Address:Address, I set coalesce on ID to true. I run the transform map... and over 8,000 records are ignored.

I exported the table with the blank addresses and created a new Excel file to import, making sure that ID and address are all filled in. I do the import and transform again, and the updates are still ignored... I should have a flawless 1:1 relationship for these. They should all be updates, no ignores.

I don't understand why this is happening. How do I trouble shoot a transform map ignoring a large number of updates that it should be making?

[Pradeep Sharma]

Hi Jp,

Did you check import logs? The import log displays information in a verbose format about any data import activity within the platform. https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/managing-data/con...

- Pradeep Sharma

[JP-ODU]

Checking the import logs, I see there's one warning: "Security restricted: Refusing to process UI page script without a valid CSRF token" but I'm not sure what that means or how to proceed? Searching... "we give that message when a user tries to resubmit the same request too many times"--but I only tried the import once on Friday, and again, just now?

[LouisG]

Hey JP, 

I'm currently running into the same issue, and my circumstances are similar. Did you ever figure out what the issue was? 

[JP-ODU]

Hi Louis, 

In my case, it turned out to be a matter of an earlier import set months ago creating ~8,000 duplicate space IDs, so my transform map updated one set of IDs the first time, but left blanks. Then, on subsequent attempts, it saw the map as "already being completed" and thus ignored the updates, still leaving the duplicates blank. I recommend doing a group by ID on your target table to see if you have duplicates that might be causing a similar problem