Cron archive reports at most every X seconds is not working at all

What hapens if you run the task manually (outside the CRON)? does it work?
For reference, I found this:
Problème : Cron + Docker - Support en français (French) - Matomo forums
→ The ENV var was not properly set
Also are you sure your CRON user has sufficient rights?