Transform map showing updated records as ignored

JJG_SNOW
Mega Guru

I have a transform map that is updating many records, but when I check the transform history it shows the records as ignored. I am %100 certain that records are indeed being updated, I have confirmed it several times. 

 

What could cause the records to be showed as ignored when they have been updated?

 

JohnGilmore_1-1707769180748.png

 

 

The target table is the cmdb_ci_computer table.

 

JohnGilmore_2-1707769402702.png

 

 

There are several onAfter transform scripts, but they are very simple and all follow the same general format.

Example:

if (source.u_asset_tag.toLowerCase().indexOf("undefined") < 0) {
        target.asset_tag = source.u_asset_tag;
        target.update();
    }

 

 

1 ACCEPTED SOLUTION

Tony Chatfield1
Kilo Patron

Hi, you see ignored records as there are no field differences between the source and target data and so the import rows are 'ignored'. However, transform scripts are making changes and so you see the target record as updated.

 

One thing to note; based on the code you have posted I think the transform script would be better suited as a 'before' transform script. As in the current configuration if any field on the record is changed during the import process (the record is updated) this transform script will result in a second save\update of the record when it runs, and this 'double tap' is normally considered inefficient and undesirable.

View solution in original post

6 REPLIES 6

aio
Tera Contributor

Make sure if any Businness Rule ignore the record update.