Page 1 of 1
Impossible to retry failed jobs when reach more than 10K
Posted: Wed Feb 17, 2016 4:37 pm
by diegog
Hi
I'm routing studies to another server from Pacsone.
If the network fail then a long queue of "failed jobs" is created.
Is there a better way to resend all the studies than to use "display all" that crash becouse the quantity? (see image attached)
- Capture2.JPG (15.04KiB)Viewed 5402 times
Thanks
Re: Impossible to retry failed jobs when reach more than 10K
Posted: Wed Feb 17, 2016 5:47 pm
by pacsone
If the "Display All" page does not show or a blank page was shown, then you've run into either the PHP default timeout of 30 secs or your current memory limit for executing a PHP script was being exceeded (or both). You can fix it by modifying the following values in your PHP.INI configuration file:
Code: Select all
max_execution_time = 0
memory_limit = 512M
Save the file and restart Apache/IIS for the change to take effect.
If you don't want to select all those 14k+ failed jobs and retry them manually, you can login to the PacsOne Server database from a local command shell, then run the following SQL query from the MySQL shell prompt to retry all failed Forwarding jobs:
Code: Select all
mysql>update dbjob set status='submitted',submittime=NOW() where type='Forward' and status='Failed';
Above SQL query will retry ALL failed forwarding jobs to all destination AEs. But if you only want to retry those jobs to a specific destiantion AE, you can run the following instead:
Code: Select all
mysql>update dbjob set status='submitted',submittime=NOW() where type='Forward' and status='Failed' and aetitle='$YourDestAe';
where "
$YourDestAe" is the AE Title of that particular destination AE you want to retry.