Scheduled report running at wrong time

I created a report and scheduled to run everyday at 1700 and email me with results. The system just ran it at 11:00 for no reason and marked the scheduled report as ran at 17:00

Can you please tell us your SuiteCRM version?

We’ve run a scheduled report in SuiteCRM-7.9.16 and SuiteCRM-7.10.29. In our case it’s working properly.

Check the suitecrm.log file in the SuiteCRM folder for detailed information about the scheduler run at the wrong time or correct.

I would start by checking the date.timezone setting in your php.ini for CLI (not the same as the web server PHP)

Other facts that it would be helpful for you to share:

  • what time zone are you personally on
  • what settings for timezone have been made in SuiteCRM
  • what time zone is the server on, that runs your SuiteCRM

Have you other Scheduled Reports - do they also run 6 hours out?
If none -create one, and check.

Do your Schedulers run at the expected time - or are they 6 hours out too?

sorry pgr -I overlapped with you there!

1 Like

We checked the settings within the CRM and they are all setup correctly for the end user. Seems like something happened on the db. we will look t that.