SOP Instance is not unique

  • Strange issue yesterday when a study would not go through. Patient information identical to a previous study, although given an unique ID number. These are the applicable lines from the server log:


    [SIMPLEDICOM] Calling Application Title : "SCU "
    [SIMPLEDICOM] Called Application Title : "SIMPLEDICOM "
    [SIMPLEDICOM] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 32768
    [SIMPLEDICOM] Presentation Context 0 "1.2.840.10008.5.1.4.1.1.1" 1
    [SIMPLEDICOM] ***SQLITEExec error: column SOPInstanc is not unique
    [SIMPLEDICOM] ***Error saving to SQL: Fonger__Jennifer\1.2.392.200036.9125.3.251851094179.64746845669.6002058_1001_001001_14019105513c8a.dcm
    [SIMPLEDICOM] ***SQLITEExec error: column SOPInstanc is not unique
    [SIMPLEDICOM] ***Error saving to SQL: Fonger__Jennifer\1.2.392.200036.9125.3.251851094179.64746845669.6002059_1002_001002_14019105523c8b.dcm
    [SIMPLEDICOM] UPACS THREAD 33562: ENDED AT: Wed Jun 04 12:35:52 2014
    [SIMPLEDICOM] UPACS THREAD 33562: TOTAL RUNNING TIME: 2 SECONDS


    Any suggestions about what we can do to edit the patient correctly? Many thanks

    Nick Shaw DVM
    Shaw Pet and Equine Hospitals
    1782 Stelly's Cross Rd Saanichton BC Canada
    V8M 1S8

  • Maybe I was not being too clear - the patient ID and other info is identical for this and the previous study. It is only the study ID that is different. Thanks for your help.

    Nick Shaw DVM
    Shaw Pet and Equine Hospitals
    1782 Stelly's Cross Rd Saanichton BC Canada
    V8M 1S8

  • Thanks Marcel - any ideas about how we could fix this to get the study through? Our software allows us to change the study ID and patient info, but that's about all.

    Nick Shaw DVM
    Shaw Pet and Equine Hospitals
    1782 Stelly's Cross Rd Saanichton BC Canada
    V8M 1S8

  • Hi,


    temp add newuids to an importconverter and resend the data.


    or this might work automatically (assuming you have an incoming folder)


    [lua]
    RejectedImageConverter0 = script('newuids'); Data:write('c:\\dicomserver\\incoming\\'..Data.SOPInstanceUIDs)


    Marcel

Participate now!

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