how to speed up EnableComputedFields

  • Hi,


    The feature EnableComputedFields is very convenient in determining size of study series and checking for incomplete sets where server back systems are
    concerned. Are there any plans to make the results part of the record in the database?
    The Philips CT workstation's behavior when querying studies is to request all the study list from the server then uses the filter (name, date or procedures) to show studies fitting the request. I guess this is done so that when one a query is done all subsequent queries for other filters are done in memory, thus decreasing the time to list the results and reducing traffic for multiple queries.
    Unfortunately this causes the conquest server to count all studies which results in too long delays when thousands of studies have been stored. The only workable solution is to turn off this feature unless it has been stored before hand. Hope this can be done for the future, My wish list.


    ajgg

  • Hi,


    How is that done?


    This are the same queries from the philips workstation A. with the EnableReadAheadThread = 1 and B. with EnableReadAheadThread = 0


    A.


    12/18/2010 9:26:35 AM [CT_SRV1] UPACS THREAD 0: STARTED AT: Sat Dec 18 09:26:35 2010
    12/18/2010 9:26:35 AM [CT_SRV1] Calling Application Title : "EBW "
    12/18/2010 9:26:35 AM [CT_SRV1] Called Application Title : "CT_SRV1 "
    12/18/2010 9:26:35 AM [CT_SRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 65536
    12/18/2010 9:26:35 AM [CT_SRV1] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
    12/18/2010 9:26:35 AM [CT_SRV1] (StudyRootQuery) search level: STUDY
    12/18/2010 9:26:38 AM [CT_SRV1] C-Find (StudyRoot) located 8913 records
    12/18/2010 9:27:01 AM [CT_SRV1] (StudyRootQuery) search level: STUDY
    12/18/2010 9:27:03 AM [CT_SRV1] C-Find (StudyRoot) located 8913 records
    12/18/2010 9:27:41 AM [CT_SRV1] set debug level from GUI
    12/18/2010 9:27:41 AM [CT_SRV1] set debug log from GUI
    12/18/2010 9:27:49 AM [CT_SRV1] Connected by address: 0100007f
    12/18/2010 9:27:49 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    12/18/2010 9:27:49 AM [CT_SRV1] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
    12/18/2010 9:27:49 AM [CT_SRV1] 0000,0100 2 US CommandField 48
    12/18/2010 9:27:49 AM [CT_SRV1] 0000,0110 2 US MessageID 7
    12/18/2010 9:27:49 AM [CT_SRV1] 0000,0800 2 US DataSetType 257
    12/18/2010 9:27:49 AM [CT_SRV1] 9999,0300 24 UN "set debug level from GUI"
    12/18/2010 9:27:49 AM [CT_SRV1] 9999,0400 12 UN "debuglevel:4"
    12/18/2010 9:27:49 AM [CT_SRV1] set debug level from GUI
    12/18/2010 9:28:42 AM [CT_SRV1] Server Command := 0020
    12/18/2010 9:28:42 AM [CT_SRV1] Message ID := 0003
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.2.2.1"
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0100 2 US CommandField 32
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0110 2 US MessageID 3
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0700 2 US Priority 1
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0800 2 US DataSetType 0
    12/18/2010 9:28:42 AM [CT_SRV1] (StudyRootQuery) search level: STUDY
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0005 0 CS SpecificCharacterSet (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0020 0 DA StudyDate (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0030 0 TM StudyTime (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0050 0 SH AccessionNumber (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0052 6 CS QueryRetrieveLevel "STUDY "
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0061 0 CS (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0090 0 PN ReferringPhysicianNa (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,1030 0 LO StudyDescription (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0010 0 PN PatientName (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0020 0 LO PatientID (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0030 0 DA PatientBirthDate (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0032 0 TM PatientBirthTime (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0040 0 CS PatientSex (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,000d 0 UI StudyInstanceUID (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,0010 0 SH StudyID (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,1206 0 IS NumberOfStudyRelated (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,1208 0 IS NumberOfStudyRelated (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0040,0254 0 UN (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] Query On Study
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0008 0005
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0010 0032
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0020 1206
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0020 1208
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0040 0254
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID, dicomstudies.studydate
    12/18/2010 9:28:42 AM [CT_SRV1] Values:
    12/18/2010 9:28:42 AM [CT_SRV1] Tables: DICOMStudies
    12/18/2010 9:28:42 AM [CT_SRV1] Sorting (dicomstudies.studydate) DoSort := 1
    12/18/2010 9:28:42 AM [CT_SRV1] Query Distinct Tables: DICOMStudies
    12/18/2010 9:28:42 AM [CT_SRV1] Columns : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID, dicomstudies.studydate
    12/18/2010 9:28:42 AM [CT_SRV1] Where : (null)
    12/18/2010 9:28:42 AM [CT_SRV1] Order : dicomstudies.studydate
    12/18/2010 9:28:42 AM [CT_SRV1] Records = 8913
    12/18/2010 9:28:42 AM [CT_SRV1] First record of cleaned response:
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0020 8 DA StudyDate "20040223"
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0030 6 TM StudyTime "131510"
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0050 0 SH AccessionNumber (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0061 2 CS "CT"
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0090 0 PN ReferringPhysicianNa (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,1030 0 LO StudyDescription (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0010 14 PN PatientName "CTCOROS^-ANGIO"
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0020 4 LO PatientID "meh "
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0030 8 DA PatientBirthDate "19201010"
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0040 2 CS PatientSex "M "
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,000d 38 UI StudyInstanceUID "1.2.840.113704.1.111.6356.1078322075.1"
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,0010 4 SH StudyID "3766"
    12/18/2010 9:28:44 AM [CT_SRV1] C-Find (StudyRoot) located 8913 records
    12/18/2010 9:30:44 AM [CT_SRV1] UPACS THREAD 0: ENDED AT: Sat Dec 18 09:30:44 2010
    12/18/2010 9:30:44 AM [CT_SRV1] UPACS THREAD 0: TOTAL RUNNING TIME: 249 SECONDS
    12/18/2010 9:31:18 AM [CT_SRV1] Connected by address: 630aa8c0
    12/18/2010 9:31:18 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'
    12/18/2010 9:31:18 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #1 = '1.2.840.10008.1.2.4.50'
    12/18/2010 9:31:18 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #2 = '1.2.840.10008.1.2.4.51'
    12/18/2010 9:31:18 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #3 = '1.2.840.10008.1.2.4.53'
    12/18/2010 9:31:18 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #4 = '1.2.840.10008.1.2.4.55'
    12/18/2010 9:31:18 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #5 = '1.2.840.10008.1.2.4.57'
    12/18/2010 9:31:18 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #6 = '1.2.840.10008.1.2.4.70'
    12/18/2010 9:31:18 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    12/18/2010 9:31:18 AM [CT_SRV1]
    12/18/2010 9:31:18 AM [CT_SRV1] UPACS THREAD 1: STARTED AT: Sat Dec 18 09:31:18 2010
    12/18/2010 9:31:18 AM [CT_SRV1] A-ASSOCIATE-RQ Packet Dump
    12/18/2010 9:31:18 AM [CT_SRV1] Calling Application Title : "EBW "
    12/18/2010 9:31:18 AM [CT_SRV1] Called Application Title : "CT_SRV1 "
    12/18/2010 9:31:18 AM [CT_SRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 65536
    12/18/2010 9:31:18 AM [CT_SRV1] Number of Proposed Presentation Contexts: 1
    12/18/2010 9:31:18 AM [CT_SRV1] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
    12/18/2010 9:31:18 AM [CT_SRV1] Server Command := 0020
    12/18/2010 9:31:18 AM [CT_SRV1] Message ID := 0001
    12/18/2010 9:31:18 AM [CT_SRV1] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.2.2.1"
    12/18/2010 9:31:18 AM [CT_SRV1] 0000,0100 2 US CommandField 32
    12/18/2010 9:31:18 AM [CT_SRV1] 0000,0110 2 US MessageID 1
    12/18/2010 9:31:18 AM [CT_SRV1] 0000,0700 2 US Priority 1
    12/18/2010 9:31:18 AM [CT_SRV1] 0000,0800 2 US DataSetType 0
    12/18/2010 9:31:18 AM [CT_SRV1] (StudyRootQuery) search level: STUDY
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,0005 0 CS SpecificCharacterSet (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,0020 0 DA StudyDate (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,0030 0 TM StudyTime (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,0050 0 SH AccessionNumber (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,0052 6 CS QueryRetrieveLevel "STUDY "
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,0061 0 CS (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,0090 0 PN ReferringPhysicianNa (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,1030 0 LO StudyDescription (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0010,0010 0 PN PatientName (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0010,0020 0 LO PatientID (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0010,0030 0 DA PatientBirthDate (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0010,0032 0 TM PatientBirthTime (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0010,0040 0 CS PatientSex (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0020,000d 0 UI StudyInstanceUID (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0020,0010 0 SH StudyID (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0020,1206 0 IS NumberOfStudyRelated (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0020,1208 0 IS NumberOfStudyRelated (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] 0040,0254 0 UN (empty)
    12/18/2010 9:31:18 AM [CT_SRV1] Query On Study
    12/18/2010 9:31:18 AM [CT_SRV1] Failed on VR Search: 0008 0005
    12/18/2010 9:31:18 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:31:18 AM [CT_SRV1] Failed on VR Search: 0010 0032
    12/18/2010 9:31:18 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:31:18 AM [CT_SRV1] Failed on VR Search: 0020 1206
    12/18/2010 9:31:18 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:31:18 AM [CT_SRV1] Failed on VR Search: 0020 1208
    12/18/2010 9:31:18 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:31:18 AM [CT_SRV1] Failed on VR Search: 0040 0254
    12/18/2010 9:31:18 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:31:18 AM [CT_SRV1] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID, dicomstudies.studydate
    12/18/2010 9:31:18 AM [CT_SRV1] Values:
    12/18/2010 9:31:18 AM [CT_SRV1] Tables: DICOMStudies
    12/18/2010 9:31:18 AM [CT_SRV1] Sorting (dicomstudies.studydate) DoSort := 1
    12/18/2010 9:31:18 AM [CT_SRV1] Query Distinct Tables: DICOMStudies
    12/18/2010 9:31:18 AM [CT_SRV1] Columns : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID, dicomstudies.studydate
    12/18/2010 9:31:18 AM [CT_SRV1] Where : (null)
    12/18/2010 9:31:18 AM [CT_SRV1] Order : dicomstudies.studydate
    12/18/2010 9:31:18 AM [CT_SRV1] Records = 8913
    12/18/2010 9:31:18 AM [CT_SRV1] First record of cleaned response:
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,0020 8 DA StudyDate "20040223"
    12/18/2010 9:31:18 AM [CT_SRV1] 0008,0030 6 TM StudyTime "131510"
    12/18/2010 9:31:19 AM [CT_SRV1] 0008,0050 0 SH AccessionNumber (empty)
    12/18/2010 9:31:19 AM [CT_SRV1] 0008,0061 2 CS "CT"
    12/18/2010 9:31:19 AM [CT_SRV1] 0008,0090 0 PN ReferringPhysicianNa (empty)
    12/18/2010 9:31:19 AM [CT_SRV1] 0008,1030 0 LO StudyDescription (empty)
    12/18/2010 9:31:19 AM [CT_SRV1] 0010,0010 14 PN PatientName "CTCOROS^-ANGIO"
    12/18/2010 9:31:19 AM [CT_SRV1] 0010,0020 4 LO PatientID "meh "
    12/18/2010 9:31:19 AM [CT_SRV1] 0010,0030 8 DA PatientBirthDate "19201010"
    12/18/2010 9:31:19 AM [CT_SRV1] 0010,0040 2 CS PatientSex "M "
    12/18/2010 9:31:19 AM [CT_SRV1] 0020,000d 38 UI StudyInstanceUID "1.2.840.113704.1.111.6356.1078322075.1"
    12/18/2010 9:31:19 AM [CT_SRV1] 0020,0010 4 SH StudyID "3766"
    12/18/2010 9:31:20 AM [CT_SRV1] C-Find (StudyRoot) located 8913 records
    12/18/2010 9:31:55 AM [CT_SRV1] DGATE (1.4.15c, build Wed Dec 30 17:27:26 2009, bits 32) is running as threaded server
    12/18/2010 9:31:55 AM [CT_SRV1] Database type: native MySQL connection
    12/18/2010 9:31:55 AM [CT_SRV1] Started 2 export queue thread(s)
    12/18/2010 9:31:55 AM [CT_SRV1] Started prefetcher queue thread
    12/18/2010 9:31:55 AM [CT_SRV1] User interface test: local server is running!
    12/18/2010 9:31:55 AM [CT_SRV1] set normal log from GUI
    12/18/2010 9:32:07 AM [CT_SRV1] DGATE (1.4.15c, build Wed Dec 30 17:27:26 2009, bits 32) is running as threaded server
    12/18/2010 9:32:07 AM [CT_SRV1] Database type: native MySQL connection
    12/18/2010 9:32:07 AM [CT_SRV1] Started 2 export queue thread(s)
    12/18/2010 9:32:07 AM [CT_SRV1] Started prefetcher queue thread
    12/18/2010 9:32:07 AM [CT_SRV1] User interface test: local server is running!
    12/18/2010 9:33:29 AM [CT_SRV1] set debug level from GUI
    12/18/2010 9:33:29 AM [CT_SRV1] set debug log from GUI
    12/18/2010 9:33:32 AM [CT_SRV1] Connected by address: 0100007f
    12/18/2010 9:33:32 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    12/18/2010 9:33:32 AM [CT_SRV1] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
    12/18/2010 9:33:32 AM [CT_SRV1] 0000,0100 2 US CommandField 48
    12/18/2010 9:33:32 AM [CT_SRV1] 0000,0110 2 US MessageID 7
    12/18/2010 9:33:32 AM [CT_SRV1] 0000,0800 2 US DataSetType 257
    12/18/2010 9:33:32 AM [CT_SRV1] 9999,0300 24 UN "set debug level from GUI"
    12/18/2010 9:33:32 AM [CT_SRV1] 9999,0400 12 UN "debuglevel:4"
    12/18/2010 9:33:32 AM [CT_SRV1] set debug level from GUI
    12/18/2010 9:33:59 AM [CT_SRV1] Connected by address: 630aa8c0
    12/18/2010 9:33:59 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'
    12/18/2010 9:33:59 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #1 = '1.2.840.10008.1.2.4.50'
    12/18/2010 9:33:59 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #2 = '1.2.840.10008.1.2.4.51'
    12/18/2010 9:33:59 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #3 = '1.2.840.10008.1.2.4.53'
    12/18/2010 9:33:59 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #4 = '1.2.840.10008.1.2.4.55'
    12/18/2010 9:33:59 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #5 = '1.2.840.10008.1.2.4.57'
    12/18/2010 9:33:59 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #6 = '1.2.840.10008.1.2.4.70'
    12/18/2010 9:33:59 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    12/18/2010 9:33:59 AM [CT_SRV1]
    12/18/2010 9:33:59 AM [CT_SRV1] UPACS THREAD 0: STARTED AT: Sat Dec 18 09:33:59 2010
    12/18/2010 9:33:59 AM [CT_SRV1] A-ASSOCIATE-RQ Packet Dump
    12/18/2010 9:33:59 AM [CT_SRV1] Calling Application Title : "EBW "
    12/18/2010 9:33:59 AM [CT_SRV1] Called Application Title : "CT_SRV1 "
    12/18/2010 9:33:59 AM [CT_SRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 65536
    12/18/2010 9:33:59 AM [CT_SRV1] Number of Proposed Presentation Contexts: 1
    12/18/2010 9:33:59 AM [CT_SRV1] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
    12/18/2010 9:33:59 AM [CT_SRV1] Server Command := 0020
    12/18/2010 9:33:59 AM [CT_SRV1] Message ID := 0001
    12/18/2010 9:33:59 AM [CT_SRV1] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.2.2.1"
    12/18/2010 9:33:59 AM [CT_SRV1] 0000,0100 2 US CommandField 32
    12/18/2010 9:33:59 AM [CT_SRV1] 0000,0110 2 US MessageID 1
    12/18/2010 9:33:59 AM [CT_SRV1] 0000,0700 2 US Priority 1
    12/18/2010 9:33:59 AM [CT_SRV1] 0000,0800 2 US DataSetType 0
    12/18/2010 9:33:59 AM [CT_SRV1] (StudyRootQuery) search level: STUDY
    12/18/2010 9:33:59 AM [CT_SRV1] 0008,0005 0 CS SpecificCharacterSet (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0008,0020 0 DA StudyDate (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0008,0030 0 TM StudyTime (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0008,0050 0 SH AccessionNumber (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0008,0052 6 CS QueryRetrieveLevel "STUDY "
    12/18/2010 9:33:59 AM [CT_SRV1] 0008,0061 0 CS (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0008,0090 0 PN ReferringPhysicianNa (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0008,1030 0 LO StudyDescription (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0010,0010 0 PN PatientName (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0010,0020 0 LO PatientID (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0010,0030 0 DA PatientBirthDate (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0010,0032 0 TM PatientBirthTime (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0010,0040 0 CS PatientSex (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0020,000d 0 UI StudyInstanceUID (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0020,0010 0 SH StudyID (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0020,1206 0 IS NumberOfStudyRelated (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0020,1208 0 IS NumberOfStudyRelated (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] 0040,0254 0 UN (empty)
    12/18/2010 9:33:59 AM [CT_SRV1] Query On Study
    12/18/2010 9:33:59 AM [CT_SRV1] Failed on VR Search: 0008 0005
    12/18/2010 9:33:59 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:33:59 AM [CT_SRV1] Failed on VR Search: 0010 0032
    12/18/2010 9:33:59 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:33:59 AM [CT_SRV1] Failed on VR Search: 0040 0254
    12/18/2010 9:33:59 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:33:59 AM [CT_SRV1] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID, dicomstudies.studydate
    12/18/2010 9:33:59 AM [CT_SRV1] Values:
    12/18/2010 9:33:59 AM [CT_SRV1] Tables: DICOMStudies
    12/18/2010 9:33:59 AM [CT_SRV1] Sorting (dicomstudies.studydate) DoSort := 1
    12/18/2010 9:33:59 AM [CT_SRV1] Query Distinct Tables: DICOMStudies
    12/18/2010 9:33:59 AM [CT_SRV1] Columns : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID, dicomstudies.studydate
    12/18/2010 9:33:59 AM [CT_SRV1] Where : (null)
    12/18/2010 9:33:59 AM [CT_SRV1] Order : dicomstudies.studydate
    12/18/2010 9:33:59 AM [CT_SRV1] Query On Series
    12/18/2010 9:33:59 AM [CT_SRV1] Issue Query on Columns: DICOMSeries.SeriesInst, DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID
    12/18/2010 9:33:59 AM [CT_SRV1] Values: DICOMStudies.StudyDate = '20040223' and DICOMStudies.StudyTime = '131510' and (DICOMStudies.StudyModal = 'CT' or DICOMStudies.StudyModal LIKE 'CT\\%' or DICOMStudies.StudyModal LIKE '%\\CT\\%' or DICOMStudies.StudyModal LIKE '%\\CT') and DICOMStudies.PatientNam = 'CTCOROS^-ANGIO' and DICOMStudies.PatientID = 'meh' and DICOMStudies.PatientBir = '19201010' and DICOMStudies.PatientSex = 'M' and DICOMStudies.StudyInsta = '1.2.840.113704.1.111.6356.1078322075.1' and DICOMStudies.StudyID = '3766' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta
    12/18/2010 9:33:59 AM [CT_SRV1] Tables: DICOMSeries, DICOMStudies
    12/18/2010 9:33:59 AM [CT_SRV1] Records = 1
    12/18/2010 9:33:59 AM [CT_SRV1] Query On Image
    12/18/2010 9:33:59 AM [CT_SRV1] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID
    12/18/2010 9:33:59 AM [CT_SRV1] Values: DICOMStudies.StudyDate = '20040223' and DICOMStudies.StudyTime = '131510' and (DICOMStudies.StudyModal = 'CT' or DICOMStudies.StudyModal LIKE 'CT\\%' or DICOMStudies.StudyModal LIKE '%\\CT\\%' or DICOMStudies.StudyModal LIKE '%\\CT') and DICOMStudies.PatientNam = 'CTCOROS^-ANGIO' and DICOMStudies.PatientID = 'meh' and DICOMStudies.PatientBir = '19201010' and DICOMStudies.PatientSex = 'M' and DICOMStudies.StudyInsta = '1.2.840.113704.1.111.6356.1078322075.1' and DICOMStudies.StudyID = '3766' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    12/18/2010 9:33:59 AM [CT_SRV1] Tables: DICOMImages, DICOMSeries, DICOMStudies
    12/18/2010 9:33:59 AM [CT_SRV1] Records = 6
    12/18/2010 9:33:59 AM [CT_SRV1] Query On Series
    12/18/2010 9:33:59 AM [CT_SRV1] Issue Query on Columns: DICOMSeries.SeriesInst, DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID
    12/18/2010 9:33:59 AM [CT_SRV1] Values: DICOMStudies.StudyDate = '20040311' and DICOMStudies.StudyTime = '101438' and (DICOMStudies.StudyModal = 'CT' or DICOMStudies.StudyModal LIKE 'CT\\%' or DICOMStudies.StudyModal LIKE '%\\CT\\%' or DICOMStudies.StudyModal LIKE '%\\CT') and DICOMStudies.PatientNam = 'CORUS^CT' and DICOMStudies.PatientID = '2004-183327' and DICOMStudies.PatientBir = '19310221' and DICOMStudies.PatientSex = 'M' and DICOMStudies.StudyInsta = '1.2.840.113704.1.111.3936.1079072201.1' and DICOMStudies.StudyID = '3932' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta
    12/18/2010 9:33:59 AM [CT_SRV1] Tables: DICOMSeries, DICOMStudies
    12/18/2010 9:33:59 AM [CT_SRV1] Records = 16
    12/18/2010 9:33:59 AM [CT_SRV1] Query On Image
    12/18/2010 9:33:59 AM [CT_SRV1] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID
    12/18/2010 9:33:59 AM [CT_SRV1] Values: DICOMStudies.StudyDate = '20040311' and DICOMStudies.StudyTime = '101438' and (DICOMStudies.StudyModal = 'CT' or DICOMStudies.StudyModal LIKE 'CT\\%' or DICOMStudies.StudyModal LIKE '%\\CT\\%' or DICOMStudies.StudyModal LIKE '%\\CT') and DICOMStudies.PatientNam = 'CORUS^CT' and DICOMStudies.PatientID = '2004-183327' and DICOMStudies.PatientBir = '19310221' and DICOMStudies.PatientSex = 'M' and DICOMStudies.StudyInsta = '1.2.840.113704.1.111.3936.1079072201.1' and DICOMStudies.StudyID = '3932' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    12/18/2010 9:33:59 AM [CT_SRV1] Tables: DICOMImages, DICOMSeries, DICOMStudies
    12/18/2010 9:33:59 AM [CT_SRV1] Records = 488




    ---------------- thsi goes on and on till tha last record is counted.



    ajgg

  • Hi forgot the second log


    B.
    12/18/2010 9:23:31 AM [CT_SRV1] User interface test: local server is running!
    12/18/2010 9:26:35 AM [CT_SRV1]
    12/18/2010 9:26:35 AM [CT_SRV1] UPACS THREAD 0: STARTED AT: Sat Dec 18 09:26:35 2010
    12/18/2010 9:26:35 AM [CT_SRV1] Calling Application Title : "EBW "
    12/18/2010 9:26:35 AM [CT_SRV1] Called Application Title : "CT_SRV1 "
    12/18/2010 9:26:35 AM [CT_SRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 65536
    12/18/2010 9:26:35 AM [CT_SRV1] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
    12/18/2010 9:26:35 AM [CT_SRV1] (StudyRootQuery) search level: STUDY
    12/18/2010 9:26:38 AM [CT_SRV1] C-Find (StudyRoot) located 8913 records
    12/18/2010 9:27:01 AM [CT_SRV1] (StudyRootQuery) search level: STUDY
    12/18/2010 9:27:03 AM [CT_SRV1] C-Find (StudyRoot) located 8913 records
    12/18/2010 9:27:41 AM [CT_SRV1] set debug level from GUI
    12/18/2010 9:27:41 AM [CT_SRV1] set debug log from GUI
    12/18/2010 9:27:49 AM [CT_SRV1] Connected by address: 0100007f
    12/18/2010 9:27:49 AM [CT_SRV1] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    12/18/2010 9:27:49 AM [CT_SRV1] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
    12/18/2010 9:27:49 AM [CT_SRV1] 0000,0100 2 US CommandField 48
    12/18/2010 9:27:49 AM [CT_SRV1] 0000,0110 2 US MessageID 7
    12/18/2010 9:27:49 AM [CT_SRV1] 0000,0800 2 US DataSetType 257
    12/18/2010 9:27:49 AM [CT_SRV1] 9999,0300 24 UN "set debug level from GUI"
    12/18/2010 9:27:49 AM [CT_SRV1] 9999,0400 12 UN "debuglevel:4"
    12/18/2010 9:27:49 AM [CT_SRV1] set debug level from GUI
    12/18/2010 9:28:42 AM [CT_SRV1] Server Command := 0020
    12/18/2010 9:28:42 AM [CT_SRV1] Message ID := 0003
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.2.2.1"
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0100 2 US CommandField 32
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0110 2 US MessageID 3
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0700 2 US Priority 1
    12/18/2010 9:28:42 AM [CT_SRV1] 0000,0800 2 US DataSetType 0
    12/18/2010 9:28:42 AM [CT_SRV1] (StudyRootQuery) search level: STUDY
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0005 0 CS SpecificCharacterSet (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0020 0 DA StudyDate (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0030 0 TM StudyTime (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0050 0 SH AccessionNumber (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0052 6 CS QueryRetrieveLevel "STUDY "
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0061 0 CS (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0090 0 PN ReferringPhysicianNa (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,1030 0 LO StudyDescription (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0010 0 PN PatientName (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0020 0 LO PatientID (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0030 0 DA PatientBirthDate (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0032 0 TM PatientBirthTime (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0040 0 CS PatientSex (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,000d 0 UI StudyInstanceUID (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,0010 0 SH StudyID (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,1206 0 IS NumberOfStudyRelated (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,1208 0 IS NumberOfStudyRelated (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0040,0254 0 UN (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] Query On Study
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0008 0005
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0010 0032
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0020 1206
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0020 1208
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Failed on VR Search: 0040 0254
    12/18/2010 9:28:42 AM [CT_SRV1] (testing phase) - ignored
    12/18/2010 9:28:42 AM [CT_SRV1] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID, dicomstudies.studydate
    12/18/2010 9:28:42 AM [CT_SRV1] Values:
    12/18/2010 9:28:42 AM [CT_SRV1] Tables: DICOMStudies
    12/18/2010 9:28:42 AM [CT_SRV1] Sorting (dicomstudies.studydate) DoSort := 1
    12/18/2010 9:28:42 AM [CT_SRV1] Query Distinct Tables: DICOMStudies
    12/18/2010 9:28:42 AM [CT_SRV1] Columns : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID, dicomstudies.studydate
    12/18/2010 9:28:42 AM [CT_SRV1] Where : (null)
    12/18/2010 9:28:42 AM [CT_SRV1] Order : dicomstudies.studydate
    12/18/2010 9:28:42 AM [CT_SRV1] Records = 8913
    12/18/2010 9:28:42 AM [CT_SRV1] First record of cleaned response:
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0020 8 DA StudyDate "20040223"
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0030 6 TM StudyTime "131510"
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0050 0 SH AccessionNumber (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0061 2 CS "CT"
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,0090 0 PN ReferringPhysicianNa (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0008,1030 0 LO StudyDescription (empty)
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0010 14 PN PatientName "CTCOROS^-ANGIO"
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0020 4 LO PatientID "meh "
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0030 8 DA PatientBirthDate "19201010"
    12/18/2010 9:28:42 AM [CT_SRV1] 0010,0040 2 CS PatientSex "M "
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,000d 38 UI StudyInstanceUID "1.2.840.113704.1.111.6356.1078322075.1"
    12/18/2010 9:28:42 AM [CT_SRV1] 0020,0010 4 SH StudyID "3766"
    12/18/2010 9:28:44 AM [CT_SRV1] C-Find (StudyRoot) located 8913 records
    12/18/2010 9:30:44 AM [CT_SRV1] UPACS THREAD 0: ENDED AT: Sat Dec 18 09:30:44 2010
    12/18/2010 9:30:44 AM [CT_SRV1] UPACS THREAD 0: TOTAL RUNNING TIME: 249 SECONDS

  • Try to add this to dicom. ini: (all on one line)


    QueryConverter0 = ifnotequal "%V0008,0052", "STUDY"; stop; ifnotempty "%V0010,0020"; stop; delete 0020,1206; delete 0020,1208


    This will remove the computed field requests for all STUDY queries where no patient ID is specified.


    Marcel

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!