Problem in dicomstudies table

  • Hi,

    I have a different exams that have some studyinsta so it cannot be stored.

    So I would like to change the studyinsta for the old exam and regenerate it.

    How to change the studyinsta for the old exam?



    Best regards

  • Hi,


    you can script any change that you want. The important question is what you want. The safest option is to change all UIDs, but you then need to know for sure there are only two studies that clash. If you change the study UID you can in principle split every image into a new study and I am sure that you do not want that.


    What caused the clash in the first place?


    Marcel

  • Here I want to regenerate the exams who has the same studyinsta and here is the log:

    All functions of this page are optional.


    ------------------- Regen device MAG9 --------------------

    [CLINISYS23] ---------- Start archival operation -----------

    [CLINISYS23] Regen single device: MAG9

    [CLINISYS23] [Regen] I:\recup\22E04524\1.3.76.6.1.2.5.2.6479.3.44571064975061798_0001_000001_1641834953dfaf.dcm -SUCCESS

    [CLINISYS23] [Regen] I:\recup\22E04524\1.3.76.6.1.2.5.2.6479.3.44571064997061805_0002_000001_1641834953dfb0.dcm -SUCCESS

    [CLINISYS23] [Regen] I:\recup\22E04524\1.3.76.6.1.2.5.2.6479.3.44571065011061810_0003_000001_1641834954dfb1.dcm -SUCCESS

    [CLINISYS23] [Regen] I:\recup\22E04524\1.3.76.6.1.2.5.2.6479.3.44571065037061817_0004_000001_1641834955dfb2.dcm -SUCCESS

    [CLINISYS23] ***Inconsistent PatientBir in DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='19960229', New='20040404'

    [CLINISYS23] ***Refused to enter inconsistent link PatientID into DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='22E04524', Refused='22G53330'

    [CLINISYS23] ***[Regen] I:\recup\22G53330\1.3.76.6.1.2.5.2.6479.3.44875047297211350_0001_000001_166808251103ff.dcm -FAILED: Error SQL Add

    [CLINISYS23] ***Inconsistent PatientBir in DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='19960229', New='20040404'

    [CLINISYS23] ***Refused to enter inconsistent link PatientID into DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='22E04524', Refused='22G53330'

    [CLINISYS23] ***[Regen] I:\recup\22G53330\1.3.76.6.1.2.5.2.6479.3.44875047297211350_0001_000001_16680838070b4f.dcm -FAILED: Error SQL Add

    [CLINISYS23] ***Inconsistent PatientBir in DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='19960229', New='20040404'

    [CLINISYS23] ***Refused to enter inconsistent link PatientID into DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='22E04524', Refused='22G53330'

    [CLINISYS23] ***[Regen] I:\recup\22G53330\1.3.76.6.1.2.5.2.6479.3.44875047297211350_0001_000001_16680844980f35.dcm -FAILED: Error SQL Add

    [CLINISYS23] ***Inconsistent PatientBir in DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='19960229', New='20040404'

    [CLINISYS23] ***Refused to enter inconsistent link PatientID into DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='22E04524', Refused='22G53330'

    [CLINISYS23] ***[Regen] I:\recup\22G53330\1.3.76.6.1.2.5.2.6479.3.44875047297211350_0001_000001_16680851800f36.dcm -FAILED: Error SQL Add

    [CLINISYS23] ***Inconsistent PatientBir in DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='19960229', New='20040404'

    [CLINISYS23] ***Refused to enter inconsistent link PatientID into DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='22E04524', Refused='22G53330'

    [CLINISYS23] ***[Regen] I:\recup\22G53330\1.3.76.6.1.2.5.2.6479.3.44875047297211350_0001_000001_166808749112e7.dcm -FAILED: Error SQL Add

    [CLINISYS23] ***Inconsistent PatientBir in DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='19960229', New='20040404'

    [CLINISYS23] ***Refused to enter inconsistent link PatientID into DICOMStudies: PatientID = '22G53330' StudyInsta = '360.1.2205933', Old='22E04524', Refused='22G53330'

    [CLINISYS23] ***[Regen] I:\recup\22G53330\1.3.76.6.1.2.5.2.6479.3.44875047297211350_0001_000001_16681497781958.dcm -FAILED: Error SQL Add

    [CLINISYS23] Regeneration Complete

    [CLINISYS23] ---------- End of archival operation -----------

  • this error is occurred in server status log


    Importconverter0.0: sets preferred storage to MAG8

    11/11/2022 09:12:22 [CLINISYS23] ***Inconsistent PatientBir in DICOMStudies: PatientID = '22G53671' StudyInsta = '360.1.2206370', Old='19870112', New='19760815'

    11/11/2022 09:12:22 [CLINISYS23] ***Refused to enter inconsistent link PatientID into DICOMStudies: PatientID = '22G53671' StudyInsta = '360.1.2206370', Old='22E04926', Refused='22G53671'

    11/11/2022 09:12:22 [CLINISYS23] ***Error saving to SQL: 22G53671\1.3.76.6.1.2.5.2.6479.3.44876032202180741_0002_000001_16681543421abd.dcm



    The exam with PatientID = '22G53671' is stored but is not saved to sql because it has the same studyinsta of an Old PatientID ='22E04926

    so I can't see to the exam's images with viewer.

    how can I solve this problem

  • Hi,


    really you have to find the root problem which is not Conquest at all. You are trying to force two different patients into the same database row, which conquest rightfully refuses.


    But conquest can change anything in the data.


    For instance before (re)uploading the conflicting data (e.g. using drag and drop) try to add something like this in dicom.ini:


    [lua]

    RejectedImageConverter0=Data.PatientID=Data.PatientID..'fixed';script('newuids');retry()


    Here script('newuids') replaces all UIDs (like in anonymisation).

    Marcel

Participate now!

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