Reports - download PDF stopped working

Self-Hosted | v5
1

Each quarter I run reports for invoices and expenses to download the previous quarter which I send to my accountant. I get a message saying I’ll be emailed a download link - it never comes through (used to work). I’ve updated to the latest version. Here’s output from some of the log for the container (not necessarily in time order!):
2024-10-01 17:24:22 App\Jobs\Invoice\ZipInvoices … RUNNING
(see quite a few similar to this)
2024-10-01 17:11:12,867 INFO reaped unknown pid 8416 (exit status 0)
(seeing some of these)
2024-10-01 17:25:01 Running [queue-size-job] … 39.35ms DONE

2024-10-01 17:25:01 Running [Callback] … 148.38ms DONE

2024-10-01 17:25:01 App\Jobs\Ninja\QueueSize … RUNNING

2024-10-01 17:25:01 App\Jobs\Ninja\QueueSize … 5.92ms DONE
NOTICE: PHP message: PHP Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php on line 1970
NOTICE: PHP message: PHP Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Casts/Json.php on line 36
2024-10-01 17:26:20 App\Jobs\Invoice\ZipInvoices … 1m 58s DONE

2024-10-01 17:26:20 App\Jobs\Mail\NinjaMailerJob … RUNNING

2024-10-01 17:26:24 App\Jobs\Mail\NinjaMailerJob … 3s DONE

I’m using the latest desktop app on Mac OS

Same sort of issue for expenses too - I need the download zip file with the actual receipts etc…

Used to work! Well it did last quarter!

2

Hi,

I suggest trying to increase the max PHP execution limit

3

Hi, how would I do that in the docker container - will it be something in the env file?

4

Maybe this will help: how to set max_execution_time php-fpm docker image? - Stack Overflow

5

no sorry, that didn’t help, my docker compose yml has the stuff in for starting invoice ninja and the nginx instance. It worked last quarter and previous quarters.

6

If the company has grown it’s possible it’s taking longer causing it to fail

7

no just little old me, about 31 invoices last quarter

8

It seems that it no longer likes the e-mail stuff defined in the env file - I put the email settings in the settings section. I also added this fastcgi_read_timeout 300; into the in-vhost.conf file.

Actually, worked a couple of times then I get a lot of
[2024-10-01 19:18:39] production.INFO: Using mailer => smtp
[2024-10-01 19:18:40] production.INFO: Mailer failed with Expected response code “250/251/252” but got code “550”, with message “550 5.7.1 Relaying denied”.
[2024-10-01 19:24:05] production.INFO: App\Jobs\Mail\NinjaMailerJob has been attempted too many times.

in the log file. the email login user/pass and send from all match. well at least I’ve managed to get my accounts off.

9

Are you able to email a test invoice?

Note: if you’re using the queue you’ll need to restart it after making any changes to the .env file

10

It’s come through again now so it tried it again I guess. I did docker-compose down and docker-compose up -d between each change I’ve fiddled about with. I’ve no idea why it thinks the e-mail is ‘relaying’! who knows!