Hi all,

I have a strange problem: I use a python script to get a daily xlsx export of certain work packages. The script uses the urlrequest library to call the OpenProject API. After a wait of 10 seconds it subsequently calls the job_statuses URL to wait for the export and to get the resulting xlsx file.

From time to time the script terminates with a HTTP Error 404 when calling the job_statuses URL. I don't understand where the problem is. According to the OpenProject logs the export seems successful but it also shows the 404. When running the script a second time the everything works well.

What could be the problem here? What can I do to further investigate?

Thanks for your replies!

Best regards,
Gregor

• OpenProject CE 14.6.3 on Rocky Linux 9.4

Feb 21 06:00:02 ppslin openproject-worker-1.service[5095]: I, [2025-02-21T06:00:02.828097 #5095]  INFO -- : [ActiveJob] [WorkPackages::ExportJob] [e679c5eb-1b25-4fb9-8d3d-df58523d489a] Performing WorkPackages::ExportJob (Job ID: e679c5eb-1b25-4fb9-8d3d-df58523d489a) from GoodJob(default) enqueued at 2025-02-21T05:00:02.797678899Z
Feb 21 06:00:02 ppslin openproject-web-1.service[5154]: I, [2025-02-21T06:00:02.829203 #5154]  INFO -- : [f7cad927-ce14-4250-8d56-b842b34ce4ba] [ActiveJob] user=79 Retrying ApplicationJobWithStatus#upsert_status.
Feb 21 06:00:02 ppslin openproject-web-1.service[5154]: I, [2025-02-21T06:00:02.834130 #5154]  INFO -- : [f7cad927-ce14-4250-8d56-b842b34ce4ba] [ActiveJob] Enqueued WorkPackages::ExportJob (Job ID: e679c5eb-1b25-4fb9-8d3d-df58523d489a) to GoodJob(default)
Feb 21 06:00:02 ppslin openproject-web-1.service[5154]: I, [2025-02-21T06:00:02.834477 #5154]  INFO -- : [f7cad927-ce14-4250-8d56-b842b34ce4ba] method=GET path=/projects/propharma/work_packages.xls format=xls controller=WorkPackagesController action=index status=200 allocations=13843 duration=68.91 view=0.08 db=46.80 user=79
Feb 21 06:00:02 ppslin openproject-worker-1.service[5095]: I, [2025-02-21T06:00:02.917348 #5095]  INFO -- : [ActiveJob] [WorkPackages::ExportJob] [e679c5eb-1b25-4fb9-8d3d-df58523d489a] Enqueued Notifications::WorkflowJob (Job ID: 334d09c2-bafd-4e81-9309-43e32652a25b) to GoodJob(default)
Feb 21 06:00:02 ppslin openproject-worker-1.service[5095]: I, [2025-02-21T06:00:02.935697 #5095]  INFO -- : [ActiveJob] [Notifications::WorkflowJob] [334d09c2-bafd-4e81-9309-43e32652a25b] Performing Notifications::WorkflowJob (Job ID: 334d09c2-bafd-4e81-9309-43e32652a25b) from GoodJob(default) enqueued at 2025-02-21T05:00:02.915035171Z
Feb 21 06:00:02 ppslin openproject-worker-1.service[5095]: I, [2025-02-21T06:00:02.940072 #5095]  INFO -- : [ActiveJob] [WorkPackages::ExportJob] [e679c5eb-1b25-4fb9-8d3d-df58523d489a] Enqueued Exports::CleanupOutdatedJob (Job ID: 17ecb6c3-3834-461e-9721-ce59e18f2fa5) to GoodJob(default) at 2025-02-21 08:00:02 UTC
Feb 21 06:00:02 ppslin openproject-worker-1.service[5095]: I, [2025-02-21T06:00:02.940171 #5095]  INFO -- : [ActiveJob] [WorkPackages::ExportJob] [e679c5eb-1b25-4fb9-8d3d-df58523d489a] Performed WorkPackages::ExportJob (Job ID: e679c5eb-1b25-4fb9-8d3d-df58523d489a) from GoodJob(default) in 130.46ms
Feb 21 06:00:02 ppslin openproject-worker-1.service[5095]: I, [2025-02-21T06:00:02.940246 #5095]  INFO -- : [GoodJob] [5095] [GoodJob::Scheduler(queues=* max_threads=20)-thread-33709] Executed GoodJob e679c5eb-1b25-4fb9-8d3d-df58523d489a
Feb 21 06:00:02 ppslin openproject-worker-1.service[5095]: I, [2025-02-21T06:00:02.945342 #5095]  INFO -- : [ActiveJob] [Notifications::WorkflowJob] [334d09c2-bafd-4e81-9309-43e32652a25b] Enqueued Notifications::WorkflowJob (Job ID: 10b01901-c136-414d-a93a-e24e3afa6be8) to GoodJob(default) at 2025-02-21 05:25:02 UTC
Feb 21 06:00:02 ppslin openproject-worker-1.service[5095]: I, [2025-02-21T06:00:02.945459 #5095]  INFO -- : [ActiveJob] [Notifications::WorkflowJob] [334d09c2-bafd-4e81-9309-43e32652a25b] Performed Notifications::WorkflowJob (Job ID: 334d09c2-bafd-4e81-9309-43e32652a25b) from GoodJob(default) in 11.06ms
Feb 21 06:00:02 ppslin openproject-worker-1.service[5095]: I, [2025-02-21T06:00:02.945595 #5095]  INFO -- : [GoodJob] [5095] [GoodJob::Scheduler(queues=* max_threads=20)-thread-33708] Executed GoodJob 334d09c2-bafd-4e81-9309-43e32652a25b
Feb 21 06:00:12 ppslin openproject-web-1.service[5154]: I, [2025-02-21T06:00:12.888172 #5154]  INFO -- : [1b7e9d29-856c-4fb1-8c6e-4814295856ca] duration=3.50 db=0.91 view=2.59 status=404 method=GET path=/api/v3/job_statuses/e679c5eb-1b25-4fb9-8d3d-df58523d489a params={} host=openproject.xxxxxxxxx.ch user=79