Random e-mail stuck in pending

Ask questions about installing and configuring ProcessMaker 3

Moderator: amosbatto

ferri1989
Posts: 23
Joined: Tue Sep 20, 2016 5:54 pm
Country: Spain

Random e-mail stuck in pending

Unread postby ferri1989 » Tue Dec 19, 2017 7:08 am

I'm using ProcessMaker 3.1 community with Ubuntu with Apache.

My e-mail provider is outlook365 and if I check the email logs in admin section I can see that 1 e-mail every arround 30-40 e-mail stuck in peding.

I check de opt/processmaker/shared/logs/cron.log and no error about this issue.

So any know how I can found more information about error e-mail error? And how I can reprocess all the pending e-mails?

I see this post https://forum.processmaker.com/viewtopic.php?t=705688 with similar error from PM2 but no answer about that

amosbatto
Posts: 5678
Joined: Mon Jun 22, 2009 10:28 am
Country: Bolivia
Location: La Paz
Contact:

Re: Random e-mail stuck in pending

Unread postby amosbatto » Tue Dec 19, 2017 8:20 pm

First of all, have you set the cron.php and sendmessagecron.php files to periodically execute on your PM server?

What do you see when you manually execute cron.php and sendmessagecron.php from the command line?

What do you see when you execute this in your database:
SELECT * FROM APP_MESSAGE WHERE APP_UID='xxxxxxxxxxxxxxxxxxxxxxxxxx';

(where xxxxxxxxxxxxxxxxxxxxx is the case ID found in the APPLICATION system variable or the APP_CACHE_VIEW.APP_UID field.)
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)

ferri1989
Posts: 23
Joined: Tue Sep 20, 2016 5:54 pm
Country: Spain

Re: Random e-mail stuck in pending

Unread postby ferri1989 » Thu Dec 28, 2017 10:46 am

amosbatto wrote:First of all, have you set the cron.php and sendmessagecron.php files to periodically execute on your PM server?

What do you see when you manually execute cron.php and sendmessagecron.php from the command line?

What do you see when you execute this in your database:
SELECT * FROM APP_MESSAGE WHERE APP_UID='xxxxxxxxxxxxxxxxxxxxxxxxxx';

(where xxxxxxxxxxxxxxxxxxxxx is the case ID found in the APPLICATION system variable or the APP_CACHE_VIEW.APP_UID field.)


For example for all e-mail sent between 22/12/2017 and 28/12/2017

only failed 1 of 68 e-mails only in column app_msg_status I see in "peding"

I have any way to force to try to send again?

amosbatto
Posts: 5678
Joined: Mon Jun 22, 2009 10:28 am
Country: Bolivia
Location: La Paz
Contact:

Re: Random e-mail stuck in pending

Unread postby amosbatto » Wed Jan 03, 2018 12:13 am

If the status of the message in APP_MESSAGES.APP_MSG_STATUS is 'PENDING', then executing the cron.php file should attempt to send the email again. That is why asked you to manually execute the cron.php file and tell me what output you see.
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)


Return to “Installation & Configuration”

Who is online

Users browsing this forum: No registered users and 3 guests