Root Cause
The issue was caused by a non-optimized query that struggled when handling more than 50 records, leading to problems in database searches.
Resolution
The problem was resolved by applying a revert to address the issue.
Action Plan
To prevent similar issues in the future, unit tests will be created to avoid this type of failure scenario.