The Workflow Metrics SLA is not running with more than 20000 instances

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.2.X, 7.3.X, Master
• Fix Version/s: 7.3.X, 7.3.10 DXP GA1, Master
• Component/s: Workflow > Metrics
• Labels:
  • 7.3-known-issues
  • backend
  • backend_test
• Branch Version/s:
  7.3.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Git Pull Request: https://github.com/liferay-workflow/liferay-portal/pull/4

Steps to Reproduce

1. Assign "Single Approver" workflow for blogs entry
2. Go to Applications > Workflow > Metrics
3. Select "Single Approver"
4. Create a SLA
5. Add more than 20000 blogs instances (script)
6. Waiting 2 minute
7. Go to Applications > Workflow > Metrics
8. Select "Single Approver" and check if SLA is calculated

Actual Result

• An exception is throw on server log and SLA is not calculated

Expected Result

• SLA is calculated

Reproduced In

• master: 9366f16b33b6e91d9617c6f50b1503312ea0aca1