Error generating report for long date ranges in Matomo (Oops… there was a problem during the request)

Support & Bugs
1

Hello community,

I’m experiencing an issue when generating a report in Matomo and would appreciate any insights.

Context:

  • Matomo version: 5.6.2

  • MySQL version: 8.0.44

  • PHP version: 8.0.30

  • The report is based on User ID, specifying the environment as PROD and a date range.

Problem: When I try to pull all user interactions for a long period (for example, January 1 to December 31), I get the following error:

Oops… there was a problem during the request. Maybe the server had a temporary issue, or maybe you requested a report with too much data. Please try again. If this error occurs repeatedly please contact your Matomo administrator for assistance.

Strange behavior:

  • If I filter January 1 to August 29, it works fine.

  • If I filter January 1 to August 31, I get the error.

  • If I filter August 25 to August 31, it works.

  • But if I filter the entire month of August, it fails.

  • The same happens with November.

We tried duplicating the filter, but that didn’t help.

Question: Has anyone encountered this issue before? Could it be a bug related to ranges that include the 31st or the amount of data? Any suggestions on how to fix this?

Thanks in advance for your help!