Trying to delete records using data management delete jobs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2024 11:25 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2024 11:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2024 08:03 PM
its a non prod instance actually.trying delete flows actually.still state of delete job showing as running state but records are not deleting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 07:18 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 06:06 PM
@ jhansi28 How did you cancel the running job ? I only see the option to delete.