Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Running report from 2021-12-01 to 2021-12-31 returns no data #18561

Closed
wadih opened this issue Jan 2, 2022 · 2 comments
Closed

Running report from 2021-12-01 to 2021-12-31 returns no data #18561

wadih opened this issue Jan 2, 2022 · 2 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@wadih
Copy link

wadih commented Jan 2, 2022

Hi,

Running report from 2021-12-01 to 2021-12-31 returns no data.

However running report from 2021-12-01 to 2021-12-30 returns full data set.

Looks like a bigger or equal conditional logic at play somewhere.

2022-01-02_15-30_1
2022-01-02_15-30

@bx80
Copy link
Contributor

bx80 commented Jan 4, 2022

Hi @wadih, thanks for reporting this issue.

When running the report for 2021-12-01 to 2021-12-30 report data is calculated on-demand and then cached since this is a custom date range. But when running the report for 2021-12-01 to 2021-12-31 this date range maps to entire month and so the pre-generated monthly data for December will be used.

As you are not seeing any data for the December month then it seems likely that this monthly data has not been generated for some reason.

You could try invalidating the cached data for December 2021 with

./console core:invalidate-report-data --dates=2021-12-01,2021-12-31 --periods=month --site=[your site id]

and regenerating it with:

./console core:archive

@wadih
Copy link
Author

wadih commented Jan 4, 2022

Hi @bx80,

You are right, after running those two commands, it now works.

I had to make console executable first, and it didn't recognize --site, so I ran:

./console core:invalidate-report-data --dates=2021-12-01,2021-12-31 --periods=month
./console core:archive

Thank you so much. I will go ahead and close the ticket.

@wadih wadih closed this as completed Jan 4, 2022
@sgiehl sgiehl added the answered For when a question was asked and we referred to forum or answered it. label Jan 5, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

3 participants