We have an approval workflow on the Sales Order record that manages approvals based on custom pricing. This is a non-ending workflow, and it had been functioning correctly until recently.
We made an update to the workflow to reflect a change in business process, but subsequently reverted it to its previous state following a business request. Since this revert, users are encountering errors when attempting to save a Sales Order.
Notably, the issue is not affecting all users — only a specific subset, which adds complexity to diagnosing the root cause.
Based on guidance from a SuiteAnswers article, we reviewed the workflow instances for this approval workflow and found that there are currently 150,580 active instances. We also came across references suggesting that deleting these instances may resolve the error. However, given that this is a non-ending workflow, our concern is whether deleting active instances would impact the approval configuration or audit trail on historical records.
We have an additional observation: each time the error appears, the workflow type referenced in the error message varies — it is not consistent. This raises a secondary concern about whether the errors are actually being triggered by a single specific workflow, or potentially multiple.
Has anyone encountered a similar situation? We would appreciate any insights or resolution steps, as this is currently impacting business operations.