See Suite Answer 84614 which shows you how to setup a saved search to indicate the status of transactions that may still be processing along with knowing your schedule for the recalculations.

Had the same error and this was the issue. Thanks for solving!

If your results are still over 1,000,000 when generated in the background you can select "Customize" on the report, give the report a new name, and on the filters tab add the applicable Date field. The date field will allow you to narrow your results further to get under the maximum lines. From there you can run say…