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

Hello

There is no mandatory field in Destination Table

Kunal Varkhede · ‎04-07-2020

Hi,

You are using event Transformation script on this. If yes then check your script properly.

Thanks and Regards.

Kunal.

Romi Kumari · ‎04-07-2020

I am not using any script

Santosh Kallima · ‎04-07-2020

Shared error which is there in the import logs.

Romi Kumari · ‎04-07-2020

No error