Hi @ all,
i've a question about deleting studies from conquest.
A modality sent dicom images with false id's, names, ... . i retrieved these studies with kpacs, changed the demographics and i deleted the study from conquest, but it failed to send the study again from kpacs. i think conquest does not delete the uid, or? how can i delete and resend the same datasets without changing the uid? or is there a tool, within to change it?
kind regards,
christian
How did you delete the study? If you delete from the browser also the database entries (UIDs) should be deleted.
Marcel
hi,
i looked in the database browser and deleted the study. or should i choose delete patient?
christian
Hi,
I guess apparantly the deleting went wrong. Can you still see entries in the database? I know that conquest can have troubles with patientID's with certain characters in it. Can you show me the error when you try to send the modified data?
Marcel
Hi thats the Error on conquest while sending the images again
[NUKPACS] UPACS THREAD 1414: STARTED AT: Fri Feb 04 12:48:50 2011
[NUKPACS] A-ASSOCIATE-RQ Packet Dump
[NUKPACS] Calling Application Title : "NUKARZT"
[NUKPACS] Called Application Title : "NUKPACS"
[NUKPACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384
[NUKPACS] Number of Proposed Presentation Contexts: 1
[NUKPACS] Presentation Context 0 "1.2.840.10008.5.1.4.1.1.6.1" 1
[NUKPACS] Server Command := 0001
[NUKPACS] Message ID := 0003
[NUKPACS] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.6.1"
[NUKPACS] 0000,0100 2 US CommandField 1
[NUKPACS] 0000,0110 2 US MessageID 3
[NUKPACS] 0000,0700 2 US Priority 0
[NUKPACS] 0000,0800 2 US DataSetType 258
[NUKPACS] 0000,1000 48 UI AffectedSOPInstanceU "1.3.12.2.1107.5.5.9.307357.20110127120230.61911"
[NUKPACS] 0002,0010 22 UI TransferSyntaxUID "1.2.840.10008.1.2.4.70"
[NUKPACS] [recompress]: recompressed with mode = un (strip=0)
[NUKPACS] Query Tables: DICOMImages
[NUKPACS] Columns : ObjectFile, DeviceName
[NUKPACS] Where : SOPInstanc = '1.3.12.2.1107.5.5.9.307357.20110127120230.61911' AND ImagePat = '12731'
[NUKPACS] Order : (null)
[NUKPACS] FreeStore Left 836795 on D:\
[NUKPACS] Add to Table: DICOMImages
[NUKPACS] Columns: SOPInstanc, SOPClassUI, ImageNumbe, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
[NUKPACS] Values: '1.3.12.2.1107.5.5.9.307357.20110127120230.61911', '1.2.840.10008.5.1.4.1.1.6.1', '1', '3', 'RGB', '600', '800', '8', '12731', '1.3.12.2.1107.5.5.9.307357.20110127120215.61903', 1296820128, '12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000001_12968201310299.dcm', 'MAG0'
[NUKPACS] ***Failed SQLExecDirect : INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.3.12.2.1107.5.5.9.307357.20110127120230.61911', '1.2.840.10008.5.1.4.1.1.6.1', '1', '3', 'RGB', '600', '800', '8', '12731', '1.3.12.2.1107.5.5.9.307357.20110127120215.61903', 1296820128, '12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000001_12968201310299.dcm', 'MAG0')
[NUKPACS] ***Error: 2627: 23000: [Microsoft][ODBC SQL Server Driver][SQL Server]Verletzung der PRIMARY KEY-Einschr�nkung 'PK__DICOMImages__0F975522'. Ein doppelter Schl�ssel kann in das 'dbo.DICOMImages'-Objekt nicht eingef�gt werden.
[NUKPACS] ***Unable to DB.Add()
[NUKPACS] ***SQL: INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.3.12.2.1107.5.5.9.307357.20110127120230.61911', '1.2.840.10008.5.1.4.1.1.6.1', '1', '3', 'RGB', '600', '800', '8', '12731', '1.3.12.2.1107.5.5.9.307357.20110127120215.61903', 1296820128, '12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000001_12968201310299.dcm', 'MAG0')
[NUKPACS] ***Error: 2627: 23000: [Microsoft][ODBC SQL Server Driver][SQL Server]Verletzung der PRIMARY KEY-Einschr�nkung 'PK__DICOMImages__0F975522'. Ein doppelter Schl�ssel kann in das 'dbo.DICOMImages'-Objekt nicht eingef�gt werden.
[NUKPACS] ***Error saving to SQL: 12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000001_12968201310299.dcm
[NUKPACS] Server Command := 0001
[NUKPACS] Message ID := 0005
[NUKPACS] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.6.1"
[NUKPACS] 0000,0100 2 US CommandField 1
[NUKPACS] 0000,0110 2 US MessageID 5
[NUKPACS] 0000,0700 2 US Priority 0
[NUKPACS] 0000,0800 2 US DataSetType 258
[NUKPACS] 0000,1000 48 UI AffectedSOPInstanceU "1.3.12.2.1107.5.5.9.307357.20110127120310.61916"
[NUKPACS] 0002,0010 22 UI TransferSyntaxUID "1.2.840.10008.1.2.4.70"
[NUKPACS] [recompress]: recompressed with mode = un (strip=0)
[NUKPACS] Query Tables: DICOMImages
[NUKPACS] Columns : ObjectFile, DeviceName
[NUKPACS] Where : SOPInstanc = '1.3.12.2.1107.5.5.9.307357.20110127120310.61916' AND ImagePat = '12731'
[NUKPACS] Order : (null)
[NUKPACS] FreeStore Left 836795 on D:\
[NUKPACS] Add to Table: DICOMImages
[NUKPACS] Columns: SOPInstanc, SOPClassUI, ImageNumbe, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
[NUKPACS] Values: '1.3.12.2.1107.5.5.9.307357.20110127120310.61916', '1.2.840.10008.5.1.4.1.1.6.1', '2', '3', 'RGB', '600', '800', '8', '12731', '1.3.12.2.1107.5.5.9.307357.20110127120215.61903', 1296820128, '12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000002_1296820131029a.dcm', 'MAG0'
[NUKPACS] ***Failed SQLExecDirect : INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.3.12.2.1107.5.5.9.307357.20110127120310.61916', '1.2.840.10008.5.1.4.1.1.6.1', '2', '3', 'RGB', '600', '800', '8', '12731', '1.3.12.2.1107.5.5.9.307357.20110127120215.61903', 1296820128, '12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000002_1296820131029a.dcm', 'MAG0')
[NUKPACS] ***Error: 2627: 23000: [Microsoft][ODBC SQL Server Driver][SQL Server]Verletzung der PRIMARY KEY-Einschr�nkung 'PK__DICOMImages__0F975522'. Ein doppelter Schl�ssel kann in das 'dbo.DICOMImages'-Objekt nicht eingef�gt werden.
[NUKPACS] ***Unable to DB.Add()
[NUKPACS] ***SQL: INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.3.12.2.1107.5.5.9.307357.20110127120310.61916', '1.2.840.10008.5.1.4.1.1.6.1', '2', '3', 'RGB', '600', '800', '8', '12731', '1.3.12.2.1107.5.5.9.307357.20110127120215.61903', 1296820128, '12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000002_1296820131029a.dcm', 'MAG0')
[NUKPACS] ***Error: 2627: 23000: [Microsoft][ODBC SQL Server Driver][SQL Server]Verletzung der PRIMARY KEY-Einschr�nkung 'PK__DICOMImages__0F975522'. Ein doppelter Schl�ssel kann in das 'dbo.DICOMImages'-Objekt nicht eingef�gt werden.
[NUKPACS] ***Error saving to SQL: 12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000002_1296820131029a.dcm
[NUKPACS] Server Command := 0001
[NUKPACS] Message ID := 0007
[NUKPACS] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.6.1"
[NUKPACS] 0000,0100 2 US CommandField 1
[NUKPACS] 0000,0110 2 US MessageID 7
[NUKPACS] 0000,0700 2 US Priority 0
[NUKPACS] 0000,0800 2 US DataSetType 258
[NUKPACS] 0000,1000 48 UI AffectedSOPInstanceU "1.3.12.2.1107.5.5.9.307357.20110127120532.61921"
[NUKPACS] 0002,0010 22 UI TransferSyntaxUID "1.2.840.10008.1.2.4.70"
[NUKPACS] [recompress]: recompressed with mode = un (strip=0)
[NUKPACS] Query Tables: DICOMImages
[NUKPACS] Columns : ObjectFile, DeviceName
[NUKPACS] Where : SOPInstanc = '1.3.12.2.1107.5.5.9.307357.20110127120532.61921' AND ImagePat = '12731'
[NUKPACS] Order : (null)
[NUKPACS] FreeStore Left 836795 on D:\
[NUKPACS] Add to Table: DICOMImages
[NUKPACS] Columns: SOPInstanc, SOPClassUI, ImageNumbe, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
[NUKPACS] Values: '1.3.12.2.1107.5.5.9.307357.20110127120532.61921', '1.2.840.10008.5.1.4.1.1.6.1', '3', '3', 'RGB', '600', '800', '8', '12731', '1.3.12.2.1107.5.5.9.307357.20110127120215.61903', 1296820128, '12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000003_1296820131029b.dcm', 'MAG0'
[NUKPACS] ***Failed SQLExecDirect : INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.3.12.2.1107.5.5.9.307357.20110127120532.61921', '1.2.840.10008.5.1.4.1.1.6.1', '3', '3', 'RGB', '600', '800', '8', '12731', '1.3.12.2.1107.5.5.9.307357.20110127120215.61903', 1296820128, '12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000003_1296820131029b.dcm', 'MAG0')
[NUKPACS] ***Error: 2627: 23000: [Microsoft][ODBC SQL Server Driver][SQL Server]Verletzung der PRIMARY KEY-Einschr�nkung 'PK__DICOMImages__0F975522'. Ein doppelter Schl�ssel kann in das 'dbo.DICOMImages'-Objekt nicht eingef�gt werden.
[NUKPACS] ***Unable to DB.Add()
[NUKPACS] ***SQL: INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.3.12.2.1107.5.5.9.307357.20110127120532.61921', '1.2.840.10008.5.1.4.1.1.6.1', '3', '3', 'RGB', '600', '800', '8', '12731', '1.3.12.2.1107.5.5.9.307357.20110127120215.61903', 1296820128, '12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000003_1296820131029b.dcm', 'MAG0')
[NUKPACS] ***Error: 2627: 23000: [Microsoft][ODBC SQL Server Driver][SQL Server]Verletzung der PRIMARY KEY-Einschr�nkung 'PK__DICOMImages__0F975522'. Ein doppelter Schl�ssel kann in das 'dbo.DICOMImages'-Objekt nicht eingef�gt werden.
[NUKPACS] ***Error saving to SQL: 12731\1.3.12.2.1107.5.5.9.307357.20110127120215.61903_0001_000003_1296820131029b.dcm
[NUKPACS] UPACS THREAD 1414: ENDED AT: Fri Feb 04 12:48:51 2011
[NUKPACS] UPACS THREAD 1414: TOTAL RUNNING TIME: 1 SECONDS
Hi,
can you find the log of the first delete? Maybe there is an issue with german characters. You did not change TruncateFieldNames in dicom.ini? (A bug was reported with deleting after changing this entry).
Marcel
Don’t have an account yet? Register yourself now and be a part of our community!