Query for multi-valued item (StudyModal)

jantograaf · Mar 23rd 2018

Hi all,

I have a Conquest-database running on a client's server which is accessed on a Windows-workstation using RadiantViewer or on a Mac-workstation using Osirix. When it sends a query, we get the next result in our logs:

Code

23-3-2018 10:32:09 [SERVER] UPACS THREAD 2: STARTED AT: Fri Mar 23 10:32:09 2018
23-3-2018 10:32:09 [SERVER]  Calling Application Title : "RADIANTWS       "
23-3-2018 10:32:09 [SERVER]  Called Application Title : "SERVER          "
23-3-2018 10:32:10 [SERVER]  Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384
23-3-2018 10:32:10 [SERVER]  Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
23-3-2018 10:32:10 [SERVER] (StudyRootQuery) search level: STUDY
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] warning: query for this multi-valued item (StudyModal) will not test individual values
23-3-2018 10:32:10 [SERVER] C-Find (StudyRoot) located 70 records
23-3-2018 10:32:10 [SERVER] UPACS THREAD 2: ENDED AT: Fri Mar 23 10:32:10 2018
23-3-2018 10:32:10 [SERVER] UPACS THREAD 2: TOTAL RUNNING TIME: 1 SECONDS

Display More

What causes this specific error? Is it a ConQuest-setting?

marcelvanherk · Mar 23rd 2018

Hi,

This warning occurs because matching on a multi-valued entry is not implemented for a DBASEIII database. Whether this is an issue in practice depends on the contents of the database and the actual query.

regards,

Marcel

jantograaf · Mar 23rd 2018

Hi Marcel,

Thanks for your quick reply. So, this is a problem related to using the DbaseIII-based config? As it is not quite clear to me, is it correct that DBaseIII-based servers are not advised for production environments? If so, what would you advise on using in a Windows 7 environment with 17000+ patients, 23000+ studies (DX/MR/CR/...) and over 1.5million images?

It seems that just performing a query in the Conquest GUI to show a listing of all patients takes a few seconds, so maybe I can migrate this system to a new database-implementation to improve speed and stability.

I'd be glad to hear your advice.

Kind regards,

Jan

jantograaf · Mar 23rd 2018

Hi Marcel,

What database would you propose on a 17000+ patients (over a million images) Windows-based configuration?
It seems to me like the DbaseIII-solution isn't the way to go for larger databases...

I'd love to hear your thoughts on this.

Kind regards,

Jan

marcelvanherk · Mar 24th 2018

Hi,

dbaseIII is very stable, we used it up to 6M images so no urgent need to replace it. But I guess MySQL or postgres are the way to go for such a big setup. Regeneration could take a week or so though. Note sure the speed would be much better. Have a look at the test report in the manual for the speed of the different options.

Marcel

marcelvanherk · Mar 26th 2018

And make sure you do a regular backup of the database.

Marcel

Query for multi-valued item (StudyModal)

Participate now!

Share