Emails hold on "in progress" status

[roberto.fabbri]

Dear all,
I've used email campaign function in SugarCRM for some months, with this tedious, recurring trouble:

Once shot the campaign, it starts regularly (1 mail per minute).
After some mail sent (maybe 1, maybe 100), SugarCRM stops itself and shifts to an ambiguous "in progress" status. The status is visible in the planning subpanel, inside administration page and it lasts until I manually reboot the "Run Nightly Mass Email Campaigns" function.

With 1 mail per minute rate, the problem happens less frequently, with superior rates, neither 2 or 3 mail are sent continuously.

This is quite annoying because my DB is of over 30k entries and already 1 mail per minute, I think it's a very slow rate to send to.

I don't know what can be the cause, and how can I fix it.
Any ideas?

Thanks to all, in advance
Roberto Fabbri

[crmsiva]

Hi

Did you check log file for any errors?

May be your SMTP server is not capable or having some sending limits..

[amaltemara]

I had the same problem...

Mass email scheduler was showing 'In Progress' for 2 or 3 jobs, never showing 'In Completed'...

The problem was my max execution time for my command line php. (my web server uses a different php binary and php.ini)

I had set the web server's php.ini to the recommended settings in the sugar install, but forgot about the command line php binary, which uses a different php.ini. (Ubuntu 8.04 LTS + Litespeed)

the setting in php.ini was:

max_execution_time = 30

I set this to 600, and jobs are completing fine now.



To find your command line php.ini, execute:

php -i | grep php.ini


Hope this helps!

-Anthony Altemara

http://sageserver.com