I need to remove all workflow history. I have tried using the Advanced Server Options and setting the lifetime to 1 days. Where do I go to remove all history?
Question
Question
Workflow - How to remove history in search
Replies
What exactly do you mean by "workflow history"? The completed instances? Or any record that this workflow ever existed?
If we're talking about instances, then setting the lifetime to 1 day will clear them out in the next day or so.
I guess I mean when you search for history, all the data that is stored for workflows that have run in the past. I have set the lifetime to 1 day, but when I use workflow search I can search back through any workflows that have run for the last 3 months.
Oh actually looks like last night it cleared it up. But it still did not clear up the data in the database. Isn't the Search Acitivty Log/Messages table part of the historical data?
The problem is that the customer found a way to bypass the 10k repeat limit on endless loop by using a search to start an additional workflow, they then started an endless loop that ran 10k times and started 10k copies of itself. So it ran 100 million workflows in one day. This increased the database size to beyond Microsoft's Express Size Limitations.
We reached out to support and they recommended just paying Microsoft for the additional storage capabilities. I don't think they understand the extent of the cost, especially to store data that we don't need. I am determined to try to eliminate this useless history.