Question about Automate in foundry

I have a Automation running on all objects has 75k Objects I am performing an action to update the values in a object when I put the batch size 999 with 1 batch run parllel hit execute comes out 76 batches- turns out of 75k objects I see 58k are completed but 17k are not completed I retry the failed batches I can see 67 batches re running is there anyway that I can solve this issue or is there any way that I can re trigger this retry failed batches?

Is there a way you can identify in the object filter the untreated objects? If not at the moment,
The 67 batches retrying instead of ~17 is weird - it means Foundry is re-running batches that partially succeeded, so you might get double-writes. Worth checking the actual error message on the failed batches first, that’ll tell you what’s really going on.

Quick things to try: drop your batch size from 999 to ~100-200, it’s much more stable at that scale. And rather than using the built-in retry, add a boolean property like update_completed to your object, have the action flip it to true on success, then re-run the automation filtered to update_completed = false. That way, you’re only hitting the objects that genuinely didn’t complete, no guesswork.

What error is showing on the failed batches? (also check the automation scale limit bracket you fall in, most probably it will be the 1st one)

Thanks for your answer!