Frequently Asked Questions

How to clean obsolete entries in the Query/Retrieve log?
Last Updated 9 years ago

It happens that the Query/Retrieve log contains old entries, where the number of images retrieved doesn't correspond with the number of images of the study. This doesn't usually mean that not all images were received, but is rather a bug in counting the received images.

To get rid of these obsolete entries, use the following procedure at a time no studies are being retrieved:
- Connect to the Perennity database, using for instance the MySQL Query Browser (from MySQL GUI Tools).
- After selecting the Perennity database, execute the following commands consecutively:
"update wwwordersretrieve set nbImagesSent = nbImages where nbImagesSent != nbImages;"
"
update wwwordersretrieve set status="2" where status="1";"
This will reset some values in the wwwordersretrieve table, which contains the status of the Q/R jobs.

Alternatively you can create a batch file to perform these actions.

The .bat file (e.g. cleanup.bat as attached) must contain the following statement:
"C:\Program Files (x86)\Perennity\embedded\mariadb\bin\mysql.exe" --host=localhost -P 3308 -u root &lt "C:\temp\script.txt"

The script.txt file referenced by the .bat file must contain the following queries:
use perennitydicom;
update perennitydicom.wwwordersretrieve set status='2' where status='1';


Make sure the script file is stored in the exact path referenced by the .bat file.

This script should work for a default Perennity DICOM installation with MariaDB database, where the database is "perennitydicom", on port 3308, with user "root" with no password.

The attached script "cleanupscript.bat" performs the same action using only a single batch file.

Please Wait!

Please wait... it will take a second!