Failed MYSQLExec Error Duplicate entry

  • Hi. When i send a study from Fuji CR conquest was showing follow error:


    AccessTime, ObjectFile, DeviceName
    [UNIMED] Values: '1.2.392.200036.9125.4.0.302973459.359465752.3631445015', '1.2.840.10008.5.1.4.1.1.1', '4', '20131118', '171213.126', '20131118', '171212.985', '042', '1', 'MONOCHROME1', '4280', '3520', '10', 'DERIVED\\PRIMARY\\POST_PROCESSED\\100000', '91227', '1.2.392.200036.9125.3.24311521623116.64730509408.487632', 1384861632, '91227\\1.2.392.200036.9125.3.24311521623116.64730509408.487632_0004_000004_13848616560094.dcm', 'MAG0'
    [UNIMED] ***Failed MYSQLExec : INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, AcqNumber, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.2.392.200036.9125.4.0.302973459.359465752.3631445015', '1.2.840.10008.5.1.4.1.1.1', '4', '20131118', '171213.126', '20131118', '171212.985', '042', '1', 'MONOCHROME1', '4280', '3520', '10', 'DERIVED\\PRIMARY\\POST_PROCESSED\\100000', '91227', '1.2.392.200036.9125.3.24311521623116.64730509408.487632', 1384861632, '91227\\1.2.392.200036.9125.3.24311521623116.64730509408.487632_0004_000004_13848616560094.dcm', 'MAG0')
    [UNIMED] ***Error: Duplicate entry '1.2.392.200036.9125.4.0.302973459.359465752.3631445015' for key 'PRIMARY'
    [UNIMED] ***Unable to DB.Add()
    [UNIMED] ***SQL: INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, AcqNumber, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.2.392.200036.9125.4.0.302973459.359465752.3631445015', '1.2.840.10008.5.1.4.1.1.1', '4', '20131118', '171213.126', '20131118', '171212.985', '042', '1', 'MONOCHROME1', '4280', '3520', '10', 'DERIVED\\PRIMARY\\POST_PROCESSED\\100000', '91227', '1.2.392.200036.9125.3.24311521623116.64730509408.487632', 1384861632, '91227\\1.2.392.200036.9125.3.24311521623116.64730509408.487632_0004_000004_13848616560094.dcm', 'MAG0')
    [UNIMED] ***Error: Duplicate entry '1.2.392.200036.9125.4.0.302973459.359465752.3631445015' for key 'PRIMARY'
    [UNIMED] ***Error saving to SQL: 91227\1.2.392.200036.9125.3.24311521623116.64730509408.487632_0004_000004_13848616560094.dcm
    [UNIMED] Server Command := 0001
    [UNIMED] Message ID := 60ab
    [UNIMED] 0000,0002 26 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.1"
    [UNIMED] 0000,0100 2 US CommandField 1
    [UNIMED] 0000,0110 2 US MessageID 24747
    [UNIMED] 0000,0700 2 US Priority 0
    [UNIMED] 0000,0800 2 US DataSetType 258
    [UNIMED] 0000,1000 54 UI AffectedSOPInstanceU "1.2.392.200036.9125.4.0.302973971.388694808.3631445015"
    [UNIMED] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    [UNIMED] Importconverter1.0 executes: set 0008,0080 to "UNIMEDFOZ"
    [UNIMED] Query Tables: DICOMImages
    [UNIMED] Columns : ObjectFile, DeviceName
    [UNIMED] Where : SOPInstanc = '1.2.392.200036.9125.4.0.302973971.388694808.3631445015' AND ImagePat = '91227'
    [UNIMED] Order : (null)
    [UNIMED] FreeStore Left 427523 on C:\
    [UNIMED] Add to Table: DICOMImages
    [UNIMED] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, AcqNumber, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, SeriesInst,





    My question is; How o solve this? and this behavior break another study coming from Fuji CR? All the study will stop if this error happening?

Participate now!

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