Retrieves agreements in FAILED status whose most recent failure event falls within the given date range. Maximum date range: 31 days. A duplicate-request lock prevents concurrent requests for the same store and auth key.