Command dgate --delete fails in 1.4.19

ome_chris · Dec 30th 2018

Hi,

In a PHP script running on a W10 64 bit I use the command:

Code

dgate --deleteseries:patid:seriesuid

Of course with the correct parameters.

With 1.4.19 I get:

Code

29-12-2018 11:06:23 [CONQUESTPRAK] Server command sent using DGATE -- option
29-12-2018 11:06:23 [CONQUESTPRAK] Deleting series from: 000
29-12-2018 11:06:23 [CONQUESTPRAK] Removing object: [MAG0:000\1.3.51.0.7.1583638180.51589.4175.37669.20855.56144.52530_0009_000001_150846803400cb.dcm]
29-12-2018 11:06:23 [CONQUESTPRAK] ***[NewDeleteFromDB] -FAILED: DDO does not contain correct UIDs

Then the image seems to be removed on MAG but the database isn't changed so it may be referring to not a not existing instance.

When I fall back to 1.4.17 and using the same script:

Code

[CONQUESTPRAK] Server command sent using DGATE -- option
[CONQUESTPRAK] Deleting series: 000
[CONQUESTPRAK] Removed file: [MAG0:000\1.3.51.0.7.12546216918.30696.55364.42108.18096.11231.45256_0001_000001_140352490700ff.dcm]

Nothing failed and everything is OK, instance removed on MAG and in DB.

Chris.

marcelvanherk · Dec 30th 2018

Thanks,

The delete routine is new. Can you verify the object has patientID, studyUID, seriesUID and SOPInstanceUID. And what is the command line you use?

Marcel

ome_chris · Dec 31st 2018

Hi,

Object has patientID, studyUID, seriesUID and SOPInstanceUID.

Commandline:

Code

dgate.exe --deleteseries:patID:seriesUID

Chris.

marcelvanherk · Dec 31st 2018

Hm,

it works for me? Here I delete the test image provided with the server:

C:\dicomserver>dgate64 --deleteseries:0009703828:1.3.46.670589.5.2.10.2156913941.892665339.860724

In debug log mode it gives:

12/31/2018 12:36:58 PM [CONQUESTSRV1] Server command sent using DGATE -- option

12/31/2018 12:37:11 PM [CONQUESTSRV1] Connected by address: 0100007f

12/31/2018 12:37:11 PM [CONQUESTSRV1] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'

12/31/2018 12:37:11 PM [CONQUESTSRV1] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"

12/31/2018 12:37:11 PM [CONQUESTSRV1] 0000,0100 2 US CommandField 48

12/31/2018 12:37:11 PM [CONQUESTSRV1] 0000,0110 2 US MessageID 1

12/31/2018 12:37:11 PM [CONQUESTSRV1] 0000,0800 2 US DataSetType 257

12/31/2018 12:37:11 PM [CONQUESTSRV1] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"

12/31/2018 12:37:11 PM [CONQUESTSRV1] 9999,0300 42 LO ConquestConsoleText "Server command sent using DGATE -- option"

12/31/2018 12:37:11 PM [CONQUESTSRV1] 9999,0400 72 LO ConquestConsoleComma "deleteseries:0009703828:1.3.46.670589.5.2.10.2156913941.892665339.860724"

12/31/2018 12:37:11 PM [CONQUESTSRV1] Server command sent using DGATE -- option

12/31/2018 12:37:11 PM [CONQUESTSRV1] Deleting series from: 0009703828

12/31/2018 12:37:11 PM [CONQUESTSRV1] Query On Image

12/31/2018 12:37:11 PM [CONQUESTSRV1] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta

12/31/2018 12:37:11 PM [CONQUESTSRV1] Values: DICOMSeries.SeriesInst = '1.3.46.670589.5.2.10.2156913941.892665339.860724' and DICOMStudies.PatientID = '0009703828' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst

12/31/2018 12:37:11 PM [CONQUESTSRV1] Tables: DICOMImages, DICOMSeries, DICOMStudies

12/31/2018 12:37:11 PM [CONQUESTSRV1] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies

12/31/2018 12:37:11 PM [CONQUESTSRV1] Columns : DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMSeries.SeriesInst = '1.3.46.670589.5.2.10.2156913941.892665339.860724' and DICOMStudies.PatientID = '0009703828' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst

12/31/2018 12:37:11 PM [CONQUESTSRV1] Order : (null)

12/31/2018 12:37:11 PM [CONQUESTSRV1] Records = 2

12/31/2018 12:37:11 PM [CONQUESTSRV1] RemoveFiles 2 images

12/31/2018 12:37:11 PM [CONQUESTSRV1] Query Tables: DICOMImages

12/31/2018 12:37:11 PM [CONQUESTSRV1] Columns : ObjectFile, DeviceName

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : SOPInstanc = '1.3.46.670589.5.2.10.2156913941.892665339.718742' AND ImagePat = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Order : (null)

12/31/2018 12:37:11 PM [CONQUESTSRV1] Removing object: [MAG0:0009703828\1.3.46.670589.5.2.10.2156913941.892665339.860724_0001_002000_14579035620000.dcm]

12/31/2018 12:37:11 PM [CONQUESTSRV1] Delete Record Table: DICOMImages

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMImages.SopInstanc = '1.3.46.670589.5.2.10.2156913941.892665339.718742' and DICOMImages.SeriesInst = '1.3.46.670589.5.2.10.2156913941.892665339.860724'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Query Tables: DICOMImages

12/31/2018 12:37:11 PM [CONQUESTSRV1] Columns : ObjectFile, DeviceName

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : SOPInstanc = '1.3.46.670589.5.2.10.2156913941.892665340.475317' AND ImagePat = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Order : (null)

12/31/2018 12:37:11 PM [CONQUESTSRV1] Removing object: [MAG0:0009703828\1.3.46.670589.5.2.10.2156913941.892665339.860724_0001_003000_14579035620001.dcm]

12/31/2018 12:37:11 PM [CONQUESTSRV1] Query Tables: DICOMImages

12/31/2018 12:37:11 PM [CONQUESTSRV1] Columns : DICOMImages.SopInstanc

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMImages.SopInstanc = '1.3.46.670589.5.2.10.2156913941.892665340.475317' and DICOMImages.SeriesInst = '1.3.46.670589.5.2.10.2156913941.892665339.860724' and DICOMImages.ImagePat = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Order : (null)

12/31/2018 12:37:11 PM [CONQUESTSRV1] Delete Record Table: DICOMImages

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMImages.SopInstanc = '1.3.46.670589.5.2.10.2156913941.892665340.475317' and DICOMImages.SeriesInst = '1.3.46.670589.5.2.10.2156913941.892665339.860724' and DICOMImages.ImagePat = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Query Tables: DICOMImages

12/31/2018 12:37:11 PM [CONQUESTSRV1] Columns : DICOMImages.SeriesInst

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMImages.SeriesInst = '1.3.46.670589.5.2.10.2156913941.892665339.860724' and DICOMImages.ImagePat = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Order : (null)

12/31/2018 12:37:11 PM [CONQUESTSRV1] Delete Record Table: DICOMSeries

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMSeries.SeriesInst = '1.3.46.670589.5.2.10.2156913941.892665339.860724' and DICOMSeries.StudyInsta = '1.3.46.670589.5.2.10.2156913941.892665384.993397' and DICOMSeries.SeriesPat = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Query Tables: DICOMSeries

12/31/2018 12:37:11 PM [CONQUESTSRV1] Columns : DICOMSeries.StudyInsta

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMSeries.StudyInsta = '1.3.46.670589.5.2.10.2156913941.892665384.993397' and DICOMSeries.SeriesPat = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Order : (null)

12/31/2018 12:37:11 PM [CONQUESTSRV1] Delete Record Table: DICOMStudies

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMStudies.StudyInsta = '1.3.46.670589.5.2.10.2156913941.892665384.993397' and DICOMStudies.PatientID = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Query Tables: DICOMStudies

12/31/2018 12:37:11 PM [CONQUESTSRV1] Columns : DICOMStudies.PatientID

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMStudies.PatientID = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Order : (null)

12/31/2018 12:37:11 PM [CONQUESTSRV1] Delete Record Table: DICOMPatients

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMPatients.PatientID = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Query Tables: DICOMWorkList

12/31/2018 12:37:11 PM [CONQUESTSRV1] Columns : DICOMWorkList.PatientID

12/31/2018 12:37:11 PM [CONQUESTSRV1] Where : DICOMWorkList.PatientID = '0009703828'

12/31/2018 12:37:11 PM [CONQUESTSRV1] Order : (null)

ome_chris · Dec 31st 2018

Hi,

For some reason dgate64 is not present in the root of c:\dicomserver\distribution\

However, this a 64 bit.

I'll re-install the whole stuff again and let you know.

BTW, is there a reason to use \distribution as parent directory?

Chris.

ome_chris · Jan 1st 2019

Hi,

After fresh install I got the same:

Code

20190101 15:00:26 Connected by address: 0100007f
20190101 15:00:26 Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
20190101 15:00:26 0000,0002     18 UI AffectedSOPClassUID    "1.2.840.10008.1.1" 
20190101 15:00:26 0000,0100      2 US CommandField           48 
20190101 15:00:26 0000,0110      2 US MessageID              1 
20190101 15:00:26 0000,0800      2 US DataSetType            257 
20190101 15:00:26 0002,0010     17 UI TransferSyntaxUID      "1.2.840.10008.1.2" 
20190101 15:00:26 9999,0300     42 LO ConquestConsoleText    "Server command sent using DGATE -- option" 
20190101 15:00:26 9999,0400     74 LO ConquestConsoleComma   "deleteseries:00323:1.3.51.0.7.3327430052.2708.34381.36316.29994.2338.2583" 
[CONQUESTPRAK] 20190101 15:00:26 Server command sent using DGATE -- option
[CONQUESTPRAK] 20190101 15:00:26 Deleting series from: 00323
20190101 15:00:26 Query On Image
20190101 15:00:26 Issue Query on Columns: DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID
20190101 15:00:26 Values: DICOMSeries.SeriesInst = '1.3.51.0.7.3327430052.2708.34381.36316.29994.2338.2583' and DICOMStudies.PatientID = '00323' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
20190101 15:00:26 Tables: DICOMImages, DICOMSeries, DICOMStudies
20190101 15:00:26 Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
20190101 15:00:26 Columns              : DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID
20190101 15:00:26 Where                : DICOMSeries.SeriesInst = '1.3.51.0.7.3327430052.2708.34381.36316.29994.2338.2583' and DICOMStudies.PatientID = '00323' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
20190101 15:00:26 Order                : (null)
20190101 15:00:26 Records = 1
20190101 15:00:26 RemoveFiles 1 images
20190101 15:00:26 Query Tables: DICOMImages
20190101 15:00:26 Columns     : ObjectFile, DeviceName
20190101 15:00:26 Where       : SOPInstanc = '1.3.51.0.7.12742556872.21647.45634.41862.23540.39542.43212' AND ImagePat = '00323'
20190101 15:00:26 Order       : (null)
[CONQUESTPRAK] 20190101 15:00:26 Removing object: [MAG0:00323\1.3.51.0.7.3327430052.2708.34381.36316.29994.2338.2583_0002_000001_150846809600fe.dcm]
[CONQUESTPRAK] 20190101 15:00:26 ***[NewDeleteFromDB] -FAILED: DDO does not contain correct UIDs

Display More

The only extra I did:

make a symlink dgate.exe to dgate64.exe.

Chris.

marcelvanherk · Jan 1st 2019

Hi,

the distribution folder name was a mistake. It is gone in current releases. Dgate.exe and dgate64.exe are copied from install32 and install64.

Which version are you actually using, I recommend 1.4.19c1.

Marcel

marcelvanherk · Jan 1st 2019

Hi,

the fix may be here (dgate.cpp):

20170530 mvh Add empty StudyUID to deleteseries()

This is first in the 1.4.19c release.

Marcel

Command dgate --delete fails in 1.4.19

Participate now!

Share