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

[Romi Kumari]

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]

issue persist for scheduled import set as well. After re-process data is getting inserted in the destination table.

[Romi Kumari · Accepted solution]

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"));
}

[Ankur Bawiskar]

Hi,

that is somewhat weird behavior; how are you triggering the data source?

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

[Romi Kumari]

Through Scheduled import set and Data source type is JDBC and it is Asynchronous mode