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

Romi Kumari · ‎04-07-2020

I have run transform. You can check in attached document

Ankur Bawiskar · ‎04-07-2020

Hi,

check the transform map, field map. those are the places to debug

Regards
Ankur

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

Romi Kumari · ‎04-07-2020

Ok Ankur, are there different types of field sets for import set table and the custom table?

Ankur Bawiskar · ‎04-07-2020

Hi,

Can you share screenshot of the transform map and field maps

Regards
Ankur

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

Himanshu Rawat4 · ‎04-07-2020

Hi,

Is there any mandatory field in the user created table that is missing in the transform map?

Need more details about the transform map to know more about the issue.

Thanks.