Error saving to SQL when receiving from other PACS

blub_smile · Jan 15th 2019

Hi

I am having problem to receive studies from another PACS which have a pretty long patient ID.
Due to one old scanner the same patient and its ID can have different writing for the name and the the other PACS ads a suffix to the patient ID like "[IMPORT ROOT date and time]".

Conquest always chokes on those studies and doesn't store the images and hence can't forward them.

Attached is an excerpt of the debug log:

Code

UPACS THREAD 22: STARTED AT: Tue Jan 15 20:47:28 2019
15.01.2019 20:47:29 [TELERAD] A-ASSOCIATE-RQ Packet Dump
15.01.2019 20:47:29 [TELERAD]  Calling Application Title : "PACS            "
15.01.2019 20:47:29 [TELERAD]  Called Application Title : "TELERAD         "
15.01.2019 20:47:29 [TELERAD]  Application Context : "1.2.840.10008.3.1.1.1", PDU length: 32762
15.01.2019 20:47:29 [TELERAD]  Number of Proposed Presentation Contexts: 1
15.01.2019 20:47:29 [TELERAD]  Presentation Context 0 "1.2.840.10008.5.1.4.1.1.4" 1
15.01.2019 20:47:29 [TELERAD] Server Command   := 0001
15.01.2019 20:47:29 [TELERAD] Message ID       := 28fe
15.01.2019 20:47:29 [TELERAD] Move Originator Message ID := 0004
15.01.2019 20:47:29 [TELERAD] Move Originator AE         := TELERAD         
15.01.2019 20:47:29 [TELERAD] 0000,0002     26 UI AffectedSOPClassUID    "1.2.840.10008.5.1.4.1.1.4" 
15.01.2019 20:47:29 [TELERAD] 0000,0100      2 US CommandField           1 
15.01.2019 20:47:29 [TELERAD] 0000,0110      2 US MessageID              10494 
15.01.2019 20:47:29 [TELERAD] 0000,0700      2 US Priority               0 
15.01.2019 20:47:29 [TELERAD] 0000,0800      2 US DataSetType            0 
15.01.2019 20:47:29 [TELERAD] 0000,1000     54 UI AffectedSOPInstanceU   "1.2.840.113619.2.222.3596.3078814.9269.1547442379.463" 
15.01.2019 20:47:29 [TELERAD] 0000,1030      8 AE MoveOriginatorApplic   "TELERAD " 
15.01.2019 20:47:29 [TELERAD] 0000,1031      2 US MoveOriginatorMessag   4 
15.01.2019 20:47:29 [TELERAD] 0002,0010     19 UI TransferSyntaxUID      "1.2.840.10008.1.2.1" 
15.01.2019 20:47:29 [TELERAD] Query Tables: DICOMImages
15.01.2019 20:47:29 [TELERAD] Columns     : ObjectFile, DeviceName
15.01.2019 20:47:29 [TELERAD] Where       : SOPInstanc = '1.2.840.113619.2.222.3596.3078814.9269.1547442379.463' AND ImagePat = '1500851'
15.01.2019 20:47:29 [TELERAD] Order       : (null)
15.01.2019 20:47:29 [TELERAD] FreeStore Left 10986888 on d:\
15.01.2019 20:47:29 [TELERAD] Add to Table: DICOMImages
15.01.2019 20:47:29 [TELERAD] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, EchoNumber, AcqDate, AcqTime, ReceivingC, AcqNumber, SliceLocat, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
15.01.2019 20:47:29 [TELERAD] Values: '1.2.840.113619.2.222.3596.3078814.9269.1547442379.463', '1.2.840.10008.5.1.4.1.1.4', '1', '20190115', '064155', '1', '20190115', '064155', 'USLS456', '1', '-8', '1', 'MONOCHROME2', '256', '256', '16', 'ORIGINAL\PRIMARY\OTHER', '1500851', '1.2.840.113619.2.222.3596.3078814.9269.1547442379.397', 1547581632, '1500851\1.2.276.0.37.1.183.201007.5708004\1.2.840.113619.2.222.3596.3078814.9269.1547442379.397\1.2.840.113619.2.222.3596.3078814.9269.1547442379.463.v2', 'MAG0'
15.01.2019 20:47:29 [TELERAD] Query Tables: DICOMSeries
15.01.2019 20:47:29 [TELERAD] Columns     : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,StudyInsta
15.01.2019 20:47:29 [TELERAD] Where       : SeriesInst = '1.2.840.113619.2.222.3596.3078814.9269.1547442379.397' AND SeriesPat = '1500851'
15.01.2019 20:47:29 [TELERAD] Order       : (null)
15.01.2019 20:47:29 [TELERAD] Add to Table: DICOMSeries
15.01.2019 20:47:29 [TELERAD] Columns: SeriesInst, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, PatientPos, Manufactur, ModelName, ProtocolNa, StationNam, Institutio, FrameOfRef, SeriesPat, StudyInsta, AccessTime
15.01.2019 20:47:29 [TELERAD] Values: '1.2.840.113619.2.222.3596.3078814.9269.1547442379.397', '1', '20190115', '064155', '3-pl T2* FGRE S', 'MR', 'HFS', 'GE MEDICAL SYSTEMS', 'SIGNA EXCITE', 'LWS STANDARD+OP/1,2,3,4,', 'GEMSOW', 'Institution', '1.2.840.113619.2.222.3596.3078814.9351.1547442331.354', '1500851', '1.2.276.0.37.1.183.201007.5708004', 1547581632
15.01.2019 20:47:29 [TELERAD] Query Tables: DICOMStudies
15.01.2019 20:47:29 [TELERAD] Columns     : StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,PatientNam,PatientBir,PatientSex,PatientID
15.01.2019 20:47:29 [TELERAD] Where       : StudyInsta = '1.2.276.0.37.1.183.201007.5708004'
15.01.2019 20:47:29 [TELERAD] Order       : (null)
15.01.2019 20:47:29 [TELERAD] ***Refused to enter inconsistent link PatientID into DICOMStudies: PatientID = '1500851' StudyInsta = '1.2.276.0.37.1.183.201007.5708004', Old='1500851[Import-root-0110224007]', Refused='1500851'
15.01.2019 20:47:29 [TELERAD] Delete Record Table: DICOMSeries
15.01.2019 20:47:29 [TELERAD] Where              :  SeriesInst = '1.2.840.113619.2.222.3596.3078814.9269.1547442379.397'  and  SeriesNumb = '1'  and  SeriesDate = '20190115'  and  SeriesTime = '064155'  and  SeriesDesc = '3-pl T2* FGRE S'  and  Modality = 'MR'  and  PatientPos = 'HFS'  and  Manufactur = 'GE MEDICAL SYSTEMS'  and  ModelName = 'SIGNA EXCITE'  and  ProtocolNa = 'LWS STANDARD+OP/1,2,3,4,'  and  StationNam = 'GEMSOW'  and  Institutio = 'Institution'  and  FrameOfRef = '1.2.840.113619.2.222.3596.3078814.9351.1547442331.354'  and  SeriesPat = '1500851'  and  StudyInsta = '1.2.276.0.37.1.183.201007.5708004' 
15.01.2019 20:47:29 [TELERAD] Delete Record Table: DICOMImages
15.01.2019 20:47:29 [TELERAD] Where              :  SOPInstanc = '1.2.840.113619.2.222.3596.3078814.9269.1547442379.463'  and  SOPClassUI = '1.2.840.10008.5.1.4.1.1.4'  and  ImageNumbe = '1'  and  ImageDate = '20190115'  and  ImageTime = '064155'  and  EchoNumber = '1'  and  AcqDate = '20190115'  and  AcqTime = '064155'  and  ReceivingC = 'USLS456'  and  AcqNumber = '1'  and  SliceLocat = '-8'  and  SamplesPer = '1'  and  PhotoMetri = 'MONOCHROME2'  and  Rows = '256'  and  Colums = '256'  and  BitsStored = '16'  and  ImageType = 'ORIGINAL\PRIMARY\OTHER'  and  ImagePat = '1500851'  and  SeriesInst = '1.2.840.113619.2.222.3596.3078814.9269.1547442379.397' 
15.01.2019 20:47:29 [TELERAD] ***Error saving to SQL: 1500851\1.2.276.0.37.1.183.201007.5708004\1.2.840.113619.2.222.3596.3078814.9269.1547442379.397\1.2.840.113619.2.222.3596.3078814.9269.1547442379.463.v2
15.01.2019 20:47:29 [TELERAD] Server Command   := 0001
15.01.2019 20:47:29 [TELERAD] Message ID       := 28ff
15.01.2019 20:47:29 [TELERAD] Move Originator Message ID := 0004
15.01.2019 20:47:29 [TELERAD] Move Originator AE         := TELERAD

Display More

Any workaround for that?

thx for any help here

marcelvanherk · Jan 15th 2019

Hi,

It does not choke on the lenght, but on the fact that you have the same study twice with different Patient ID's. I guess you can add a script to get rid of the addition, that may help.

E.g.

[lua]

ImportConverter0 = Data.PatientID = string.gsub(Data.PatientID, '%[.+%]', '')

Marcel

blub_smile · Jan 16th 2019

Quote from marcelvanherk

Hi,

It does not choke on the lenght, but on the fact that you have the same study twice with different Patient ID's. I guess you can add a script to get rid of the addition, that may help.

E.g.

[lua]

ImportConverter0 = Data.PatientID = string.gsub(Data.PatientID, '%[.+%]', '')

Marcel

Display More

Hi

No the database is empty. I deleted all images, made a regen of MAG0 and then imported the study.

marcelvanherk · Jan 16th 2019

Hi,

then both patientID's must be sent at the same time.

**Refused to enter inconsistent link PatientID into DICOMStudies: PatientID = '1500851' StudyInsta = '1.2.276.0.37.1.183.201007.5708004', Old='1500851[Import-root-0110224007]', Refused='1500851'

Really tests the database, so 1500851[Import-root-0110224007] is sent first, and 1500851 second.

Still the script line should help.

Marcel

blub_smile · Jan 16th 2019

Ok, thx.

I just put this line in the dicom.ini like any other importconverter?

marcelvanherk · Jan 16th 2019

Yes,

do not reuse an existing number. One converter can either be in the main body or in [lua]. You can skip numbers, so you can use e.g. [lua]ImportConverter99.

Marcel

blub_smile · Jan 17th 2019

Quote from marcelvanherk

Yes,

do not reuse an existing number. One converter can either be in the main body or in [lua]. You can skip numbers, so you can use e.g. [lua]ImportConverter99.

Marcel

K, thx.

It would be the only one in this instance as it is actually a "conversion PACS" for differen compression types

Error saving to SQL when receiving from other PACS

Participate now!

Share