Notifications

77 views

Description

When a data source has multiple transform maps, during an import when records are loaded and transform begins, the import set state is set to "Processed" as soon as the first transform completes but the second transform map is still running.

Steps to Reproduce

  1. Create a data source and load large data so the issue can be seen.
  2. Create two transform maps for that data source and specify different order for both.
  3. Load all records.
  4. Click Run transform, select both transform maps and click Transform.
  5. Duplicate tab and navigate to System Import Sets > Advanced > Import sets.
  6. Open the ISET record created.
  7. Observe the state of the import set and the state of transform maps below.
  8. Keep reloading the page to see the state change from Loaded to Processed and observe that second transform is still running.

Workaround

Update the script in the business rule "Update Import Set Complete" on sys_import_set_run table with the script provided below:

setImportSetProcessed();

function setImportSetProcessed() {
var isrgr = new GlideRecord("sys_import_set_run");
isrgr.addQuery("set", current.set);
isrgr.query();
while (isrgr.next()) {
if(isrgr.state != "complete" && isrgr.state != "complete_with_errors")
return;
}

var isgr = new GlideRecord("sys_import_set");
isgr.addQuery("sys_id", current.set);
isgr.query();
if (isgr.next()) {
if (isgr.mode != "synchronous") {
isgr.state = "processed";
isgr.update();
}
}
}

 

 


Related Problem: PRB1155279

Seen In

There is no data to report.

Intended Fix Version

Orlando

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-07-12 13:05:46
Published:2019-04-04