Transform Map- Data is not inserted or updated in the Target table

Romi Kumari · ‎04-07-2020

Hello I am working on Data Source and while doing Transform Map I am using destination table as one of the User Created Table. I have mapped source and target table fields properly with same variable Type, even data is getting imported properly. But while running the transform map no record is getting inserted or updated. Do have any idea on this?

Romi Kumari · ‎04-07-2020

Hello Everyone

Issue is resolved now.

When ever data was loaded in the import set table, in the import set row table state column was empty. Normally if we re process it state changes to pending.

So I wrote a business rule , whenever import set table state is loaded set the import set row table state to pending. Now its working fine.

Thanks

When to run : after update

Table : sys_import_set

Condtion : current.state == "loaded"

// search all my import set rows and updated them to pending state

reset_import_set_row();

function reset_import_set_row() {
var mu = new GlideMultipleUpdate("sys_import_set_row");
mu.addQuery("sys_import_set", current.sys_id);
mu.setValue("sys_import_state", "pending");
mu.execute();

gs.addInfoMessage(gs.getMessage("import set rows updated to 'Pending' state"));
}

View solution in original post

Ankur Bawiskar · ‎04-07-2020

Hi,

Few things you can check

1) check the import set table table whether data is present in this table or not

2) check the import set record; how many inserts, ignored, updated

3) please share screenshot

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Romi Kumari · ‎04-07-2020

1. Yes I have checked records are getting updated in the Import set table.

2. 10 inserted, 0 updated, 0 ignored.

3. I have attached screenshot

Romi Kumari · ‎04-07-2020

I have attached the details

Ankur Bawiskar · ‎04-07-2020

Hi,

you need to run the transform map; the screenshot says the 10 records inserted into import set table

once you click the Run transform and select the transform map it would load into target table

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader