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.

Participate now!

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