Cancel a running import set transform map

[G Balaji]

Hi,

We've a JDBC connection from where we've imported 44K records and transform map is currently in "Running" state. Is there anyways we could cancel this transform. We've to update transform script and execute transform again after reprocess.

I understand that there used to a related link named "Cancel Job" in Progress worker module in Geneva but I couldn't find it in Madrid. Could I go ahead and change the state from :"Running" to "Cancelled"? Will that be a clean execution in terms of best practice or is there any other ways of doing it?

Thanks.

[Ankur Bawiskar]

Hi Balaji,

may be you can try to check active transactions in the system and try to kill that. But not sure whether that would be a clean execution because few records must have been already processed.

Why not wait for entire import to complete and then update transform script and run again?

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

[Priya Shekar]

Hi Balaji,

One way is to kill the transactions to stop the import.

Go to "All active transactions", open it and you will find the record which has age more and sql statements.

Right click and select kill.

If my reply has helped you,Kindly click the Helpful button.
If my reply is the answer you were looking for, Kindly click the Accepted Solution button.

Thanks,
Priya

[Sanjay Bagri1]

Hi , 

 Cancel an import in progress this functionality removed from the Instanbul version. 

Try it May be it will help you.

I thought deleting the transform history would have stopped transformation. May be if you can recover the deleted record of transform history by going to "Deleted Records" and then recovering and cancelling it.

Please mark as correct and also helpful if it is helping to you.

Best Regards,
Sanjay Bagri

[Constantine Kr1]

You can try: 

Transform History --> Select running transform -->  "Cancel Transform"

Found this on another thread. Source Link: https://community.servicenow.com/community?id=community_question&sys_id=9a924b21dbd8dbc01dcaf3231f96...