Posts by hammad

    Hi


    I had gone through the manual and found that max no of MAGs that can be configured are 9. Is there any way that i can configure more than 9 MAGs. My requirement is 150. I want to save data from 150 medical centers of mine on separate MAGS.


    Please guide.


    --HM

    Sorry for the trouble as i haven't gone through the manual so deeply.....


    Will you please tell me what is the code for LOSSY JPEG Compression type.



    --HM

    Yes there is a column ViewName { 0x0008, 0x2127, "ViewName", 128, SQL_C_CHAR, DT_UI }.


    Database is already regenerated without any error and i later do so. But still i am facing the error until and unless i remove all the columns i added in the database and restore the original database.


    Will you please guide me how can i run the modifystudy command with my custom database.


    --HM

    Hi Marcel


    I replace single quotes with the double quotes but still facing the error. Appended below is the server log.


    9/8/2017 12:38:25 PM [HPACS] set debug level from GUI
    9/8/2017 12:38:31 PM [HPACS] Connected by address: 0100007f
    9/8/2017 12:38:31 PM [HPACS] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    9/8/2017 12:38:31 PM [HPACS] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
    9/8/2017 12:38:31 PM [HPACS] 0000,0100 2 US CommandField 48
    9/8/2017 12:38:31 PM [HPACS] 0000,0110 2 US MessageID 1
    9/8/2017 12:38:31 PM [HPACS] 0000,0800 2 US DataSetType 257
    9/8/2017 12:38:31 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    9/8/2017 12:38:31 PM [HPACS] 9999,0300 42 LO ConquestConsoleText "Server command sent using DGATE -- option"
    9/8/2017 12:38:31 PM [HPACS] 9999,0400 34 LO ConquestConsoleComma "modifystudy:A886-1,,compression J2"
    9/8/2017 12:38:31 PM [HPACS] Server command sent using DGATE -- option
    9/8/2017 12:38:31 PM [HPACS] Query On Image
    9/8/2017 12:38:31 PM [HPACS] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMImages.ImageNumbe, DICOMImages.NumberOfFr, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
    9/8/2017 12:38:31 PM [HPACS] Values: DICOMStudies.PatientID = 'A886-1' and DICOMSeries.ViewName = DICOMStudies.ViewName and DICOMImages.IMAGETYPE = DICOMSeries.IMAGETYPE
    9/8/2017 12:38:31 PM [HPACS] Tables: DICOMImages, DICOMSeries, DICOMStudies
    9/8/2017 12:38:31 PM [HPACS] ***Error: Unknown column 'DICOMStudies.ViewName' in 'where clause'


    This says that there is an uncolumn ViewName. Does the column is missing or what??


    --HM

    hi


    I am using the following command as before but today i am getting this error:[HPACS] ***Child: Unable to OpenFileMapping : 2 ('--modifystudy:A1234567-1). My command is as follow:-


    dgate64.exe '--modifystudy:A1234567-1,, compression j2'.


    Please guide..


    --HM

    I want to do it automatically. The Sonographer forward images to conquest with still images and cine loops. The conquest on receiving images, beside saving patient data and its corresponding information must also save the measurements and other information like LMP dates, Liver and Spleen size also save them in database. So, that in end we can query conquest and help doctor in report writing.


    --HM

    Hi


    By mysql database got corrupted and i failed to start the mysql service. This happened consecutively twice in a month. I had gone through the logs but there was nothing except the connection lost message.


    I had resinstalled the mysql database and its up and running. I wanted to know can i change the database type like MYISAM etc as per requirement??


    --HM

    Hi Marcel


    I need some help in Worklist. Appended below is the Server Log and dicom.sql for your review.
    Server Log
    7/17/2017 1:39:34 PM [HPACS] UPACS THREAD 7: STARTED AT: Mon Jul 17 13:39:33 2017
    7/17/2017 1:39:34 PM [HPACS] A-ASSOCIATE-RQ Packet Dump
    7/17/2017 1:39:34 PM [HPACS] Calling Application Title : "NX_DEFAULT1 "
    7/17/2017 1:39:34 PM [HPACS] Called Application Title : "HPACS "
    7/17/2017 1:39:34 PM [HPACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 65542
    7/17/2017 1:39:34 PM [HPACS] Number of Proposed Presentation Contexts: 1
    7/17/2017 1:39:34 PM [HPACS] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1
    7/17/2017 1:39:34 PM [HPACS] Server Command := 0020
    7/17/2017 1:39:34 PM [HPACS] Message ID := 0001
    7/17/2017 1:39:34 PM [HPACS] 0000,0002 22 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"
    7/17/2017 1:39:34 PM [HPACS] 0000,0100 2 US CommandField 32
    7/17/2017 1:39:34 PM [HPACS] 0000,0110 2 US MessageID 1
    7/17/2017 1:39:34 PM [HPACS] 0000,0700 2 US Priority 1
    7/17/2017 1:39:34 PM [HPACS] 0000,0800 2 US DataSetType 1
    7/17/2017 1:39:34 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    7/17/2017 1:39:34 PM [HPACS] (ModalityWorkListQuery) search level:
    7/17/2017 1:39:34 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    7/17/2017 1:39:34 PM [HPACS] 0008,0005 0 CS SpecificCharacterSet (empty)
    7/17/2017 1:39:34 PM [HPACS] 0008,0050 0 SH AccessionNumber (empty)
    7/17/2017 1:39:34 PM [HPACS] 0008,0090 0 PN ReferringPhysicianNa (empty)
    7/17/2017 1:39:34 PM [HPACS] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
    7/17/2017 1:39:34 PM [HPACS] >0008,1150 0 UI ReferencedSOPClassUI (empty)
    7/17/2017 1:39:34 PM [HPACS] >0008,1155 0 UI ReferencedSOPInstanc (empty)
    7/17/2017 1:39:34 PM [HPACS] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
    7/17/2017 1:39:34 PM [HPACS] >0008,1150 0 UI ReferencedSOPClassUI (empty)
    7/17/2017 1:39:34 PM [HPACS] >0008,1155 0 UI ReferencedSOPInstanc (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,0010 0 PN PatientName (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,0020 0 LO PatientID (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,0030 0 DA PatientBirthDate (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,0032 0 TM PatientBirthTime (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,0040 0 CS PatientSex (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,1000 0 LO OtherPatientIDs (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,1020 0 DS PatientSize (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,1030 0 DS PatientWeight (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,1080 0 LO MilitaryRank (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,2000 0 LO MedicalAlerts (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,2110 0 LO Allergies (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,2160 0 SH EthnicGroup (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,2180 0 SH Occupation (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,21b0 0 LT AdditionalPatientHis (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,21c0 0 US PregnancyStatus (empty)
    7/17/2017 1:39:34 PM [HPACS] 0010,4000 0 LT PatientComments (empty)
    7/17/2017 1:39:34 PM [HPACS] 0020,000d 0 UI StudyInstanceUID (empty)
    7/17/2017 1:39:34 PM [HPACS] 0032,1032 0 PN RequestingPhysician (empty)
    7/17/2017 1:39:34 PM [HPACS] 0032,1033 0 LO RequestingService (empty)
    7/17/2017 1:39:34 PM [HPACS] 0032,1060 0 LO RequestedProcedureDe (empty)
    7/17/2017 1:39:34 PM [HPACS] 0032,1064 0 SQ RequestedProcedureCo Sequence Item
    7/17/2017 1:39:34 PM [HPACS] >0008,0100 0 SH CodeValue (empty)
    7/17/2017 1:39:34 PM [HPACS] >0008,0102 0 SH CodingSchemeDesignat (empty)
    7/17/2017 1:39:34 PM [HPACS] >0008,0104 0 LO CodeMeaning (empty)
    7/17/2017 1:39:34 PM [HPACS] 0038,0010 0 LO AdmissionID (empty)
    7/17/2017 1:39:34 PM [HPACS] 0038,0050 0 LO SpecialNeeds (empty)
    7/17/2017 1:39:34 PM [HPACS] 0038,0300 0 LO CurrentPatientLocati (empty)
    7/17/2017 1:39:34 PM [HPACS] 0038,0500 0 LO PatientState (empty)
    7/17/2017 1:39:34 PM [HPACS] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item
    7/17/2017 1:39:34 PM [HPACS] >0008,0060 2 CS Modality "DX"
    7/17/2017 1:39:34 PM [HPACS] >0032,1070 0 LO RequestedContrastAge (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0001 0 AE ScheduledStationAETi (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0002 0 DA ScheduledProcedureSt (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0003 0 TM ScheduledProcedureSt (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0006 0 PN ScheduledPerformingP (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0007 0 LO ScheduledProcedureSt (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0008 0 SQ ScheduledProtocolCod Sequence Item
    7/17/2017 1:39:34 PM [HPACS] >0040,0009 0 SH ScheduledProcedureSt (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0010 0 SH ScheduledStationName (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0011 0 SH ScheduledProcedureSt (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0012 0 LO PreMedication (empty)
    7/17/2017 1:39:34 PM [HPACS] >0040,0020 0 CS ScheduledProcedureSt (empty)
    7/17/2017 1:39:34 PM [HPACS] 0040,1001 0 SH RequestedProcedureID (empty)
    7/17/2017 1:39:34 PM [HPACS] 0040,1002 0 LO ReasonForTheRequeste (empty)
    7/17/2017 1:39:34 PM [HPACS] 0040,1003 0 SH RequestedProcedurePr (empty)
    7/17/2017 1:39:34 PM [HPACS] 0040,1004 0 LO PatientTransportArra (empty)
    7/17/2017 1:39:34 PM [HPACS] 0040,2016 0 LO PlacerOrderNumberIma (empty)
    7/17/2017 1:39:34 PM [HPACS] 0040,2017 0 LO FillerOrderNumberIma (empty)
    7/17/2017 1:39:34 PM [HPACS] 0040,2400 0 LT ImagingServiceReques (empty)
    7/17/2017 1:39:34 PM [HPACS] 0040,3001 0 LO ConfidentialityConst (empty)
    7/17/2017 1:39:34 PM [HPACS] Query On Modality WorkList
    7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0005 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0090 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0008 1150 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0008 1155 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0008 1150 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0008 1155 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 0032 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 1000 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 1020 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 1030 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 1080 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 2160 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 2180 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 21b0 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 21c0 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0010 4000 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0032 1033 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0100 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0102 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0104 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0038 0010 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0038 0050 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0038 0300 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0038 0500 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0040 0020 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0040 1002 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0040 1004 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0040 2016 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0040 2017 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0040 2400 is not in the database
    7/17/2017 1:39:34 PM [HPACS] Queried item 0040 3001 is not in the database
    7/17/2017 1:39:34 PM [HPACS] 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.ReqProcID, DICOMWorkList.ReqProcPri
    7/17/2017 1:39:34 PM [HPACS] Values: DICOMWorkList.Modality = 'DX'
    7/17/2017 1:39:34 PM [HPACS] Tables: DICOMWorkList
    7/17/2017 1:39:34 PM [HPACS] Sorting (DICOMWorkList.PatientNam) DoSort := 1
    7/17/2017 1:39:34 PM [HPACS] Query Distinct Tables: DICOMWorkList
    7/17/2017 1:39:34 PM [HPACS] 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.ReqProcID, DICOMWorkList.ReqProcPri
    7/17/2017 1:39:34 PM [HPACS] Where : DICOMWorkList.Modality = 'DX'
    7/17/2017 1:39:34 PM [HPACS] Order : DICOMWorkList.PatientNam
    7/17/2017 1:39:34 PM [HPACS] Records = 0
    7/17/2017 1:39:34 PM [HPACS] C-Find (Modality Work List) located 0 records
    7/17/2017 1:39:34 PM [HPACS] UPACS THREAD 7: ENDED AT: Mon Jul 17 13:39:34 2017
    7/17/2017 1:39:34 PM [HPACS] UPACS THREAD 7: TOTAL RUNNING TIME: 1 SECONDS



    7/17/2017 1:41:41 PM [HPACS] UPACS THREAD 9: STARTED AT: Mon Jul 17 13:41:41 2017
    7/17/2017 1:41:41 PM [HPACS] A-ASSOCIATE-RQ Packet Dump
    7/17/2017 1:41:42 PM [HPACS] Calling Application Title : "NX_DEFAULT1 "
    7/17/2017 1:41:42 PM [HPACS] Called Application Title : "HPACS "
    7/17/2017 1:41:42 PM [HPACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 65542
    7/17/2017 1:41:42 PM [HPACS] Number of Proposed Presentation Contexts: 1
    7/17/2017 1:41:42 PM [HPACS] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1
    7/17/2017 1:41:42 PM [HPACS] Server Command := 0020
    7/17/2017 1:41:42 PM [HPACS] Message ID := 0001
    7/17/2017 1:41:42 PM [HPACS] 0000,0002 22 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"
    7/17/2017 1:41:42 PM [HPACS] 0000,0100 2 US CommandField 32
    7/17/2017 1:41:42 PM [HPACS] 0000,0110 2 US MessageID 1
    7/17/2017 1:41:42 PM [HPACS] 0000,0700 2 US Priority 1
    7/17/2017 1:41:42 PM [HPACS] 0000,0800 2 US DataSetType 1
    7/17/2017 1:41:42 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    7/17/2017 1:41:42 PM [HPACS] (ModalityWorkListQuery) search level:
    7/17/2017 1:41:42 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    7/17/2017 1:41:42 PM [HPACS] 0008,0005 0 CS SpecificCharacterSet (empty)
    7/17/2017 1:41:42 PM [HPACS] 0008,0050 0 SH AccessionNumber (empty)
    7/17/2017 1:41:42 PM [HPACS] 0008,0090 0 PN ReferringPhysicianNa (empty)
    7/17/2017 1:41:42 PM [HPACS] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
    7/17/2017 1:41:42 PM [HPACS] >0008,1150 0 UI ReferencedSOPClassUI (empty)
    7/17/2017 1:41:42 PM [HPACS] >0008,1155 0 UI ReferencedSOPInstanc (empty)
    7/17/2017 1:41:42 PM [HPACS] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
    7/17/2017 1:41:42 PM [HPACS] >0008,1150 0 UI ReferencedSOPClassUI (empty)
    7/17/2017 1:41:42 PM [HPACS] >0008,1155 0 UI ReferencedSOPInstanc (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,0010 0 PN PatientName (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,0020 0 LO PatientID (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,0030 0 DA PatientBirthDate (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,0032 0 TM PatientBirthTime (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,0040 0 CS PatientSex (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,1000 0 LO OtherPatientIDs (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,1020 0 DS PatientSize (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,1030 0 DS PatientWeight (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,1080 0 LO MilitaryRank (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,2000 0 LO MedicalAlerts (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,2110 0 LO Allergies (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,2160 0 SH EthnicGroup (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,2180 0 SH Occupation (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,21b0 0 LT AdditionalPatientHis (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,21c0 0 US PregnancyStatus (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,4000 0 LT PatientComments (empty)
    7/17/2017 1:41:42 PM [HPACS] 0020,000d 0 UI StudyInstanceUID (empty)
    7/17/2017 1:41:42 PM [HPACS] 0032,1032 0 PN RequestingPhysician (empty)
    7/17/2017 1:41:42 PM [HPACS] 0032,1033 0 LO RequestingService (empty)
    7/17/2017 1:41:42 PM [HPACS] 0032,1060 0 LO RequestedProcedureDe (empty)
    7/17/2017 1:41:42 PM [HPACS] 0032,1064 0 SQ RequestedProcedureCo Sequence Item
    7/17/2017 1:41:42 PM [HPACS] >0008,0100 0 SH CodeValue (empty)
    7/17/2017 1:41:42 PM [HPACS] >0008,0102 0 SH CodingSchemeDesignat (empty)
    7/17/2017 1:41:42 PM [HPACS] >0008,0104 0 LO CodeMeaning (empty)
    7/17/2017 1:41:42 PM [HPACS] 0038,0010 0 LO AdmissionID (empty)
    7/17/2017 1:41:42 PM [HPACS] 0038,0050 0 LO SpecialNeeds (empty)
    7/17/2017 1:41:42 PM [HPACS] 0038,0300 0 LO CurrentPatientLocati (empty)
    7/17/2017 1:41:42 PM [HPACS] 0038,0500 0 LO PatientState (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item
    7/17/2017 1:41:42 PM [HPACS] >0008,0060 2 CS Modality "DX"
    7/17/2017 1:41:42 PM [HPACS] >0032,1070 0 LO RequestedContrastAge (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0001 0 AE ScheduledStationAETi (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0002 0 DA ScheduledProcedureSt (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0003 0 TM ScheduledProcedureSt (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0006 0 PN ScheduledPerformingP (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0007 0 LO ScheduledProcedureSt (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0008 0 SQ ScheduledProtocolCod Sequence Item
    7/17/2017 1:41:42 PM [HPACS] >0040,0009 0 SH ScheduledProcedureSt (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0010 0 SH ScheduledStationName (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0011 0 SH ScheduledProcedureSt (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0012 0 LO PreMedication (empty)
    7/17/2017 1:41:42 PM [HPACS] >0040,0020 0 CS ScheduledProcedureSt (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,1001 0 SH RequestedProcedureID (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,1002 0 LO ReasonForTheRequeste (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,1003 0 SH RequestedProcedurePr (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,1004 0 LO PatientTransportArra (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,2016 0 LO PlacerOrderNumberIma (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,2017 0 LO FillerOrderNumberIma (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,2400 0 LT ImagingServiceReques (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,3001 0 LO ConfidentialityConst (empty)
    7/17/2017 1:41:42 PM [HPACS] Query On Modality WorkList
    7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0005 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0090 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0008 1150 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0008 1155 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0008 1150 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0008 1155 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 0032 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 1000 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 1020 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 1030 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 1080 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 2160 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 2180 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 21b0 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 21c0 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0010 4000 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0032 1033 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0100 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0102 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0104 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0038 0010 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0038 0050 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0038 0300 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0038 0500 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0040 0020 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0040 1002 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0040 1004 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0040 2016 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0040 2017 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0040 2400 is not in the database
    7/17/2017 1:41:42 PM [HPACS] Queried item 0040 3001 is not in the database
    7/17/2017 1:41:42 PM [HPACS] 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.ReqProcID, DICOMWorkList.ReqProcPri
    7/17/2017 1:41:42 PM [HPACS] Values: DICOMWorkList.Modality = 'DX'
    7/17/2017 1:41:42 PM [HPACS] Tables: DICOMWorkList
    7/17/2017 1:41:42 PM [HPACS] Sorting (DICOMWorkList.PatientNam) DoSort := 1
    7/17/2017 1:41:42 PM [HPACS] Query Distinct Tables: DICOMWorkList
    7/17/2017 1:41:42 PM [HPACS] 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.ReqProcID, DICOMWorkList.ReqProcPri
    7/17/2017 1:41:42 PM [HPACS] Where : DICOMWorkList.Modality = 'DX'
    7/17/2017 1:41:42 PM [HPACS] Order : DICOMWorkList.PatientNam
    7/17/2017 1:41:42 PM [HPACS] 0008,0050 10 SH AccessionNumber "20170717-1"
    7/17/2017 1:41:42 PM [HPACS] Coding sequence (0008,1110), level=1
    7/17/2017 1:41:42 PM [HPACS] (sequence is empty)
    7/17/2017 1:41:42 PM [HPACS] Coding sequence (0008,1120), level=1
    7/17/2017 1:41:42 PM [HPACS] (sequence is empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,0010 12 PN PatientName "ABC"
    7/17/2017 1:41:42 PM [HPACS] 0010,0020 12 LO PatientID "A1234"
    7/17/2017 1:41:42 PM [HPACS] 0010,0030 10 DA PatientBirthDate "2017-07-16"
    7/17/2017 1:41:42 PM [HPACS] 0010,0040 2 CS PatientSex "M "
    7/17/2017 1:41:42 PM [HPACS] 0010,2000 0 LO MedicalAlerts (empty)
    7/17/2017 1:41:42 PM [HPACS] 0010,2110 0 LO Allergies (empty)
    7/17/2017 1:41:42 PM [HPACS] 0020,000d 0 UI StudyInstanceUID (empty)
    7/17/2017 1:41:42 PM [HPACS] 0032,1032 20 PN RequestingPhysician "Requesting Physician"
    7/17/2017 1:41:42 PM [HPACS] 0032,1060 8 LO RequestedProcedureDe "CHEST PA"
    7/17/2017 1:41:42 PM [HPACS] Coding sequence (0032,1064), level=1
    7/17/2017 1:41:42 PM [HPACS] (sequence is empty)
    7/17/2017 1:41:42 PM [HPACS] Coding sequence (0040,0100), level=1
    7/17/2017 1:41:42 PM [HPACS] 0008,0060 2 CS Modality "DX"
    7/17/2017 1:41:42 PM [HPACS] 0032,1070 0 LO RequestedContrastAge (empty)
    7/17/2017 1:41:42 PM [HPACS] 0040,0001 12 AE ScheduledStationAETi "NX_DEFAULT1 "
    7/17/2017 1:41:42 PM [HPACS] 0040,0002 8 DA ScheduledProcedureSt "20170717"
    7/17/2017 1:41:42 PM [HPACS] 0040,0003 6 TM ScheduledProcedureSt "235010"
    7/17/2017 1:41:42 PM [HPACS] 0040,0007 0 LO ScheduledProcedureSt (empty)
    7/17/2017 1:41:42 PM [HPACS] Server Command := 0fff
    7/17/2017 1:41:42 PM [HPACS] Message ID := 0000
    7/17/2017 1:41:42 PM [HPACS] 0000,0100 2 US CommandField 4095
    7/17/2017 1:41:42 PM [HPACS] 0000,0120 2 US MessageIDBeingRespon 1
    7/17/2017 1:41:42 PM [HPACS] 0000,0800 2 US DataSetType 257
    7/17/2017 1:41:42 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    7/17/2017 1:41:42 PM [HPACS] Cancel request
    7/17/2017 1:41:48 PM [HPACS] Protocol error 0 in PDU:Read
    7/17/2017 1:41:48 PM [HPACS] UPACS THREAD 9: ENDED AT: Mon Jul 17 13:41:48 2017
    7/17/2017 1:41:48 PM [HPACS] UPACS THREAD 9: TOTAL RUNNING TIME: 7 SECONDS


    Dicom.sql
    *WorkList*
    {
    { 0x0008, 0x0050, "AccessionNumber", 16, SQL_C_CHAR, DT_STR, "OBR.3" },
    { 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR, "PID.4" },
    { 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR, "PID.5" },
    { 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE, "PID.7" },
    { 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR, "PID.8" },


    { 0x0010, 0x2000, "MedicalAlerts", 64, SQL_C_CHAR, DT_STR, "---" },
    { 0x0010, 0x2110, "ContrastAllergies", 64, SQL_C_CHAR, DT_STR, "---" },
    { 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI, "---" },
    { 0x0032, 0x1032, "ReqPhysician", 64, SQL_C_CHAR, DT_STR, "OBR.16" },
    { 0x0032, 0x1060, "ReqProcDescription", 64, SQL_C_CHAR, DT_STR, "OBR.4.1" },


    { 0x0040, 0x0100, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },
    { 0x0008, 0x0060, "Modality", 16, SQL_C_CHAR, DT_STR, "OBR.21" },
    { 0x0032, 0x1070, "ReqContrastAgent", 64, SQL_C_CHAR, DT_STR, "---" },
    { 0x0040, 0x0001, "ScheduledAE", 16, SQL_C_CHAR, DT_STR, "---" },
    { 0x0040, 0x0002, "StartDate", 8, SQL_C_DATE, DT_DATE, "OBR.7.DATE" },
    { 0x0040, 0x0003, "StartTime", 16, SQL_C_CHAR, DT_TIME, "OBR.7.TIME" },
    { 0x0040, 0x0006, "PerfPhysician", 64, SQL_C_CHAR, DT_STR, "---" },
    { 0x0040, 0x0007, "SchedPSDescription", 64, SQL_C_CHAR, DT_STR, "---" },
    { 0x0040, 0x0009, "SchedPSID", 16, SQL_C_CHAR, DT_STR, "OBR.4" },
    { 0x0040, 0x0010, "SchedStationName", 16, SQL_C_CHAR, DT_STR, "OBR.24" },
    { 0x0040, 0x0011, "SchedPSLocation", 16, SQL_C_CHAR, DT_STR, "---" },
    { 0x0040, 0x0012, "PreMedication", 64, SQL_C_CHAR, DT_STR, "---" },
    { 0x0040, 0x0400, "SchedPSComments", 64, SQL_C_CHAR, DT_STR, "---" },
    { 0x0040, 0x0008, "SchedProtCode", 128, SQL_C_CHAR, DT_STR, "OBR.4.1" },
    { 0x0040, 0x0100, "---------", 0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },



    { 0x0040, 0x1001, "ReqProcID", 16, SQL_C_CHAR, DT_STR, "OBR.4.0" },
    { 0x0040, 0x1003, "ReqProcPriority", 16, SQL_C_CHAR, DT_STR, "OBR.27 }
    }


    On querying the PACS Server, all the required records were shown but Patient Age and Schedule Protocol Code is not shown on Agfa CR whereas they do exist in the database.


    Please also guide me about the OBR,4.0 and PID,5 stuff that comes in the end of worklist table. If i want to add more columns in the worklist table will you please guide me.


    --HM

    Thanks for your prompt reply. But i want to delete some images from MAG0 for example say i deleted images and created a space of 90GB. Now i want to move same amount of data (older studies) from MAG1 to MAG0 but the data that is to be moved should be around 90GB or less than that. My deletion script works automatically but i have to move studies manually and update their links in database also. I just want to automate this whole process.


    --HM

    Hi


    I had read the user manual but i cannot find my answer. I wanted to setup conquest in such a way that two servers are running in parallel and both of them are receiving images. Is there any way that both servers share same mysql database and image location for storage.


    Please guide.



    --HM

    You are right the calling AE can tell me which user is performing Q/R on the server. But here in my setup the juniors doctors when free randomly queries the PACS and retrieve the images which are not of their concern. Sometimes they also take the picture of the scan from their camera and use them in their presentation without our knowledge or prior approval. Thats why i am working on this logging mechanism.


    So, that whenever a user is caught with such act we can show him/her that what they were Q/R and what Patient Scans they retrieve.


    --HM

    Hi


    When my doctor queries Conquest, it shows the query result but if doesn't shows/populate the Study Description Column of Vitrea Workstation. But when the study is retrieved the Study Description column shows the description.


    Screenshot attached.


    --HM

    You mean, if the user queried the PACS on Patient Name then data tags the subject tag information not the rest of the tags?


    Is there any way to get the remaining tags and beside this approach is there any other way to audit what users are Q/R from PACS.


    --HM

    Hi


    I am working on trying to log every Query and Retrieve made by user on Conquest PACS Server in database. For testing purpose i am just trying to log the Query function first.


    my dicom,in files look like this:-


    [lua]
    QueryConverter0 = dofile('query.lua')


    query.lua look like


    --Get the Patient ID
    local PatientID = Data.PatientID


    --Get the Patient Name
    local Name = Data.PatientName


    --Get the Accession Number
    local AccessionNo = Data.AccessionNumber


    --Get the IP Address
    local IP = Association.ConnectedIP


    --Get the Called AET
    local CalledAET = Association.Called


    --Get the Calling AET
    local CallingAET = Association.Calling


    --Get Study Description
    local desc = Data.StudyDescription


    --Get Modality
    local modality = Data.Modality


    --Get the Current Date
    date = os.date('%Y'..'/%m/'..'%d')


    --Get the current Time
    local time = os.date("*t")
    time = ("%02d:%02d:%02d"):format(time.hour, time.min, time.sec)


    print ("Time is "..time)
    print ("Date is "..date)
    print ("Called AET is "..CalledAET)
    print ("Calling AET is "..CallingAET)
    print ("Patient ID is"..PatientID)
    print(" Patient Name is"..Data.PatientName)
    print ("IP Address is"..IP)
    print ("Study Description is "..desc)
    print (" Modality is "..modality)


    and Conquest console looks like


    PACS] UPACS THREAD 2: STARTED AT: Sun May 14 18:48:35 2017
    [PACS] Calling Application Title : "RADIANT "
    [PACS] Called Application Title : "KPACS "
    [PACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384
    [PACS] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
    [PACS] Time is 18:48:35
    [PACS] Date is 2017/05/14
    [PACS] Called AET is KPACS
    [PACS] Calling AET is RADIANT
    [PACS] Patient ID is*A1234*
    [PACS] Patient Name is
    [PACS] IP Address is0.0.0.0
    [PACS] Study Description is
    [PACS] *** lua run error db.lua:40: attempt to concatenate local 'modality' (a nil value) in 'dofile('db.lua')'
    [PACS] (StudyRootQuery) search level: STUDY
    [PACS] C-Find (StudyRoot) located 1 records
    [PACS] UPACS THREAD 2: ENDED AT: Sun May 14 18:48:35 2017
    [PACS] UPACS THREAD 2: TOTAL RUNNING TIME: 0 SECONDS


    Issue is that i am not getting the IP Address of the Calling Client, Patient Name, Study Description and Modality.
    If i made a query on basis of date then the script only shows the data of the first record and in end it shows that 36 studies found. Not all the data is shown.


    Please guide why the above mentioned data is not displaying and secondly how can i log all the queries that are made to the server. And secondly, can i use the same script with the name retrieve.lua and will it shows the data of retrieve query results.


    In simple i wanted to made an Audit report which can be submitted to Management as required and when needed.


    --HM

    Thanks for your prompt reply.
    I have read in the manual about dbquery. If i want to create a complex query then i have to use sql statement??The SQL Query remains the same but the only difference is that i have to make the whole SQL Query String and then pass it to sql().


    --HM