Transform map always shows an update in the target table even if there is absolutely no change in data in the next uploads

[arnabwa]

Hi All,

We are observing that our DEV instance is always showing an update when a transform map is runs even if there are absolutely no changes in excel data. 

We have some external users that we are uploading via excel through a transform map to the user table. 

So, when we upload the excel for first time, import set logs show inserts which is fine. The second time when we upload the exactly same excel, always the import set logs shows all records were updated and even in the user table all those records show as updated. Same for any number of uploads of the same excel.

OOB all same records should be ignored and in target table those records should not show an update. Also interestingly, in our other sandbox instance, it shows expected behavior as per OOB. The issue shows up in DEV. 

In the User table, everytime it shows that records were updated: 

The Transform scripts that you see are active=false. We have also tried by unchecking 'Run business rules' but issue remains the same.

Where could we be looking more?

Many Thanks,

Arnab

[Kris K]

Hi Arnab,

I'm experiencing the same issue as well ..... wondering if you have found a solution/rootcasue for this issue. 

[arnabwa]

Hi Kris,

The root cause is current.update() being used in onBefore or onAfter Brules.
Or using the update() function in any of the transform scripts that you might have (before, oncomplete, start etc.). 

The update() function causes a force update and hence shows as updated the incoming form fields. 

Test it by commenting all kinds of current.update() in Brules and object.update() in transform scripts.

It will work.

Many Thanks,

Arnab

[David77]

Can you post a screenshot of the Transform map output? The one that shows Inserts, Updates, Ignored, Skipped, etc. ?