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

[Harsh_Deep]

Hello @Astik Thombare ,

What script you are using for the import set.
Please share then I will help you out.

[Astik Thombare]

Hi @Harsh_Deep ,

Is there any way to achieve the same without writing any script, and are there any logs available to understand why they are stuck in a loaded state?

Thanks ,

Astik 

[Harsh_Deep]

Hello @Astik Thombare 

For this if you don't want to use script then you should have to do it manually by clicking on transform link.

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

[Danish Bhairag2]

Hi @Astik Thombare ,

Without script unfortunately u need to do it manually as in once data is loaded in your import set table u need to hit on transform to load the data into the target table.

Thanks,

Danish