Past Goal/Funnel report generation ends up in infinite loop

nelhefni · March 19, 2021, 7:04am

Hi, thanks for the fast answer.
I tried to use rearchive_reports_in_past_last_n_months with:
rearchive_reports_in_past_last_n_months = last0

But them the cron job fails with
Failed to create invalidations for report re-archiving (idSites = ["1"], pluginName = Funnels, report = 30, startDate = ): Error: Call to a member function isEarlier() on null in /var/www/html/core/Archive/ArchiveInvalidator.php:494

I’ve been reading the code the bit,

github.com

matomo-org/matomo/blob/34bf9d84c08f642c204e967acea55eb631ee6439/core/Archive/ArchiveInvalidator.php#L800


    }
    private function getEarliestDateToRearchive()
    {
        $lastNMonthsToInvalidate = Config::getInstance()->General['rearchive_reports_in_past_last_n_months'];
        if (empty($lastNMonthsToInvalidate)) {
            return null;
        }
        $lastNMonthsToInvalidate = (int) substr($lastNMonthsToInvalidate, 4);
        if (empty($lastNMonthsToInvalidate)) {
            return null;
        }
        return Date::yesterday()->subMonth($lastNMonthsToInvalidate)->setDay(1);
    }
}

$lastNMonthsToInvalidate will be equal to 0, and empty(0) is true, meaning getEarliestDateToRearchive() will return null instead of the current month, which then lead to the exception.

Also, could be good to update the documentation, to mention the past report generation

Concerning the infinite loop, I’m still a bit concern, because during the first cron job on the first day of a month, some Funnel reports are generated. Could you please double check what could be the root cause?

Thanks and Regards