Trying to delete records using data management delete jobs

jhansi28
Tera Contributor

I am trying to delete records in using delete jobs but only few records deleted s", it works for about 40 minutes and , then stops deleting records I receive no errors or feedback. It just stops deleting records and it has to be restarted.Attached delete job screenshot state it is showing state as running but records are not deleting.please suggest here

 

  1. jhansi28_0-1713377756558.png

 

5 REPLIES 5

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

Also nothing in the System Logs?

 

Is this also a subproduction instance? Or a production instance? And you are deleting Flows? That will ofcourse cause deleting a lot more related records.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

jhansi28
Tera Contributor

its a non prod instance actually.trying delete flows actually.still state of delete job showing as running state but records are not deleting

 

jhansi28_0-1713409325491.png

 

hi @jhansi28 

 

Understanding the Problem
* Symptoms: The delete job on non-prod instance appears to be running (state: "Running"), but it stops deleting records after some time without generating any error messages.
* Possible Causes:
* Resource Constraints: The delete job might be hitting resource limits (e.g., memory, database connections) on your non-production instance.
* Table Locks: If other processes are locking the table you're trying to delete from, the delete job might stall.
* Script Issues: If the delete job is using a custom script, there might be errors in the script logic causing it to stop unexpectedly.
* Background Script Conflicts: Other background scripts running simultaneously might be interfering with the delete job.

 

If the above things not work either you can create a custom gs.log script or create a case with servicenow support 

If you like this opinion. Please kindly mark this your best answer OR Helpful and help me to contribute more to this community

MackI | ServiceNow Technical Consultant | DXC Technology Australia | ServiceNow Practice | LinkedIn Top IT Operation Voice 2023 | Sydney,Australia

Stef Kopczyk
Tera Contributor

@ jhansi28 How did you cancel the running job ? I only see the option to delete.