QUERY/RETRIEVE ISSUE

  • Hello Marcel,


    am from chile, and i have a litle problem with a query/retrieve from efilm.


    look, when efilm make a query by modality, ex: CR, the conquest server tellme this:


    [OSSIS] UPACS THREAD 10: STARTED AT: Thu Jun 28 17:17:37 2012
    [OSSIS] A-ASSOCIATE-RQ Packet Dump
    [OSSIS] Calling Application Title : "OSSIS_RX"
    [OSSIS] Called Application Title : "OSSIS"
    [OSSIS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 64234
    [OSSIS] Number of Proposed Presentation Contexts: 6
    [OSSIS] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.3.1" 1
    [OSSIS] Presentation Context 1 "1.2.840.10008.5.1.4.1.2.3.2" 1
    [OSSIS] Presentation Context 2 "1.2.840.10008.5.1.4.1.2.2.1" 1
    [OSSIS] Presentation Context 3 "1.2.840.10008.5.1.4.1.2.2.2" 1
    [OSSIS] Presentation Context 4 "1.2.840.10008.5.1.4.1.2.1.1" 1
    [OSSIS] Presentation Context 5 "1.2.840.10008.5.1.4.1.2.1.2" 1
    [OSSIS] Server Command := 0020
    [OSSIS] Message ID := 0003
    [OSSIS] (StudyRootQuery) search level: STUDY
    [OSSIS] Query On Study
    [OSSIS] Queried item 0008 0080 is not in the database
    [OSSIS] Queried item 0008 1040 is not in the database
    [OSSIS] 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
    [OSSIS] Values: DICOMStudies.StudyDate >= E'20120628' and DICOMStudies.StudyDate <= '20120628' and (DICOMStudies.StudyModal = E'CR' or DICOMStudies.StudyModal LIKE ''CR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\'CR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\'CR')
    [OSSIS] Tables: DICOMStudies
    [OSSIS] Sorting (DICOMStudies.PatientNam) DoSort := 1
    [OSSIS] ***Failed SQLExecDirect : SELECT DISTINCT DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID FROM DICOMStudies WHERE DICOMStudies.StudyDate >= E'20120628' and DICOMStudies.StudyDate <= '20120628' and (DICOMStudies.StudyModal = E'CR' or DICOMStudies.StudyModal LIKE ''CR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\'CR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\'CR') ORDER BY (DICOMStudies.PatientNam)
    [OSSIS] ***Error: 7: 42601: ERROR: error de sintaxis en o cerca de «CR»; Error while executing the query
    [OSSIS] ***Error: 7: 42601: ERROR: error de sintaxis en o cerca de «CR»; Error while executing the query
    [OSSIS] C-Find (StudyRoot) located 0 records
    [OSSIS] UPACS THREAD 10: ENDED AT: Thu Jun 28 17:17:37 2012
    [OSSIS] UPACS THREAD 10: TOTAL RUNNING TIME: 0 SECONDS



    may you help me please.


    PD: with 1.4.15 version not happend. sorry for my english, is very basic.

  • Hi,


    can you post your dicom.ini file for extra information? Then I can reproduce the issue.


    In any case, changing this line in dicom.sql:


    { 0x0008, 0x0061, "StudyModality", 64, SQL_C_CHAR, DT_MSTR },


    Into


    { 0x0008, 0x0061, "StudyModality", 64, SQL_C_CHAR, DT_STR },


    Will partly solve the issue: the StudyModality string can contain more than modality string (e.g. CT\RTSTRUCT\RTPLAN) and the bug is in the code expanding a query to let a query match CT RTSTRUCT and RTPLAN.


    Marcel

Participate now!

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