Stop Sending not working / Schedule emails not sending

[alanhenry]

Hi All

Running 20.04.000.155 here.

We've had two major issues with this release and are wondering if anyone else has any similar experiences or possible solutions.

1) The stop delivery button doesn't work here. We're running our SMTP on another server, don't know if that is impacting that functionality.

2) Scheduled emails don't seem to trigger and send after generating. Sending one immediately after adding it in works fine though.

Wondering if anyone has experience something similar or has any tips.

[maschoff]

re 1: Please be a little bit more specific what you mean with "doesn't work".

re 2: Is you user time zone and the server time zone correct? is trigger process generate3.py up and running? Do you see any related entries in the maillog?

[alanhenry]

1) by not working I mean pressing that button doesn’t do anything - and same for Stop Generating. Both processes just continue regardless of what we do there. Seems there is no way to stop it.

2) user/server time zone are all correct. I don’t see the generate3.py process here - any idea how to start it?

Our cron file:

[root@ip-172-31-75-48 cron]# vi openemm

10 2 * * * /home/openemm/bin/janitor.sh openemm
45 20 * * * /home/openemm/bin/bouncemanagement.sh
~                                                                                        
~                                                                                        
~                                                                                        
~

[maschoff]

1.) If you try to stop a mailing less than an hour before sending time it is already in production and will not work.

2.) generate3.py is a backend process and launched when you restart OpenEMM.

[perun]

Hi,

We are having a weird problem with undo_mailing_tbl queries:
2020-09-09 17:03:07,437: ERROR [https-openssl-apr-8443-exec-19] com.agnitas.emm.core.JavaMailServiceImpl - Error sending email via xxxx: Invalid Addresses
emailSubject: EMM Error (Server: xxxxxxxx / Exceptiontype: CannotGetJdbcConnectionException)
emailContent: SQL: SELECT max(undo_id) AS last_undo_id FROM undo_mailing_tbl WHERE mailing_id = ?
Parameter: 0
Exception:
CannotGetJdbcConnectionException:
Could not get JDBC Connection; nested exception is java.sql.SQLException: Data source is closed

Is that something that could be affecting undo functionality?

I think our jdbc-connect and jdbc-driver properties are configured correctly, we didn't notice any problems anywhere else.

Thanks,

Matt

[maschoff]

The cause is not the database table, but the missing database connection.