Series Details are not populated

  • Hi


    I am facing a problem i getting series details of MRI Studies.


    When my doctor query PACS Server from ClearCanvas Workstation v 2.0 & 13.2; and click on Series Details. No information is shown. Whereas details of same study is shown in Efilm and Radiant Workstation.





    Please guide how to fix this issue.


    --HM

  • Study Description value is NULL in DICOMSTUDIES

    Series Descriptio value is NULL in DICOMSERIES


    Server log is attached.


    HPACS] UPACS THREAD 19: STARTED AT: Tue Aug 24 22:51:27 2021

    [HPACS] A-ASSOCIATE-RQ Packet Dump

    [HPACS] Calling Application Title : "RADIANT "

    [HPACS] Called Application Title : "HPACS "

    [HPACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 116794

    [HPACS] Number of Proposed Presentation Contexts: 1

    [HPACS] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1

    [HPACS] Server Command := 0020

    [HPACS] Message ID := 0001

    [HPACS] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.2.2.1"

    [HPACS] 0000,0100 2 US CommandField 32

    [HPACS] 0000,0110 2 US MessageID 1

    [HPACS] 0000,0700 2 US Priority 0

    [HPACS] 0000,0800 2 US DataSetType 514

    [HPACS] 0002,0010 19 UI TransferSyntaxUID "1.2.840.10008.1.2.1"

    [HPACS] (StudyRootQuery) search level: STUDY

    [HPACS] 0002,0010 19 UI TransferSyntaxUID "1.2.840.10008.1.2.1"

    [HPACS] 0008,0005 10 CS SpecificCharacterSet "ISO_IR 192"

    [HPACS] 0008,0020 0 DA StudyDate (empty)

    [HPACS] 0008,0030 0 TM StudyTime (empty)

    [HPACS] 0008,0050 0 SH AccessionNumber (empty)

    [HPACS] 0008,0052 6 CS QueryRetrieveLevel "STUDY "

    [HPACS] 0008,0061 0 CS ModalitiesInStudy (empty)

    [HPACS] 0008,0062 0 UI SOPClassesInStudy (empty)

    [HPACS] 0008,0090 0 PN ReferringPhysicianNa (empty)

    [HPACS] 0008,1030 0 LO StudyDescription (empty)

    [HPACS] 0010,0010 0 PN PatientName (empty)

    [HPACS] 0010,0020 8 LO PatientID "123*"

    [HPACS] 0010,0030 0 DA PatientBirthDate (empty)

    [HPACS] 0010,0032 0 TM PatientBirthTime (empty)

    [HPACS] 0010,0040 0 CS PatientSex (empty)

    [HPACS] 0010,1010 0 AS PatientAge (empty)

    [HPACS] 0020,000d 0 UI StudyInstanceUID (empty)

    [HPACS] 0020,0010 0 SH StudyID (empty)

    [HPACS] 0020,1206 0 IS NumberOfStudyRelated (empty)

    [HPACS] 0020,1208 0 IS NumberOfStudyRelated (empty)

    [HPACS] Query On Study

    [HPACS] Queried item 0008 0005 is not in the database

    [HPACS] Queried item 0008 0062 is not in the database

    [HPACS] Queried item 0010 0032 is not in the database

    [HPACS] 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.PatientsAg, DICOMStudies.StudyInsta, DICOMStudies.StudyID

    [HPACS] Values: DICOMStudies.PatientID LIKE '123%'

    [HPACS] Tables: DICOMStudies

    [HPACS] Sorting (DICOMStudies.PatientNam) DoSort := 1

    [HPACS] Query On Series

    [HPACS] Issue Query on Columns: COUNT(1)

    [HPACS] Values: DICOMStudies.StudyDate = '20210824' and DICOMStudies.StudyTime = '101017' and (DICOMStudies.StudyModal = 'MR' or DICOMStudies.StudyModal LIKE 'MR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\MR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\MR') and DICOMStudies.PatientNam = 'ABC' and DICOMStudies.PatientID = '123' and DICOMStudies.PatientBir = '19770824' and DICOMStudies.PatientSex = 'M' and DICOMStudies.PatientsAg = '044Y' and DICOMStudies.StudyInsta = '1.2.392.200036.9116.4.2.7152.6705.20210824045707000.1.14' and DICOMStudies.StudyID = '30824' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta

    [HPACS] Tables: DICOMSeries, DICOMStudies

    [HPACS] Records = 10

    [HPACS] Query On Image

    [HPACS] Issue Query on Columns: COUNT(1)

    [HPACS] Values: DICOMStudies.StudyDate = '20210824' and DICOMStudies.StudyTime = '101017' and (DICOMStudies.StudyModal = 'MR' or DICOMStudies.StudyModal LIKE 'MR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\MR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\MR') and DICOMStudies.PatientNam = 'ABC' and DICOMStudies.PatientID = '123' and DICOMStudies.PatientBir = '19770824' and DICOMStudies.PatientSex = 'M' and DICOMStudies.PatientsAg = '044Y' and DICOMStudies.StudyInsta = '1.2.392.200036.9116.4.2.7152.6705.20210824045707000.1.14' and DICOMStudies.StudyID = '30824' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst

    [HPACS] Tables: DICOMImages, DICOMSeries, DICOMStudies

    [HPACS] Records = 165

    [HPACS] Records = 1

    [HPACS] First record of cleaned response:

    [HPACS] 0008,0020 8 DA StudyDate "20210824"

    [HPACS] 0008,0030 6 TM StudyTime "101017"

    [HPACS] 0008,0050 0 SH AccessionNumber (empty)

    [HPACS] 0008,0061 2 CS ModalitiesInStudy "MR"

    [HPACS] 0008,0090 0 PN ReferringPhysicianNa (empty)

    [HPACS] 0008,1030 0 LO StudyDescription (empty)

    [HPACS] 0010,0010 12 PN PatientName "ABC "

    [HPACS] 0010,0020 8 LO PatientID "123 "

    [HPACS] 0010,0030 8 DA PatientBirthDate "19770824"

    [HPACS] 0010,0040 2 CS PatientSex "M "

    [HPACS] 0010,1010 4 AS PatientAge "044Y"

    [HPACS] 0020,000d 56 UI StudyInstanceUID "1.2.392.200036.9116.4.2.7152.6705.20210824045707000.1.14"

    [HPACS] 0020,0010 6 SH StudyID "30824 "

    [HPACS] 0020,1206 2 IS NumberOfStudyRelated "10"

    [HPACS] 0020,1208 4 IS NumberOfStudyRelated "165 "

    [HPACS] C-Find (StudyRoot) located 1 records

    [HPACS] UPACS THREAD 19: ENDED AT: Tue Aug 24 22:51:27 2021

    [HPACS] UPACS THREAD 19: TOTAL RUNNING TIME: 0 SECONDS



    It means that MRI Machine is not sending complete details with a study

  • Attached are the screnshots from efilm series details.


    Main Search Windows (Local Storage)





    Series Details when images are loaded



    If you check here Series Description is shown whereas this is the same patient whose details are not shown in ClearCanvas Workstation.



    Same Server log no difference


    HPACS]

    [HPACS] UPACS THREAD 8: STARTED AT: Wed Aug 25 13:30:41 2021

    [HPACS] A-ASSOCIATE-RQ Packet Dump

    [HPACS] Calling Application Title : "NX_DEFAULT1 "

    [HPACS] Called Application Title : "HPACS "

    [HPACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 65542

    [HPACS] Number of Proposed Presentation Contexts: 1

    [HPACS] Presentation Context 0 "1.2.840.10008.5.1.4.1.1.1.1" 1

    [HPACS] Server Command := 0001

    [HPACS] Message ID := 0001

    [HPACS] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.1.1"

    [HPACS] 0000,0100 2 US CommandField 1

    [HPACS] 0000,0110 2 US MessageID 1

    [HPACS] 0000,0700 2 US Priority 0

    [HPACS] 0000,0800 2 US DataSetType 1

    [HPACS] 0000,1000 58 UI AffectedSOPInstanceU "1.3.51.0.7.14046292882.22893.52558.48848.34483.31810.46687"

    [HPACS] 0002,0010 19 UI TransferSyntaxUID "1.2.840.10008.1.2.1"

    [HPACS] Importconverter0.0: sets preferred storage to MAG1

    [HPACS] FreeStore Left 260784 on d:\

    [HPACS] FreeStore Left 1792010 on F:\

    [HPACS] Written file: F:\DICOM Images\DX\20210825\A2786588-1-(^NASREEN_BEGUM)\Cervical_Spine_AP\00010001.dcm

    [HPACS] UPACS THREAD 8: ENDED AT: Wed Aug 25 13:30:43 2021

    [HPACS] UPACS THREAD 8: TOTAL RUNNING TIME: 2 SECONDS

    [HPACS] Connected by address: 3b6664c6

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #1 = '1.2.840.10008.1.2.1'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #1 = '1.2.840.10008.1.2.1'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #1 = '1.2.840.10008.1.2.1'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #1 = '1.2.840.10008.1.2.1'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #1 = '1.2.840.10008.1.2.1'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #0 = '1.2.840.10008.1.2'

    [HPACS] Testing transfer: '1.2.840.10008.1.2.1' against list #1 = '1.2.840.10008.1.2.1'

    [HPACS]

    [HPACS] UPACS THREAD 9: STARTED AT: Wed Aug 25 13:30:59 2021

    [HPACS] A-ASSOCIATE-RQ Packet Dump

    [HPACS] Calling Application Title : "WKSCTMRI"

    [HPACS] Called Application Title : "HPACS"

    [HPACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 64234

    [HPACS] Number of Proposed Presentation Contexts: 6

    [HPACS] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.3.1" 1

    [HPACS] Presentation Context 1 "1.2.840.10008.5.1.4.1.2.3.2" 1

    [HPACS] Presentation Context 2 "1.2.840.10008.5.1.4.1.2.2.1" 1

    [HPACS] Presentation Context 3 "1.2.840.10008.5.1.4.1.2.2.2" 1

    [HPACS] Presentation Context 4 "1.2.840.10008.5.1.4.1.2.1.1" 1

    [HPACS] Presentation Context 5 "1.2.840.10008.5.1.4.1.2.1.2" 1

    [HPACS] Server Command := 0020

    [HPACS] Message ID := 0004

    [HPACS] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.2.2.1"

    [HPACS] 0000,0100 2 US CommandField 32

    [HPACS] 0000,0110 2 US MessageID 4

    [HPACS] 0000,0700 2 US Priority 0

    [HPACS] 0000,0800 2 US DataSetType 0

    [HPACS] 0002,0010 19 UI TransferSyntaxUID "1.2.840.10008.1.2.1"

    [HPACS] (StudyRootQuery) search level: STUDY

    [HPACS] 0002,0010 19 UI TransferSyntaxUID "1.2.840.10008.1.2.1"

    [HPACS] 0008,0020 0 DA StudyDate (empty)

    [HPACS] 0008,0030 0 TM StudyTime (empty)

    [HPACS] 0008,0050 0 SH AccessionNumber (empty)

    [HPACS] 0008,0052 6 CS QueryRetrieveLevel "STUDY "

    [HPACS] 0008,0061 0 CS ModalitiesInStudy (empty)

    [HPACS] 0008,0080 0 LO InstitutionName (empty)

    [HPACS] 0008,0090 0 PN ReferringPhysicianNa (empty)

    [HPACS] 0008,1030 0 LO StudyDescription (empty)

    [HPACS] 0008,1040 0 LO InstitutionalDepartm (empty)

    [HPACS] 0010,0010 0 PN PatientName (empty)

    [HPACS] 0010,0020 8 LO PatientID "123*"

    [HPACS] 0010,0030 0 DA PatientBirthDate (empty)

    [HPACS] 0010,0040 0 CS PatientSex (empty)

    [HPACS] 0020,000d 0 UI StudyInstanceUID (empty)

    [HPACS] 0020,0010 0 SH StudyID (empty)

    [HPACS] Query On Study

    [HPACS] Queried item 0008 0080 is not in the database

    [HPACS] Queried item 0008 1040 is not in the database

    [HPACS] 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

    [HPACS] Values: DICOMStudies.PatientID LIKE '123%'

    [HPACS] Tables: DICOMStudies

    [HPACS] Sorting (DICOMStudies.PatientNam) DoSort := 1

    [HPACS] Records = 1

    [HPACS] First record of cleaned response:

    [HPACS] 0008,0020 8 DA StudyDate "20210824"

    [HPACS] 0008,0030 6 TM StudyTime "101017"

    [HPACS] 0008,0050 0 SH AccessionNumber (empty)

    [HPACS] 0008,0061 2 CS ModalitiesInStudy "MR"

    [HPACS] 0008,0090 0 PN ReferringPhysicianNa (empty)

    [HPACS] 0008,1030 10 LO StudyDescription "MR Pelvis "

    [HPACS] 0010,0010 12 PN PatientName "ABC "

    [HPACS] 0010,0020 8 LO PatientID "123 "

    [HPACS] 0010,0030 8 DA PatientBirthDate "19770824"

    [HPACS] 0010,0040 2 CS PatientSex "M "

    [HPACS] 0020,000d 56 UI StudyInstanceUID "1.2.392.200036.9116.4.2.7152.6705.20210824045707000.1.14"

    [HPACS] 0020,0010 6 SH StudyID "30824 "

    [HPACS] C-Find (StudyRoot) located 1 records

    [HPACS] UPACS THREAD 9: ENDED AT: Wed Aug 25 13:30:59 2021

    [HPACS] UPACS THREAD 9: TOTAL RUNNING TIME: 0 SECONDS





    --HM

  • But when series description and study description are not available in database how EFILM Workstation shows them ???? Question is from where they are getting this info and display the correct one....

  • Hi,


    Data can come from query, or from the images. Maybe efilm already has the images?


    In an example images I found this information:


    0008,1030 10 LO StudyDescription "cerv+head "

    0008,103e 8 LO SeriesDescription "eT1W_SE "

    0018,1030 8 LO ProtocolName "eT1W_SE "


    These are all in stored the database and can be queried.


    Other information is in private elements that are in the images but not in the database. Maybe efilm combines a few of those elements from the IMAGES?


    Marcel

  • No, it was fresh pull from PACS not already available on efilm.


    0008,1030 10 LO StudyDescription "cerv+head "

    0008,103e 8 LO SeriesDescription "eT1W_SE "

    0018,1030 8 LO ProtocolName "eT1W_SE "


    Tes you are correct. It means that we have to update SeriesDescription with ProtocolName text in case of MRI only.


    My lua script will be (importconverter)


    1. Check if Modality is MR

    2 Get the Protocol Name

    3. Update Series Description with Protocol Name



    Is this correct???

  • Yes you can do that, or you can try as follows without changing the images:


    [lua]

    QueryConverter0 = if Data.SeriesDescription and not Data.ProtocolName then Data.ProtocolName="" end

    QueryResultConverter0 = if Data.SeriesDescription and Data.ProtocolName=="" then Data.ProtocolName=Data.SeriesDescription end


    It may slow down queries though


    Marcel

  • Thanks i will test the lua script and update you.


    BUt for testing purpose, i manually update the Series Description column with Protocol Name column in Dicomseries table.


    Result on Querying PACS



    But when images are retrieved at ClearCanvas Workstation





    DICOM Attributes as per ClearCanvas Workstation. Series Description is again Blank.


  • Yes, the images and the database have different storage, they are synchronised only on image store. So this suggest you have to populate it on import of the images, as you proposed.


    e.g.


    [lua]

    ImportConverter0 = if (Data.SeriesDescription or "") == "" and (Data.ProtocolName or "") == "" then Data.ProtocolName=Data.SeriesDescription end


    The or "" makes it "" if it does not exist or is empty.


    Marcel

  • Hi


    This script doesn't update the Description column


    [lua]

    ImportConverter0 = if (Data.SeriesDescription or "") == "" and (Data.ProtocolName or "") == "" then Data.ProtocolName=Data.SeriesDescription end


    Is this OKIE


    [lua]

    ImportConverter0 = storage MAG1

    ImportConverter1 = if Data.Modality == 'MR' then Data.ProtocolName = Data.SeriesDescription end

Participate now!

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