Import Set stuck in 'Loaded' state

[Astik Thombare]

I know there are a lot of articles out there about being stuck in the 'Loading' state, but my Import Sets are 'Loaded'.  If i open the Import Set there is a related link for 'Transform'.  When I click that, the data comes in with no error.

What is causing this hang-up and how do I get Import Sets to automatically Transform and finish the import?

Is there any way to transform them without using any scripts ?

[Danish Bhairag2 · Accepted solution]

Hi @Astik Thombare ,

May I know how how u where trying to load the data , any snip of the issue.

For automation u can refer below links:

https://www.servicenow.com/community/itsm-forum/how-to-automate-loading-of-data-into-import-set-and-...

https://www.servicenow.com/community/developer-blog/data-load-and-transform-via-catalog-item/ba-p/22...

Thanks,

Danish

[Astik Thombare]

Hi @Danish Bhairag2 ,

Can you provide reason why it got stuck in loaded state and via a script how we can transform them automatically ?

Thanks,

Astik

[Danish Bhairag2 · Accepted solution]

Hi @Astik Thombare ,

May I know how how u where trying to load the data , any snip of the issue.

For automation u can refer below links:

https://www.servicenow.com/community/itsm-forum/how-to-automate-loading-of-data-into-import-set-and-...

https://www.servicenow.com/community/developer-blog/data-load-and-transform-via-catalog-item/ba-p/22...

Thanks,

Danish

[Astik Thombare]

Hi @Danish Bhairag2 

I have about 50 import sets that have been in a 'loaded' state for the past 5 hours. I can't share a screenshot, but I would like to know if there's a method or any logs available to check why these import sets are stuck.

Thanks,
Astik

[Suyog Aptikar · Accepted solution]

Hi @Astik Thombare  just a check, how many records are being loaded per load and if this is replicable in lower environments(non-prod)?, if so can you try deleting loaded import set data and try again?

[sieusaopolo15]

Hi @Astik Thombare , I am having the same problem as yours have you had any solution for this or understand why this is happening