SMI/RdmpDicom

Load failures in HIC

Closed this issue · 1 comments

jas88 commented

|Mutilate failed on job Rdmp.Core.DataLoad.Engine.Job.DataLoadJob Mutilator was of type PrimaryKeyCollisionIsolationMutilation see InnerException for specifics|System.Exception: Supplemental (2 column) joins are not supported when resolving multi table primary key collisions
at Rdmp.Dicom.PipelineComponents.PrimaryKeyCollisionIsolationMutilation.BuildJoinOrder(Boolean isChecks)
at Rdmp.Dicom.PipelineComponents.PrimaryKeyCollisionIsolationMutilation.Mutilate(IDataLoadJob job)

jas88 commented

Resolved - RDMP has to be set up with right joins between study-series-instance, otherwise the manually-cascaded deletion process trips itself up.