Posts by ReneM

  • Store dicom file twice result in error.

    If I send a dicom file twice (same patient) I get an error.
    [CONQUESTSRV1]
    [CONQUESTSRV1] UPACS THREAD 14: STARTED AT: Mon Oct 19 15:03:56 2009
    [CONQUESTSRV1] Query Tables: DICOMImages
    [CONQUESTSRV1] Columns : ObjectFile, DeviceName
    [CONQUESTSRV1] Where : SOPInstanc = '1.2.276.0.7230010.3.1.4.864856086.7944.1255957631.3' AND ImagePat = '1234567'
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] FreeStore Left 3462 on C:\
    [CONQUESTSRV1] Add to Table: DICOMImages
    [CONQUESTSRV1] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImagePat, PatientNam, PatientBir, PatientSex, StudyDate, StudyTime, StudyID, StudyDescr, SeriesNumb, Modality, Manufactur, SeriesInst, AccessTime, ObjectFile, DeviceName
    [CONQUESTSRV1] Values: '1.2.276.0.7230010.3.1.4.864856086.7944.1255957631.3', '1.2.840.10008.5.1.4.1.1.66', '1', '1234567', 'maniqui IMRT FC65G (restored)', '19641130', 'Male', '20080305', '164138', 'Encounter1', 'Comment', '1', 'OT', 'RMOEIJES', '1.2.276.0.7230010.3.1.4.864856086.7944.1255957631.1', 1255957408, '1234567\1.2.276.0.7230010.3.1.4.864856086.7944.1255957631.1_0001_000001_1255957438000e.v2', 'MAG0'
    [CONQUESTSRV1] Query Tables: DICOMSeries
    [CONQUESTSRV1] Columns : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,PatientNam,PatientBir,PatientSex,StudyDate,StudyTime,StudyID,StudyDescr,StudyInsta
    [CONQUESTSRV1] Where : SeriesInst = '1.2.276.0.7230010.3.1.4.864856086.7944.1255957631.1' AND SeriesPat = '1234567'
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] Add to Table: DICOMSeries
    [CONQUESTSRV1] Columns: SeriesInst, SeriesNumb, Modality, Manufactur, ModelName, StationNam, Institutio, SeriesPat, PatientNam, PatientBir, PatientSex, StudyDate, StudyTime, StudyID, StudyDescr, AccessTime
    [CONQUESTSRV1] Values: '1.2.276.0.7230010.3.1.4.864856086.7944.1255957631.1', '1', 'OT', 'RMOEIJES', 'Pinnacle', 'Pinnacle', 'Seem2008', '1234567', 'maniqui IMRT FC65G (restored)', '19641130', 'Male', '20080305', '164138', 'Encounter1', 'Comment', 1255957408
    [CONQUESTSRV1] Query Tables: DICOMStudies
    [CONQUESTSRV1] Columns : StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,PatientNam,PatientBir,PatientSex,PatientID
    [CONQUESTSRV1] Where :
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] Add to Table: DICOMStudies
    [CONQUESTSRV1] Columns: StudyDate, StudyTime, StudyID, StudyDescr, ReferPhysi, StudyModal, PatientNam, PatientBir, PatientSex, PatientID, AccessTime
    [CONQUESTSRV1] Values: '20080305', '164138', 'Encounter1', 'Comment', 'ReferringPhysician', 'OT', 'maniqui IMRT FC65G (restored)', '19641130', 'Male', '1234567', 1255957408
    [CONQUESTSRV1] Query Tables: DICOMPatients
    [CONQUESTSRV1] Columns : PatientID,PatientNam,PatientBir,PatientSex
    [CONQUESTSRV1] Where : PatientID = '1234567'
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] Add to Table: DICOMPatients
    [CONQUESTSRV1] Columns: PatientID, PatientNam, PatientBir, PatientSex, AccessTime
    [CONQUESTSRV1] Values: '1234567', 'maniqui IMRT FC65G (restored)', '19641130', 'Male', 1255957408
    [CONQUESTSRV1] Written file: C:\ConQuest\Data\1234567\1.2.276.0.7230010.3.1.4.864856086.7944.1255957631.1_0001_000001_1255957438000e.v2
    [CONQUESTSRV1] UPACS THREAD 14: ENDED AT: Mon Oct 19 15:04:01 2009
    [CONQUESTSRV1] UPACS THREAD 14: TOTAL RUNNING TIME: 5 SECONDS



    [CONQUESTSRV1] Presentation Context 33 "1.2.840.10008.5.1.4.1.1.104.1" 0
    [CONQUESTSRV1] Query Tables: DICOMImages
    [CONQUESTSRV1] Columns : ObjectFile, DeviceName
    [CONQUESTSRV1] Where : SOPInstanc = '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.3' AND ImagePat = '1234567'
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] FreeStore Left 3422 on C:\
    [CONQUESTSRV1] Add to Table: DICOMImages
    [CONQUESTSRV1] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImagePat, PatientNam, PatientBir, PatientSex, StudyDate, StudyTime, StudyID, StudyDescr, SeriesNumb, Modality, Manufactur, SeriesInst, AccessTime, ObjectFile, DeviceName
    [CONQUESTSRV1] Values: '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.3', '1.2.840.10008.5.1.4.1.1.66', '1', '1234567', 'maniqui IMRT FC65G (restored)', '19641130', 'Male', '20080305', '164138', 'Encounter1', 'Comment', '1', 'OT', 'RMOEIJES', '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.1', 1255957504, '1234567\1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.1_0001_000001_1255957509000f.v2', 'MAG0'
    [CONQUESTSRV1] Query Tables: DICOMSeries
    [CONQUESTSRV1] Columns : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,PatientNam,PatientBir,PatientSex,StudyDate,StudyTime,StudyID,StudyDescr,StudyInsta
    [CONQUESTSRV1] Where : SeriesInst = '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.1' AND SeriesPat = '1234567'
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] Add to Table: DICOMSeries
    [CONQUESTSRV1] Columns: SeriesInst, SeriesNumb, Modality, Manufactur, ModelName, StationNam, Institutio, SeriesPat, PatientNam, PatientBir, PatientSex, StudyDate, StudyTime, StudyID, StudyDescr, AccessTime
    [CONQUESTSRV1] Values: '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.1', '1', 'OT', 'RMOEIJES', 'Pinnacle', 'Pinnacle', 'Seem2008', '1234567', 'maniqui IMRT FC65G (restored)', '19641130', 'Male', '20080305', '164138', 'Encounter1', 'Comment', 1255957504
    [CONQUESTSRV1] Query Tables: DICOMStudies
    [CONQUESTSRV1] Columns : StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,PatientNam,PatientBir,PatientSex,PatientID
    [CONQUESTSRV1] Where :
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] ***Unable to update record
    [CONQUESTSRV1] ***SQL:
    [CONQUESTSRV1] ***Error: 0: :
    [CONQUESTSRV1] Delete Record Table: DICOMSeries
    [CONQUESTSRV1] Where : SeriesInst = '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.1' and SeriesNumb = '1' and Modality = 'OT' and Manufactur = 'RMOEIJES' and ModelName = 'Pinnacle' and StationNam = 'Pinnacle' and Institutio = 'Seem2008' and SeriesPat = '1234567' and PatientNam = 'maniqui IMRT FC65G (restored)' and PatientBir = '19641130' and PatientSex = 'Male' and StudyDate = '20080305' and StudyTime = '164138' and StudyID = 'Encounter1' and StudyDescr = 'Comment' and StudyInsta = ''
    [CONQUESTSRV1] Query Tables: DICOMSeries
    [CONQUESTSRV1] Columns :
    [CONQUESTSRV1] Where : SeriesInst = '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.1' and SeriesNumb = '1' and Modality = 'OT' and Manufactur = 'RMOEIJES' and ModelName = 'Pinnacle' and StationNam = 'Pinnacle' and Institutio = 'Seem2008' and SeriesPat = '1234567' and PatientNam = 'maniqui IMRT FC65G (restored)' and PatientBir = '19641130' and PatientSex = 'Male' and StudyDate = '20080305' and StudyTime = '164138' and StudyID = 'Encounter1' and StudyDescr = 'Comment' and StudyInsta = ''
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] Delete Record Table: DICOMImages
    [CONQUESTSRV1] Where : SOPInstanc = '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.3' and SOPClassUI = '1.2.840.10008.5.1.4.1.1.66' and ImageNumbe = '1' and ImagePat = '1234567' and PatientNam = 'maniqui IMRT FC65G (restored)' and PatientBir = '19641130' and PatientSex = 'Male' and StudyInsta = '' and StudyDate = '20080305' and StudyTime = '164138' and StudyID = 'Encounter1' and StudyDescr = 'Comment' and SeriesNumb = '1' and Modality = 'OT' and Manufactur = 'RMOEIJES' and SeriesInst = '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.1'
    [CONQUESTSRV1] Query Tables: DICOMImages
    [CONQUESTSRV1] Columns :
    [CONQUESTSRV1] Where : SOPInstanc = '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.3' and SOPClassUI = '1.2.840.10008.5.1.4.1.1.66' and ImageNumbe = '1' and ImagePat = '1234567' and PatientNam = 'maniqui IMRT FC65G (restored)' and PatientBir = '19641130' and PatientSex = 'Male' and StudyInsta = '' and StudyDate = '20080305' and StudyTime = '164138' and StudyID = 'Encounter1' and StudyDescr = 'Comment' and SeriesNumb = '1' and Modality = 'OT' and Manufactur = 'RMOEIJES' and SeriesInst = '1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.1'
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] ***Error saving to SQL: 1234567\1.2.276.0.7230010.3.1.4.864856086.8207.1255958148.1_0001_000001_1255957509000f.v2
    [CONQUESTSRV1] UPACS THREAD 15: ENDED AT: Mon Oct 19 15:05:09 2009
    [CONQUESTSRV1] UPACS THREAD 15: TOTAL RUNNING TIME: 2 SECONDS



    I must have something wrong, but I cannot figure this out.
    ( I added "RawDataStorage 1.2.840.10008.5.1.4.1.1.66 sop" to dgatesop.lst to make it work as far as
    accepting one dicom file ;) ) "



    Update:
    It seems I am able only to send one dicom file after clearing the database. After succesfully transfer of one file, no other file will be accepted anymore.