Throw again transform on failed import

mathieu_brule
Kilo Sage

Hi everyone,

 

I need your feedback on an issue I'm facing on imports.

 

Last friday, I've launched 2 imports, which were really consequent (more than 400.000 records each). This morning, I can see that my two imports have failed during the weekend :

- import run time is stopped on saturday

- many records in Pending state in my import table

- transform history still in Running state

 

I also want to finish my imports, without launching again all the records (so only launch transform on records which have don't be processed).

For doing this, I want to click again on "Transform" related link : in my mind, it should take in account only the records which are in Pending state.

 

Note : I don't want to cancel the failed transform, I'm afraid that all ipending import set records be cancelled too...

 

Does anyone have any feedback to give me ?

1 ACCEPTED SOLUTION

Hi Ankur,

 

I've tried my solution, and as expected, it only took in account import set rows which were in Pending state. All other rows were not treated again.

 

Note that I didn't use "Reprocess" related link, given that I didn't want all my records to be processed again.

 

Regards,

Mathieu.

View solution in original post

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@mathieu_brule 

if you re-run the transform the rows from import set which were processed they will be processed again and if any change in data with target record it will override the target

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Ankur,

 

I've tried my solution, and as expected, it only took in account import set rows which were in Pending state. All other rows were not treated again.

 

Note that I didn't use "Reprocess" related link, given that I didn't want all my records to be processed again.

 

Regards,

Mathieu.