insights: fix issue where records were not set as failed if they exceed max retries
Created by: coury-clark
Closes #24219 (closed) Closes #24203 (closed)
Fixes a bug where records that should be terminally marked failed
are left in errored
state because there is a condition requiring the record be processing
to update the row.