I have had a Cron entry running core:run-scheduled-tasks yesterday and today and it seems that the scheduled reports are now being sent at 1 hour and 5 minutes past the hour they are scheduled.

This coincides with the Cron entry:
5 * * * * /usr/bin/php /var/www/html/piwik/console core:run-scheduled-tasks

Should it really be necessary to execute this command manually in order to use scheduled reports? Also, it seems that when you set the time, for a Daily report at least, it does not get sent on the same day. I do not receive the report for the first time until the following day, despite the fact that I have core:run-scheduled-tasks running every hour now.

Hi @swsharp do you still experience this issue with Piwik 2.14.0?

Should it really be necessary to execute this command manually in order to use scheduled reports?

No it shouldn't be necessary. Do you also have a cron running for the core:archive command? http://piwik.org/docs/setup-auto-archiving/

Hi @mattab sorry for the delay.

I had tried the core:archive command at one time but that didn't seem to have any effect on the scheduled reports. And looking at the logs I did not see any indication that the archiving is failing. I eventually arrived at the core:run-scheduled-tasks command as a temporary solution.

I do have the default option to allow archiving to be triggered by the browser, though I probably shouldn't since the site has more than 10,000 visits/day. I will disable the browser archiving and begin to use the hourly cron.

Also, I finished building a test 2.10.0 server using the production data yesterday and upgraded it to 2.14.1. The users are wanting an upgrade to 2.14.1 anyway so I will let you know if we continue to see any issue there.

Hi @swsharp, to help us debug you could try enabling logging at DEBUG level (watch out it will log a lot of things!) into the log file (requires Piwik 2.11 or greater):

[log]
log_writers[] = "file"
log_level = "DEBUG"

Then you should be able to find logs by searching for Scheduler (cat tmp/logs/piwik.log | grep Scheduler).

Remember to change from DEBUG level to WARN level once you have finished (e.g. let it run for a day maybe). Watch out for the log file size if you have a lot of traffic.

On the Piwik 2.10.0 server the only redirected output from the core:archive task is the following:

INFO CoreConsole[2015-07-30 12:20:01] ---------------------------
INFO CoreConsole[2015-07-30 12:20:01] INIT
INFO CoreConsole[2015-07-30 12:20:01] Piwik is installed at: https://hostname/piwik/index.php
INFO CoreConsole[2015-07-30 12:20:01] Running Piwik 2.10.0 as Super User

In the piwik.log file, with log_level = "DEBUG", this is the output (I only removed lines pertaining to the LoginLdap plugin):

DEBUG Piwik\Db[2015-07-30 12:20:02] Db::fetchAll() executing SQL: SELECT DATABASE()
DEBUG Piwik\Db[2015-07-30 12:20:02] Db::fetchAll() executing SQL: SELECT option_value, option_name FROM `piwik_option` WHERE autoload = 1
DEBUG Piwik\Db[2015-07-30 12:20:02] Db::fetchOne() executing SQL: SELECT option_value FROM `piwik_option` WHERE option_name = ?
DEBUG Piwik\Plugin\Manager[2015-07-30 12:20:02] Loaded plugins: CorePluginsAdmin, CoreAdminHome, CoreHome, CoreVisualizations, Proxy, API, ExamplePlugin, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, MultiSites, Referrers, UserSettings, DevicesDetection, Goals, SEO, Events, UserCountry, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, ExampleAPI, ExampleRssWidget, Provider, Feedback, UsersManager, SitesManager, Installation, CoreUpdater, CoreConsole, ScheduledReports, UserCountryMap, Live, CustomVariables, PrivacyManager, ImageGraph, Annotations, MobileMessaging, Overlay, SegmentEditor, Insights, ZenMode, Morpheus, Contents, BulkTracking, Resolution, DevicePlugins, IntranetGeoIP, LdapVisitorInfo, LoginLdap, TasksTimetable
DEBUG SitesManager[2015-07-30 12:20:02] Db::fetchAll() executing SQL: SELECT idsite FROM piwik_site
DEBUG LanguagesManager[2015-07-30 12:20:02] Db::fetchOne() executing SQL: SELECT language FROM piwik_user_language WHERE login = ?
DEBUG SitesManager[2015-07-30 12:20:02] Db::fetchAll() executing SQL: SELECT idsite FROM piwik_site

By comparison, on the 2.14.1 server I am seeing a lot more output from core:archive and the task actually appears to be running. I am also receiving a test report without having to run core:run-scheduled-tasks on the 2.14.1 server.

@swsharp do you still experience the missing reports issue, or are all reports now correctly sent?

It may be worth trying again in 2.15.0-b7 where we fixed an issue which may help with this. If you still have the issue (or anyone else!) please leave a comment

@mattab we still had the problem with 2.10.0 but I updated the server to 2.14.3 last weekend and the problem seems to be gone.

I am now only running the core:archive command every hour in Cron, and not the core:run-scheduled-tasks command, and the scheduled reports are being sent.

Whatever the problem was seems to be fixed in the new releases. Thanks for your help with this issue.