This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
fix when the flow is returning -1, In the database run the following query:
DELETE FROM OO_TABLE_LOCKS WHERE NAME = ‘PURGE_ALL’
This should fix the flow and api returning -1. Make sure that no active purge execution summary event is running
Question
Earlier we had the purge execution flow fail. Since then viewing steps in OO is very slow and takes a large amount of cpu to achieve compared to the OO instances that have not failed and are similar sizes.
Answer
To fix when the flow is returning -1, In the database run the following query:
DELETE FROM OO_TABLE_LOCKS WHERE NAME = ‘PURGE_ALL’
This should fix the flow and api returning -1. Make sure that no active purge execution summary event is running