Hi,
the index will automatically expand when the server is restarted.....
Marcel
Hi,
the index will automatically expand when the server is restarted.....
Marcel
1) To check for a substring try ... LIKE '%text%'
2) Make sure the field you are filtering on is listed in
a) in patient, study, series or image table in dicom.sql for real sql servers
b) in the image table for in dicom.sql for dbaseIII
Marcel
Hi,
If you are on linux, you must upgrade as listed. If you are on windows, you might have hit a disk size calculation limit. This code is the same for the listed versions so upgrading will probably not help. How much free space does the maintenance page list?
The dbaseIII file is NOT full at 4.7GB. My test system database is 6 GB big and far from its limit and others reported larger databases. You might have to use multiple disks (volumes) as MAGDevices to avoid your problem.
Marcel
We use MsSql for our hospital's production server (20 million images). You can off-course just copy the DBF tables over to the other server and continue with dbaseIII. It would save you a regen.
A short checklist:
dgate.exe, conquestdicomserver.exe, cqdicom.dll and dgate.dic can always be updated to newer versions without loss of data or functionality.
dgateserv.exe and zipdll.dll have not changed in years.
acrnema.map and dicom.ini can just be copied from older versions to keep your configuration.
dgatesop.lst is regenerated if needed and needs not be copied.
BUT: dicom.sql describes the database and must be copied along with the database. If you keep using dbaseIII copy the tables and the old dicom.sql, otherwise let the server make a new dicom.sql for you.
Marcel
Hi,
Ah, I now understand: With the dbaseIII driver you can only filter using fields that are included in the denormalized image database. See dicom.sql for its listing. With other (real) sql drivers you can use all fields in all tables.
Marcel
Please switch on debug logging and up the small arrows 4 times to show the highest level of debug info. Then try to get forwarding going and show me an excerpt of the log where the image database is queried.
Marcel
No, the order of fields in dicom.sql is irrelevant EXCEPT for the first and the last field that must stay where they are.
But jou MUST regen after changing dicom.sql. The server will else fail.
Marcel
I do not see it right away:
What database, what version? Maybe switch on debug logging at highest level to show some query activity?
Marcel
Hi,
No further changes planned, except maybe adding the PatientPosition to the denormalized image database for the built-in dbaseIII driver.
Marcel
Stop server.
Edit dicom.ini:
Set MAGDevices to 2
add MAGDevice1 = .....
Start server
Marcel
Hi,
you hit a small bug. Fixed in next release.
Marcel
Nothing wrong with it. If you get NKI compression to work (e.g. on a server with default settings) it would be nice to compare speeds.
Marcel
Apparently there is a memory leak somewhere. I'll have a look. Could you maybe see which process was using all that memory?
Marcel
If you use true sql servers like mssql, mysql or postgres, exportfilter may be used like this if you can write your filter on database fields.
Marcel
Exportmodality should work, just called and calling are empty.
Marcel
In drag and drop the called and calling AE are empty, i.e. '''. All other items like modality are read from the image and should work.
Marcel
May be related to strange characters (like ') in patient ID
Marcel
Hi Steini,
I've added your report it to know issues. Indeed it seems that the a check if (row[i]) make the drives fail to read (copy) empty results.
Marcel
No,
there are no printing forward rules: they are different from a store. Maybe something for in the future.
Marcel