Impossible to retry failed jobs when reach more than 10K

[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 5378 times

Thanks

[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.