Toshiba Ultrasound Worklist Query Returns Zero Results

  • A customer of ours is using the latest conquest sever as a Worklist Server.
    We have an issue with our Toshiba Aplio Ultrasound not being able to get MWM results from the Server.
    The issue is the Ultrasound is asking for a start time 0000-235959, but the Conquest server returns 0 results.
    I have searched through this forum and found a post regarding this. the fix was to put the following in the INI file


    WorkListQueryConverter0 = ifequal "%V0040,0001","aplio"; delete 0040,0003


    We modified this for the AE title of our ultrasound with no success.
    I have tried different things to remove the time tag from the query with out success.


    Even this WorkListQueryConverter0 = delete 0040,0003 or WorkListQueryConverter0 = set %V0040,0003 to ""


    Set the tag to have a value of 163000 and the query to the database had this time as well as the time sent from the ultrasound.


    In the log that are set to max debug show the above functions are being done but the rest of the log shows the query from the Ultrasound is overiding the function.
    Attached is the log from the Server
    Please help as the customer wants this fixed ASAP

  • Hi,


    The following is from the logs set to lvl4. I Had the following command in the INI file:- WorkListQueryConverter0 = set 0040,0003 to "163000" to find only pateints scheduled for this time
    First query is done by the Conquest software to its self.
    Worked fine,Showed the Patients with the requested time.
    Second query done by the Ulrasound.
    Didn't work. SQL query had 163000 for the time as well as the time requested by the Ultrasound


    14/03/2012 2:12:29 PM [CONQUESTSRV1] UPACS THREAD 6: STARTED AT: Wed Mar 14 14:12:29 2012
    14/03/2012 2:12:29 PM [CONQUESTSRV1] A-ASSOCIATE-RQ Packet Dump
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Calling Application Title : "CONQUESTSRV1 "
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Called Application Title : "CONQUESTSRV1 "
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Number of Proposed Presentation Contexts: 4
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.1.1" 1
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Presentation Context 1 "1.2.840.10008.5.1.4.1.2.2.1" 1
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Presentation Context 2 "1.2.840.10008.5.1.4.1.2.3.1" 1
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Presentation Context 3 "1.2.840.10008.5.1.4.31" 1
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Server Command := 0020
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Message ID := 0003
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0000,0002 24 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0000,0100 2 US CommandField 32
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0000,0110 2 US MessageID 3
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0000,0700 2 US Priority 0
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0000,0800 2 US DataSetType 258
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] WorkListQueryconverter0.1 executes: set 0040,0003 to "163000"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] (ModalityWorkListQuery) search level:
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0008,0050 0 SH AccessionNumber (empty)
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0008,0052 0 CS QueryRetrieveLevel (empty)
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0010,0010 0 PN PatientName (empty)
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0010,0020 0 LO PatientID (empty)
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0040,0003 6 TM ScheduledProcedureSt "163000"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Query On Modality WorkList
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.StartTime
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Values: DICOMWorkList.StartTime = '163000'
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Tables: DICOMWorkList
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Sorting (DICOMWorkList.PatientNam) DoSort := 1
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Query Distinct Tables: DICOMWorkList
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Columns : DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.StartTime
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Where : DICOMWorkList.StartTime = '163000'
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Order : DICOMWorkList.PatientNam
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0008,0050 14 SH AccessionNumber "TMN0000009955 "
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0010,0010 14 PN PatientName "xxxxxxxx "
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0010,0020 12 LO PatientID "yyyyyy"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0040,0003 6 TM ScheduledProcedureSt "163000"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] Records = 1
    14/03/2012 2:12:29 PM [CONQUESTSRV1] First record of cleaned response:
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0008,0005 10 CS SpecificCharacterSet "ISO_IR 100"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0008,0050 14 SH AccessionNumber "TMN0000009955 "
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0010,0010 14 PN PatientName "xxxxxxxx"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0010,0020 12 LO PatientID "yyyyyy"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] 0040,0003 6 TM ScheduledProcedureSt "163000"
    14/03/2012 2:12:29 PM [CONQUESTSRV1] C-Find (Modality Work List) located 1 records
    14/03/2012 2:12:29 PM [CONQUESTSRV1] UPACS THREAD 6: ENDED AT: Wed Mar 14 14:12:29 2012
    14/03/2012 2:12:29 PM [CONQUESTSRV1] UPACS THREAD 6: TOTAL RUNNING TIME: 0 SECONDS
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Connected by address: 6467a8c0
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    14/03/2012 2:12:59 PM [CONQUESTSRV1]
    14/03/2012 2:12:59 PM [CONQUESTSRV1] UPACS THREAD 7: STARTED AT: Wed Mar 14 14:12:59 2012
    14/03/2012 2:12:59 PM [CONQUESTSRV1] *** connection terminated
    14/03/2012 2:12:59 PM [CONQUESTSRV1] UPACS THREAD 7: ENDED AT: Wed Mar 14 14:12:59 2012
    14/03/2012 2:12:59 PM [CONQUESTSRV1] UPACS THREAD 7: TOTAL RUNNING TIME: 0 SECONDS
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Connected by address: 6467a8c0
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    14/03/2012 2:12:59 PM [CONQUESTSRV1]
    14/03/2012 2:12:59 PM [CONQUESTSRV1] UPACS THREAD 8: STARTED AT: Wed Mar 14 14:12:59 2012
    14/03/2012 2:12:59 PM [CONQUESTSRV1] A-ASSOCIATE-RQ Packet Dump
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Calling Application Title : "APLIO "
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Called Application Title : "CONQUESTSRV1 "
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 28672
    14/03/2012 2:12:59 PM [CONQUESTSRV1] Number of Proposed Presentation Contexts: 1
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Server Command := 0020
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Message ID := 0002
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0000,0002 22 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0000,0100 2 US CommandField 32
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0000,0110 2 US MessageID 2
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0000,0700 2 US Priority 0
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0000,0800 2 US DataSetType 0
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    14/03/2012 2:13:00 PM [CONQUESTSRV1] WorkListQueryconverter0.1 executes: set 0040,0003 to "163000"
    14/03/2012 2:13:00 PM [CONQUESTSRV1] (ModalityWorkListQuery) search level:
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0008,0005 0 CS SpecificCharacterSet (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0008,0050 0 SH AccessionNumber (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0008,0090 0 PN ReferringPhysicianNa (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0010,0010 0 PN PatientName (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0010,0020 0 LO PatientID (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0010,0030 0 DA PatientBirthDate (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0010,0040 0 CS PatientSex (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0010,1030 0 DS PatientWeight (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0010,2000 0 LO MedicalAlerts (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0010,2110 0 LO ContrastAllergies (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0010,21c0 0 US PregnancyStatus (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0020,000d 0 UI StudyInstanceUID (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0032,1032 0 PN RequestingPhysician (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0032,1033 0 LO RequestingService (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0032,1060 0 LO RequestedProcedureDe (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0032,1064 0 SQ RequestedProcedureCo Sequence Item
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0038,0010 0 LO AdmissionID (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0038,0050 0 LO SpecialNeeds (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0038,0300 0 LO CurrentPatientLocati (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0038,0400 0 LO PatientInstitutionRe (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0038,0500 0 LO PatientState (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,0003 6 TM ScheduledProcedureSt "163000"
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0008,0060 2 CS Modality "US"
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0032,1070 0 LO RequestedContrastAge (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0001 0 AE ScheduledStationAETi (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0002 18 DA ScheduledProcedureSt "20120314-20120314 "
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0003 12 TM ScheduledProcedureSt "0000-235959 "
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0004 0 DA ScheduledProcedureSt (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0005 0 TM ScheduledProcedureSt (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0006 0 PN ScheduledPerformingP (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0007 0 LO ScheduledProcedureSt (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0008 0 SQ ScheduledProcedureSt Sequence Item
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0009 0 SH ScheduledProcedureSt (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0010 0 SH ScheduledStationName (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0011 0 SH ScheduledProcedureSt (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0012 0 LO ScheduledPreOrderOfM (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] >0040,0400 0 LT CommentsOnScheduledP (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1001 0 SH RequestedProcedureID (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1002 0 LO ReasonForRequestedPr (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1003 0 SH RequestedProcedurePr (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1004 0 LO PatientTransportArra (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1005 0 LO RequestedProcedureLo (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1006 0 SH PlacerOrderNumberOfP (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1007 0 SH FillerOrderNumberOfP (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1008 0 LO ConfidentialityCode (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1009 0 UN (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1010 0 UN (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,1400 0 LT RequestedProcedureCo (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,2001 0 UN (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,2004 0 DA IssueDateOfImagingSe (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,2005 0 TM IssueTimeOfImagingSe (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,2006 0 SH PlacerOrderNumberOfI (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,2007 0 SH FillerOrderNumberOfI (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,2008 0 PN OrderEnteredBy (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,2009 0 SH OrderEntererLocation (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,2010 0 SH OrderCallbackPhoneNu (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,2400 0 LT ImagingServiceReques (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] 0040,3001 0 LT ConfidentialityConst (empty)
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Query On Modality WorkList
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0008 0005 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0008 0090 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0008 1110 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0008 1120 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0010 1030 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0010 21c0 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0032 1033 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0032 1064 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0038 0010 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0038 0050 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0038 0300 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0038 0400 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0038 0500 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 0004 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 0005 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 0008 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 1002 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 1004 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 1005 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 1006 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 1007 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 1008 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 1009 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 1010 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 1400 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 2001 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 2004 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 2005 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 2006 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 2007 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 2008 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 2009 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 2010 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 2400 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Queried item 0040 3001 is not in the database
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.StartTime, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.SchedPSCom, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Values: DICOMWorkList.StartTime = '163000' and DICOMWorkList.Modality = 'US' and DICOMWorkList.StartDate >= '20120314' and DICOMWorkList.StartDate <= '20120314' and DICOMWorkList.StartTime >= '0000' and DICOMWorkList.StartTime <= '235959'
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Tables: DICOMWorkList
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Sorting (DICOMWorkList.PatientNam) DoSort := 1
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Query Distinct Tables: DICOMWorkList
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Columns : DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.StartTime, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.SchedPSCom, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Where : DICOMWorkList.StartTime = '163000' and DICOMWorkList.Modality = 'US' and DICOMWorkList.StartDate >= '20120314' and DICOMWorkList.StartDate <= '20120314' and DICOMWorkList.StartTime >= '0000' and DICOMWorkList.StartTime <= '235959'
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Order : DICOMWorkList.PatientNam
    14/03/2012 2:13:00 PM [CONQUESTSRV1] Records = 0
    14/03/2012 2:13:00 PM [CONQUESTSRV1] C-Find (Modality Work List) located 0 records
    14/03/2012 2:13:00 PM [CONQUESTSRV1] UPACS THREAD 8: ENDED AT: Wed Mar 14 14:12:59 2012
    14/03/2012 2:13:01 PM [CONQUESTSRV1] UPACS THREAD 8: TOTAL RUNNING TIME: 0 SECONDS
    14/03/2012 2:13:30 PM -----------------------------------------------------



    Hope this helps

  • Locate and post this query line in the log:


    14/03/2012 2:13:00 PM [CONQUESTSRV1] Values: DICOMWorkList.StartTime = '163000' and DICOMWorkList.Modality = 'US' and DICOMWorkList.StartDate >= '20120314' and DICOMWorkList.StartDate <= '20120314' and DICOMWorkList.StartTime >= '0000' and DICOMWorkList.StartTime <= '235959'


    You see that orginally this did not make sense. After you modification it should look like:


    14/03/2012 2:13:00 PM [CONQUESTSRV1] Values: DICOMWorkList.StartTime = '163000' and DICOMWorkList.Modality = 'US' and DICOMWorkList.StartDate >= '20120314' and DICOMWorkList.StartDate <= '20120314'

  • Hi
    Here's the query results using that command


    19/03/2012 10:18:30 AM [CONQUESTSRV1] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.SchedPSCom, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
    19/03/2012 10:18:30 AM [CONQUESTSRV1] Values: DICOMWorkList.Modality = 'US' and DICOMWorkList.StartDate >= '20120319' and DICOMWorkList.StartDate <= '20120319' and DICOMWorkList.StartTime >= '0000' and DICOMWorkList.StartTime <= '235959'
    19/03/2012 10:18:30 AM [CONQUESTSRV1] Tables: DICOMWorkList
    19/03/2012 10:18:30 AM [CONQUESTSRV1] Sorting (DICOMWorkList.PatientNam) DoSort := 1
    19/03/2012 10:18:30 AM [CONQUESTSRV1] Query Distinct Tables: DICOMWorkList
    19/03/2012 10:18:30 AM [CONQUESTSRV1] Columns : DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.SchedPSCom, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
    19/03/2012 10:18:30 AM [CONQUESTSRV1] Where : DICOMWorkList.Modality = 'US' and DICOMWorkList.StartDate >= '20120319' and DICOMWorkList.StartDate <= '20120319' and DICOMWorkList.StartTime >= '0000' and DICOMWorkList.StartTime <= '235959'
    19/03/2012 10:18:30 AM [CONQUESTSRV1] Order : DICOMWorkList.PatientNam
    19/03/2012 10:18:30 AM [CONQUESTSRV1] Records = 0
    19/03/2012 10:18:30 AM [CONQUESTSRV1] C-Find (Modality Work List) located 0 records


    As you can see the Startime is still their.


    In the last log I sent, you can see that I had used the command set 0040,0003 to "163000". Yet the query showed DICOMWorkList.StartTime = '163000' and DICOMWorkList.StartTime >= '0000' and DICOMWorkList.StartTime <= '235959'
    Eventhough I set the time to a specific value, the Ultrasounds query is added on top of it.


    I found if I use set 0040,0100 to "" I got a result as follows


    19/03/2012 10:41:05 AM [CONQUESTSRV1] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
    19/03/2012 10:41:05 AM [CONQUESTSRV1] Values:
    19/03/2012 10:41:05 AM [CONQUESTSRV1] Tables: DICOMWorkList
    19/03/2012 10:41:05 AM [CONQUESTSRV1] Sorting (DICOMWorkList.PatientNam) DoSort := 1
    19/03/2012 10:41:05 AM [CONQUESTSRV1] Query Distinct Tables: DICOMWorkList
    19/03/2012 10:41:05 AM [CONQUESTSRV1] Columns : DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
    19/03/2012 10:41:05 AM [CONQUESTSRV1] Where : (null)
    19/03/2012 10:41:05 AM [CONQUESTSRV1] Order : DICOMWorkList.PatientNam
    19/03/2012 10:41:07 AM [CONQUESTSRV1] C-Find (Modality Work List) located 17 records
    19/03/2012 10:41:07 AM [CONQUESTSRV1] UPACS THREAD 8: ENDED AT: Mon Mar 19 10:41:06 2012


    But the ultrasound didn't accept any of the records as it didn't recieve a date and time.
    The issue seems that the conquest server doesn't like the time query. Can this be fixed please.

  • HI


    I've tried the following command in the ini file


    WorkListQueryConverter0 = ifequal "%V0040,0001" , "APLIO" ; set 0040,0100\0040,0003 to "*" ; stop ;


    I put the stop in to see were in the logs the command was executed.


    The result is still the same as the logs show


    22/03/2012 12:31:59 PM [CONQUESTSRV1] A-ASSOCIATE-RQ Packet Dump
    22/03/2012 12:31:59 PM [CONQUESTSRV1] Calling Application Title : "APLIO "
    22/03/2012 12:31:59 PM [CONQUESTSRV1] Called Application Title : "CONQUESTSRV1 "
    22/03/2012 12:31:59 PM [CONQUESTSRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 28672
    22/03/2012 12:31:59 PM [CONQUESTSRV1] Number of Proposed Presentation Contexts: 1
    22/03/2012 12:31:59 PM [CONQUESTSRV1] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1
    22/03/2012 12:31:59 PM [CONQUESTSRV1] Server Command := 0020
    22/03/2012 12:31:59 PM [CONQUESTSRV1] Message ID := 0006
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0000,0002 22 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0000,0100 2 US CommandField 32
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0000,0110 2 US MessageID 6
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0000,0700 2 US Priority 0
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0000,0800 2 US DataSetType 0
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    22/03/2012 12:31:59 PM [CONQUESTSRV1] WorkListQueryconverter0.2: stopThis were the command was executed
    22/03/2012 12:31:59 PM [CONQUESTSRV1] (ModalityWorkListQuery) search level:
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0008,0005 0 CS SpecificCharacterSet (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0008,0050 0 SH AccessionNumber (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0008,0090 0 PN ReferringPhysicianNa (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0010,0010 0 PN PatientName (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0010,0020 0 LO PatientID (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0010,0030 0 DA PatientBirthDate (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0010,0040 0 CS PatientSex (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0010,1030 0 DS PatientWeight (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0010,2000 0 LO MedicalAlerts (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0010,2110 0 LO ContrastAllergies (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0010,21c0 0 US PregnancyStatus (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0020,000d 0 UI StudyInstanceUID (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0032,1032 0 PN RequestingPhysician (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0032,1033 0 LO RequestingService (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0032,1060 0 LO RequestedProcedureDe (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0032,1064 0 SQ RequestedProcedureCo Sequence Item
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0038,0010 0 LO AdmissionID (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0038,0050 0 LO SpecialNeeds (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0038,0300 0 LO CurrentPatientLocati (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0038,0400 0 LO PatientInstitutionRe (empty)
    22/03/2012 12:31:59 PM [CONQUESTSRV1] 0038,0500 0 LO PatientState (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0008,0060 2 CS Modality "US"
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0032,1070 0 LO RequestedContrastAge (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0001 0 AE ScheduledStationAETi (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0002 18 DA ScheduledProcedureSt "20120322-20120322 "
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0003 12 TM ScheduledProcedureSt "0000-235959 " The Command didn't change this Tag
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0004 0 DA ScheduledProcedureSt (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0005 0 TM ScheduledProcedureSt (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0006 0 PN ScheduledPerformingP (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0007 0 LO ScheduledProcedureSt (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0008 0 SQ ScheduledProcedureSt Sequence Item
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0009 0 SH ScheduledProcedureSt (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0010 0 SH ScheduledStationName (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0011 0 SH ScheduledProcedureSt (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0012 0 LO ScheduledPreOrderOfM (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] >0040,0400 0 LT CommentsOnScheduledP (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1001 0 SH RequestedProcedureID (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1002 0 LO ReasonForRequestedPr (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1003 0 SH RequestedProcedurePr (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1004 0 LO PatientTransportArra (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1005 0 LO RequestedProcedureLo (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1006 0 SH PlacerOrderNumberOfP (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1007 0 SH FillerOrderNumberOfP (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1008 0 LO ConfidentialityCode (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1009 0 UN (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1010 0 UN (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,1400 0 LT RequestedProcedureCo (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,2001 0 UN (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,2004 0 DA IssueDateOfImagingSe (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,2005 0 TM IssueTimeOfImagingSe (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,2006 0 SH PlacerOrderNumberOfI (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,2007 0 SH FillerOrderNumberOfI (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,2008 0 PN OrderEnteredBy (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,2009 0 SH OrderEntererLocation (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,2010 0 SH OrderCallbackPhoneNu (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,2400 0 LT ImagingServiceReques (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] 0040,3001 0 LT ConfidentialityConst (empty)
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Query On Modality WorkList
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.SchedPSCom, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Values: DICOMWorkList.Modality = 'US' and DICOMWorkList.StartDate >= '20120322' and DICOMWorkList.StartDate <= '20120322' and DICOMWorkList.StartTime >= '0000' and DICOMWorkList.StartTime <= '235959'
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Tables: DICOMWorkList
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Sorting (DICOMWorkList.PatientNam) DoSort := 1
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Query Distinct Tables: DICOMWorkList
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Columns : DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.SchedPSCom, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Where : DICOMWorkList.Modality = 'US' and DICOMWorkList.StartDate >= '20120322' and DICOMWorkList.StartDate <= '20120322' and DICOMWorkList.StartTime >= '0000' and DICOMWorkList.StartTime <= '235959'
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Order : DICOMWorkList.PatientNam
    22/03/2012 12:32:00 PM [CONQUESTSRV1] Records = 0
    22/03/2012 12:32:00 PM [CONQUESTSRV1] C-Find (Modality Work List) located 0 recordsNo Recoprds have been returned
    22/03/2012 12:32:00 PM [CONQUESTSRV1] UPACS THREAD 7: ENDED AT: Thu Mar 22 12:31:59 2012
    22/03/2012 12:32:00 PM [CONQUESTSRV1] UPACS THREAD 7: TOTAL RUNNING TIME: 0 SECONDS



    The Comand to change the tag in the 0040,0100 sequence doesn't seem to work.

  • Hi
    I've tried the following:-


    WorkListQueryConverter0 = ifequal "%u" , "APLIO" ; set 0040,0100\0040,0003 to "*" ; stop ;
    Got exactly the same result as the last post
    I have also tried;-
    WorkListQueryConverter0 = set 0040,0100\0040,0003 to "*"
    and also got the same result.
    It looks like the set comand isn't working

Participate now!

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