Auto reminders not sending

cmcam · July 21, 2023, 2:27pm

Hello,
I noticed the past few days my auto reminders are not sending out. I send out reminders at 10 days, 5 days and 1 day, all set to auto send email for all clients, but have several invoices open that are over-due, and it appears non of the reminders sent. If I click on an invoice, it will tell me the next send date, but when that date comes, it never actually sends. Log do not show anything (below), and I can manually send reminders just fine. Crontab is as following:

* * * * * /usr/bin/php8.2 /var/www/invoiceninja/artisan schedule:run >> /dev/null 2>&1

[2023-07-17 06:20:01] production.INFO: Performing Autobilling 2023-07-17 06:20:01
[2023-07-17 23:30:03] production.INFO: updating currencies
[2023-07-18 06:20:02] production.INFO: Performing Autobilling 2023-07-18 06:20:02
[2023-07-18 23:30:02] production.INFO: updating currencies
[2023-07-19 06:20:02] production.INFO: Performing Autobilling 2023-07-19 06:20:02
[2023-07-19 23:30:02] production.INFO: updating currencies
[2023-07-20 06:20:01] production.INFO: Performing Autobilling 2023-07-20 06:20:01
[2023-07-20 23:30:02] production.INFO: updating currencies
[2023-07-21 06:20:02] production.INFO: Performing Autobilling 2023-07-21 06:20:02

Anything else I can check? v5.6.19-M123
Thanks

hillel · July 21, 2023, 2:29pm

Hi,

@david do you have any suggestions?

david · July 22, 2023, 2:10am

One thing to check is in the database / invoice table… have a look at the reminders1_last_sent_date if these are filled in, then most likely you have manually sent those reminders. This would be the most likely explanation.

cmcam · July 22, 2023, 1:00pm

In the invoice table it is showing tomorrow’s date for next send. In the I am noticing in the ‘remaining cycles’ in the schedulers table they are all set to a value of -1. Is that normal?

cmcam · July 22, 2023, 7:55pm

I have also gone through and confirmed all client accounts have reminders enabled.

david · July 22, 2023, 11:56pm

In there Invoices table, check these columns:

If they have dates inserted on the reminders that you are expecting to have sent, then it means they have either already been sent manually so will not be triggered for another send when the automated ones are assessed for sending.

cmcam · July 23, 2023, 1:40am

There are dates inserted for one of the invoices, but the other invoice is listed as null(directly above the bottom). Neither of them were sent/ delivered. I just made a new test client with a test invoice, and it should send something out tomorrow. All the values for the future invoice are listed as null.

david · July 23, 2023, 2:15am

@cmcam

I would also suggest enabling expanded logging in your .env file

EXPANDED_LOGGING=true

This will give more details when the reminder job runs. Also, just confirm that the next_send_date for the invoice is primed for tomorrow.

cmcam · July 23, 2023, 2:54am

@david
I have enabled expanded logging and it appears that the invoices are primed. I have one that should go out tomorrow and one that should go out the day after. I will keep you updated. Thanks!

cmcam · July 23, 2023, 1:27pm

@david the invoice reminder sent with no issue today on my test client. I will have a real invoice going to my client again in a few days, so I will check and see if it occurs again.