When does the onComplete Transform Script run

Meloper
Kilo Sage

Hi,

the log which is written in the onComplete Transform Script is before the Date completed Date in the Import Set?
Is this right?

So the "onComplete" Scripts runs before the import ist reall completed right?
Can we see when the this happens? So which time is really the Starting point of the "onComplete" scirpt or is this only possible with a log?

1 ACCEPTED SOLUTION

Sohithanjan G
Kilo Sage
Kilo Sage

Hi @Meloper 

 

the onComplete transform script runs after all the records in the import set table have been processed during an import set transformation. It runs after the import set table has been loaded with data but before the actual import of records into the target table.

So, to answer your questions:

  1. Is the log written in the onComplete Transform Script before the Date completed Date in the Import Set?

    Yes, typically the log generated by the onComplete transform script would be written before the completed date in the import set. This is because the completed date is updated when the import process completes, which includes the transformation and the import of records into the target table.

  2. Does the "onComplete" script run before the import is really completed?

    Yes, the onComplete script runs after all records have been transformed but before they are actually imported into the target table. It gives you the opportunity to perform additional processing or validation before the import is finalized.

 

Please mark as Accepted Solution if this solves your query and HIT Helpful if you find my answer helped you. This will help other community mates too..:)

View solution in original post

4 REPLIES 4

Sohithanjan G
Kilo Sage
Kilo Sage

Hi @Meloper 

 

the onComplete transform script runs after all the records in the import set table have been processed during an import set transformation. It runs after the import set table has been loaded with data but before the actual import of records into the target table.

So, to answer your questions:

  1. Is the log written in the onComplete Transform Script before the Date completed Date in the Import Set?

    Yes, typically the log generated by the onComplete transform script would be written before the completed date in the import set. This is because the completed date is updated when the import process completes, which includes the transformation and the import of records into the target table.

  2. Does the "onComplete" script run before the import is really completed?

    Yes, the onComplete script runs after all records have been transformed but before they are actually imported into the target table. It gives you the opportunity to perform additional processing or validation before the import is finalized.

 

Please mark as Accepted Solution if this solves your query and HIT Helpful if you find my answer helped you. This will help other community mates too..:)

I beg to differ on your #2

BalaMayak_0-1744007738257.png

 


I believe onComplete script will run AFTER all rows are imported into the target table.

From docs:

BalaMayak_1-1744007869821.png

 

Sohail Khilji
Kilo Patron
Kilo Patron

@Meloper 

 

An easy to understand chart :

SohailKhilji_0-1709716400615.png

 

More info  >https://john-james-andersen.com/blog/navigating-transform-scripts-in-servicenow.html


☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect

Hi thanks, but that's not my question, I'm aware of the order.
I wanted to know if there is a traceable time stamp, when the on complete script really starts and if I can see it without a log.