Cannot generate Automatic Report and email them

[John]

Hey,

Glad to hear you’ve made some progress!

I vaguely remembered seeing that error before, and found an older thread where I’d spoken about it previously:

Run Report Generation Scheduled Tasks

Hi, If you have Database access, you should be able to change the “last_run” value in the “aor_scheduled_reports” table. If you don’t, then you could perhaps create a Workflow to set “last_run” = “date_created” on the creation of Scheduled Reports records, that should ensure that “last_run” is not NULL for any new scheduled reports records If you do the above, do the reports run?

It seems as though it is a currently open bug in SuiteCRM:

New Scheduled Report does not run. It creates PHP Fatal error AOR_Scheduled_Reports line 195

If you have created a Scheduled Report record, is the “Last Run” value Empty/Blank/NULL?

If so, could you follow the steps I suggested in the thread linked above, and see if it resolve your issue?

(ie: Set the “Last Run” value on your Scheduled Report record to anything other than “NULL”, either by a Workflow or via Database Access)

Let me know if you need any assistance!