Cannot generate Automatic Report and email them

[nasser]

Good day!

I’m having a problem with suitecrm to generate automatic reports and email them to me.

1. I have installed a fresh suitecrm using cpanel hostgator
2. I only setup SMTP email and it’s working,
3. I added one account and opportunity.
4. The corn was setup automatically when I installed it in corn jobs but not working.
5. I generated a report and scheduled it.

Please advise on how to solve the automatic reporting issue and on the other errors that I’m receiving from diagnostic tool since this is a fresh installation.

[John]

Hey,
Looks like there might be an issue with the Crontab, if the Scheduled Job isn’t running

If you go to Admin->Schedulers, how does the line appear at the bottom?

It’ll show something like:
“* * * * * cd /var/www; php -f cron.php > /dev/null 2>&1”

If this differs from what appears in the Hostgator panel, it might be worth adding the line into Hostgator as a Cron job

Otherwise, I found a previous Forum thread in which users discussed Hostgator Cron issues, perhaps something here may be of help?:

Setup Cron Job / Scheduler on Hostgator

Hi, I have installed SuteCRM on my Hostgator Shared server. im unable to setup the Cron jobs and get the Schedulers running. Im not sure what i have to enter exactly. This is what the Schedulers Admin panel shows: cd /home/{username}/public_html/CRM; php -f cron.php > /dev/null 2>&1 i entered this in the Cron Jobs in CPanel but it doesnt work. the schedulers do not run. Any help would be appreciated. I also get this when i upload a logo: $mod_strings.LBL_LOGO Thanks …

[nasser]

Thank you so much for your support, I really appreciate it.

I have contacted hostgator, and it looks like they only allow corn jobs to be executed every 15+ minutes.
I have already set it to 15 minutes but still not working. Please find the attached screenshots
.

Also, cron will send an email every time it runs a command which produces output, and I have received this output,

[nasser]

Also, I tried to set the interval on the CRM to be every 15 minutes but still not working

[nasser]

@John Hello, after setting corn to be executed every 15 minutes in hostgator,

I started to receive this error
cron.php: running as epse is not allowed in allowed_cron_users in config.php. Exiting.

I managed to fix it by adding the user manually and I don’t receive it anymore. However, I now get this error
(Run Report Generation Scheduled Tasks) failed in CRON run

I looked for posts that have the same issue, but no luck in in finding a solution, can you please support.
Please find the attached log.

Thank you

[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!