- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-24-2017 10:35 AM
I've done some searching on the community and elsewhere hoping to find someone else talking about this issue we're having, but I'm not finding anything. Fairly often we need to delete all the records from some tables. In the current situation, there are 115,000 records we need to delete. When go to Tables & Columns > choose the table > click "delete all records", it works for about 5 minutes, then stops. I receive no errors or feedback. It just stops deleting records and it has to be restarted.
The fact that it's taking right around 5 minutes every time makes me think it's a 5 minute timeout. But I don't see a system property for that. Maybe I just need some educating on this. What's going on here? Is there a quicker or better way to delete all the records from tables?
Solved! Go to Solution.
- Labels:
-
Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-24-2017 10:40 AM
Its likely Transaction Quotas that are "killing" the transaction. You can verify by searching the logs for message contains "maximum execution time exceeded" as mentioned in the Docs article.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-08-2017 04:09 PM
John,
We are glad you took advantage of the ServiceNow Community to learn more and to get your questions answered. The Customer Experience Team is working hard to ensure that the Community experience is most optimal for our customers.
If you feel that your question was answered, we would greatly appreciate if you could mark the appropriate thread as "Correct Answer". This allows other customers to learn from your thread and improves the ServiceNow Community experience.
If you are viewing this from the Community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View.
Thanks,
Shivani Patel