Import set shows rows got ignored but it got transformed into the target table - Support and Troubleshooting

Import set shows rows got ignored but it got transformed into the target table Issue Import set rows show ignored but if you check the target table, data in the fields are present i.e, got successfully transformed. Ignore message will appear like this:

Release All Release

Cause This is caused by OnBefore Script which has ignore=true set.

Resolution When set to true, skips, or aborts the current import action. In onStart scripts, this variable aborts the entire transformation process. In onBefore scripts, this variable only skips the current row being transformed.

Example:

if(source.u_user_name.nil()){ ignore = true; }

So, Ignore is used to ignore the transforming row when used at onBefore script type the customer has used a scripted way of creating target records in onBefore script that's why the records are pushed to the target table but got ignored in the row.

You can remove this script to avoid ignore the message.

Related Links https://docs.servicenow.com/csh?topicname=r_TransformationScriptVariables.html&version=latest