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

rajneeshbaranwa · ‎04-07-2020

Do you have any data policy/business rule stopping these records to be inserted. Can you show us Transformation Map logs

Romi Kumari · ‎04-07-2020

after doing transform map for the first time if I open import set record after clicking on reprocess data is getting inserted.

absd · ‎04-07-2020

Try to validate your import once by unchecking the field "Run business rule" and then import. if your import is successful then you can check that one of the BR on that table might be restricting the imports.

Romi Kumari · ‎04-07-2020

Hi

I think it is the issue of BR. Because after doing transform map for the first time if I open import set record after clicking on reprocess data is getting inserted.

Ankur Bawiskar · ‎04-07-2020

Hi,

Did you do sample test load? If yes then it would insert the records in import set table and you need to open the import set; re-process it and then again run the transform.

Then actually it would load data 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