Import schedule is not transforming the data

shivani42
Tera Contributor

Hi All,

There is a import schedule for Jamf connection which is responsible to load the usage the data. The schedule is loaded the data properly but not transforming it automatically. The records stuck in pending state. Anybody has any idea about it.

I tried to manually transform it but some got processed and others still stuck at pending state.

 

Regards,

Shivani

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @shivani42 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1000374

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Ankur Bawiskar
Tera Patron
Tera Patron

@shivani42 

so it's scheduled import which is getting stuck?

what debugging did you perform?

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

Laveena_A
Tera Contributor

It might be due to other operations running on the same table. Go to "Active Transactions" and kill this Jamf scheduled job and also wait for the other jobs/transactions to get completed & run it again!