We had downloaded and applied as per your suggestion. Issues seemed fixed and we will keep monitoring for few more days to verify if issue still found. Thank you.
Posts by emilyfung
-
-
The error code is 2627. We found error in 1419 and 1500a
Following with the error extraction from the serverstatus log:
0/29/2020 10:26:49 AM [FXDICOM1] Query Tables: DICOMImages
10/29/2020 10:26:49 AM [FXDICOM1] Columns : ObjectFile, DeviceName
10/29/2020 10:26:49 AM [FXDICOM1] Where : SOPInstanc = '1.2.840.113663.1500.1.369996779.3.1.20201029.102319.796' AND ImagePat = 'C5129573'
10/29/2020 10:26:49 AM [FXDICOM1] Order : (null)
10/29/2020 10:26:49 AM [FXDICOM1] FreeStore Left 273584 on f:\
10/29/2020 10:26:49 AM [FXDICOM1] Add to Table: DICOMImages
10/29/2020 10:26:49 AM [FXDICOM1] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
10/29/2020 10:26:49 AM [FXDICOM1] Values: '1.2.840.113663.1500.1.369996779.3.1.20201029.102319.796', '1.2.840.10008.5.1.4.1.1.6.1', '1', '20201029', '102319', '1', 'MONOCHROME2', '768', '1024', '8', 'ORIGINAL\PRIMARY\ABDOMINAL', 'C5129573', '1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796', 1603938400, 'C5129573\1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796_0001_000001_160393840903d1.dcm', 'MAG0'
10/29/2020 10:26:49 AM [FXDICOM1] Query Tables: DICOMImages
10/29/2020 10:26:49 AM [FXDICOM1] Columns : ObjectFile, DeviceName
10/29/2020 10:26:49 AM [FXDICOM1] Where : SOPInstanc = '1.2.840.113663.1500.1.369996779.3.11.20201029.102428.921' AND ImagePat = 'C5129573'
10/29/2020 10:26:49 AM [FXDICOM1] Order : (null)
10/29/2020 10:26:49 AM [FXDICOM1] FreeStore Left 273584 on f:\
10/29/2020 10:26:49 AM [FXDICOM1] Add to Table: DICOMImages
10/29/2020 10:26:49 AM [FXDICOM1] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
10/29/2020 10:26:49 AM [FXDICOM1] Values: '1.2.840.113663.1500.1.369996779.3.11.20201029.102428.921', '1.2.840.10008.5.1.4.1.1.6.1', '11', '20201029', '102428', '1', 'MONOCHROME2', '768', '1024', '8', 'ORIGINAL\PRIMARY\ABDOMINAL', 'C5129573', '1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796', 1603938400, 'C5129573\1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796_0001_000011_160393840903d2.dcm', 'MAG0'
10/29/2020 10:26:49 AM [FXDICOM1] Query Tables: DICOMSeries
10/29/2020 10:26:49 AM [FXDICOM1] Columns : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,StudyInsta
10/29/2020 10:26:49 AM [FXDICOM1] Query Tables: DICOMSeries
10/29/2020 10:26:49 AM [FXDICOM1] Columns : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,StudyInsta
10/29/2020 10:26:49 AM [FXDICOM1] Where : SeriesInst = '1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796' AND SeriesPat = 'C5129573'
10/29/2020 10:26:49 AM [FXDICOM1] Order : (null)
10/29/2020 10:26:49 AM [FXDICOM1] Where : SeriesInst = '1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796' AND SeriesPat = 'C5129573'
10/29/2020 10:26:49 AM [FXDICOM1] Order : (null)
10/29/2020 10:26:49 AM [FXDICOM1] Add to Table: DICOMSeries
10/29/2020 10:26:49 AM [FXDICOM1] Columns: SeriesInst, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, Manufactur, ModelName, ProtocolNa, Institutio, SeriesPat, StudyInsta, AccessTime
10/29/2020 10:26:49 AM [FXDICOM1] Values: '1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796', '1', '20201029', '101856', 'Abdomen, Whole Abdomen (Appendix is not included)', 'US', 'Philips Medical Systems', 'iU22', 'DR.KAN', 'HOSPITAL', 'C5129573', '1.2.826.0.1.3680043.6.62015.21452.20201029003505.2824.72.690706', 1603938400
10/29/2020 10:26:49 AM [FXDICOM1] Add to Table: DICOMSeries
10/29/2020 10:26:49 AM [FXDICOM1] Columns: SeriesInst, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, Manufactur, ModelName, ProtocolNa, Institutio, SeriesPat, StudyInsta, AccessTime
10/29/2020 10:26:49 AM [FXDICOM1] Values: '1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796', '1', '20201029', '101856', 'Abdomen, Whole Abdomen (Appendix is not included)', 'US', 'Philips Medical Systems', 'iU22', 'DR.KAN', 'HOSPITAL', 'C5129573', '1.2.826.0.1.3680043.6.62015.21452.20201029003505.2824.72.690706', 1603938400
10/29/2020 10:26:49 AM [FXDICOM1] Query Tables: DICOMStudies
10/29/2020 10:26:49 AM [FXDICOM1] Columns : StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,PatientNam,PatientBir,PatientSex,PatientID
10/29/2020 10:26:49 AM [FXDICOM1] Where : StudyInsta = '1.2.826.0.1.3680043.6.62015.21452.20201029003505.2824.72.690706'
10/29/2020 10:26:49 AM [FXDICOM1] Order : (null)
10/29/2020 10:26:49 AM [FXDICOM1] ***Failed SQLExecDirect : INSERT INTO DICOMSeries (SeriesInst, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, Manufactur, ModelName, ProtocolNa, Institutio, SeriesPat, StudyInsta, AccessTime) VALUES ('1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796', '1', '20201029', '101856', 'Abdomen, Whole Abdomen (Appendix is not included)', 'US', 'Philips Medical Systems', 'iU22', 'DR.KAN', 'HOSPITAL', 'C5129573', '1.2.826.0.1.3680043.6.62015.21452.20201029003505.2824.72.690706', 1603938400)
10/29/2020 10:26:49 AM [FXDICOM1] ***Error: 2627: 23000: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__DICOMSer__5DC1FE0A1D28EEC9'. Cannot insert duplicate key in object 'dbo.DICOMSeries'. The duplicate key value is (1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796).
10/29/2020 10:26:49 AM [FXDICOM1] Add to Table: DICOMStudies
10/29/2020 10:26:49 AM [FXDICOM1] ***Unable to DB.Add()
10/29/2020 10:26:49 AM [FXDICOM1] ***SQL: INSERT INTO DICOMSeries (SeriesInst, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, Manufactur, ModelName, ProtocolNa, Institutio, SeriesPat, StudyInsta, AccessTime) VALUES ('1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796', '1', '20201029', '101856', 'Abdomen, Whole Abdomen (Appendix is not included)', 'US', 'Philips Medical Systems', 'iU22', 'DR.KAN', 'TERESA`S HOSPITAL', 'C5129573', '1.2.826.0.1.3680043.6.62015.21452.20201029003505.2824.72.690706', 1603938400)
10/29/2020 10:26:49 AM [FXDICOM1] Columns: StudyInsta, StudyDate, StudyTime, StudyID, StudyDescr, AccessionN, StudyModal, PatientNam, PatientBir, PatientSex, PatientID, AccessTime
10/29/2020 10:26:49 AM [FXDICOM1] ***Error: 2627: 23000: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__DICOMSer__5DC1FE0A1D28EEC9'. Cannot insert duplicate key in object 'dbo.DICOMSeries'. The duplicate key value is (1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796).
10/29/2020 10:26:49 AM [FXDICOM1] Values: '1.2.826.0.1.3680043.6.62015.21452.20201029003505.2824.72.690706', '20201029', '101856', 'STHXR2001052891I', 'Abdomen, Whole Abdomen (Appendix is not included)', 'STHXR2001052891I', 'US', 'KU^CANDY', '19680810', 'F', 'C5129573', 1603938400
10/29/2020 10:26:49 AM [FXDICOM1] Delete Record Table: DICOMImages
10/29/2020 10:26:49 AM [FXDICOM1] Where : SOPInstanc = '1.2.840.113663.1500.1.369996779.3.1.20201029.102319.796' and SOPClassUI = '1.2.840.10008.5.1.4.1.1.6.1' and ImageNumbe = '1' and ImageDate = '20201029' and ImageTime = '102319' and SamplesPer = '1' and PhotoMetri = 'MONOCHROME2' and Rows = '768' and Colums = '1024' and BitsStored = '8' and ImageType = 'ORIGINAL\PRIMARY\ABDOMINAL' and ImagePat = 'C5129573' and SeriesInst = '1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796'
10/29/2020 10:26:49 AM [FXDICOM1] ***Error saving to SQL: C5129573\1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796_0001_000001_160393840903d1.dcm
10/29/2020 10:26:49 AM [FXDICOM1] Query Tables: DICOMPatients
10/29/2020 10:26:49 AM [FXDICOM1] Columns : PatientID,PatientNam,PatientBir,PatientSex
10/29/2020 10:26:49 AM [FXDICOM1] Where : PatientID = 'C5129573'
10/29/2020 10:26:49 AM [FXDICOM1] Order : (null)
10/29/2020 10:26:49 AM [FXDICOM1] Add to Table: DICOMPatients
10/29/2020 10:26:49 AM [FXDICOM1] Columns: PatientID, PatientNam, PatientBir, PatientSex, AccessTime
10/29/2020 10:26:49 AM [FXDICOM1] Values: 'C5129573', 'KU^CANDY', '19680810', 'F', 1603938400
10/29/2020 10:26:49 AM [FXDICOM1] Written file: f:\dicomserver1419\data\C5129573\1.2.840.113663.1500.1.369996779.2.1.20201029.101856.796_0001_000011_160393840903d2.dcm
10/29/2020 10:26:49 AM [FXDICOM1] Server Command := 0001
10/29/2020 10:26:49 AM [FXDICOM1] Message ID := 227c
10/29/2020 10:26:49 AM [FXDICOM1] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.6.1"
10/29/2020 10:26:49 AM [FXDICOM1] 0000,0100 2 US CommandField 1
10/29/2020 10:26:49 AM [FXDICOM1] 0000,0110 2 US MessageID 8828
10/29/2020 10:26:49 AM [FXDICOM1] 0000,0700 2 US Priority 0
10/29/2020 10:26:49 AM [FXDICOM1] 0000,0800 2 US DataSetType 258
10/29/2020 10:26:49 AM [FXDICOM1] 0000,1000 56 UI AffectedSOPInstanceU "1.2.840.113663.1500.1.369996779.3.10.20201029.102424.156"
10/29/2020 10:26:49 AM [FXDICOM1] 0002,0010 19 UI TransferSyntaxUID "1.2.840.10008.1.2.1"
10/29/2020 10:26:49 AM [FXDICOM1] Server Command := 0001
10/29/2020 10:26:49 AM [FXDICOM1] Message ID := 227d
-
Yes, all images are route from M7's PACS at the same time. Will it be SQL server issue or something else?
-
My conquest version is 1.4.19 , if user resend the full series, the first image appear
-
I had checked from the database that there is no duplicate patient for same study. Is there anything else? It's strange that the second and fore-coming images for the same patient and same study can be uploaded successfully.
-
Here with the error message: (some data masked)
10/12/2020 9:35:15 AM [DICOM1] ***Failed SQLExecDirect : INSERT INTO DICOMStudies (StudyInsta, StudyDate, StudyTime, StudyID, StudyDescr, AccessionN, StudyModal, PatientNam, PatientBir, PatientSex, PatientID, AccessTime) VALUES ('1.2.826.0.1.3680043.6.49952.18092.20201012064348.2824.78.329653', '20201012', '092338', '2001048630F', 'Abdomen, Whole Abdomen (Appendix is not included)', '2001048630F', 'US', 'NGAN', '19760416', 'F', 'K112864A', 1602466496)
10/12/2020 9:35:15 AM [DICOM1] ***Error: 2627: 23000: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__DICOMStu__3B309566C4403DA2'. Cannot insert duplicate key in object 'dbo.DICOMStudies'. The duplicate key value is (1.2.826.0.1.3680043.6.49952.18092.20201012064348.2824.78.329653).
10/12/2020 9:35:15 AM [DICOM1] ***Unable to DB.Add()
10/12/2020 9:35:15 AM [DICOM1] ***SQL: INSERT INTO DICOMStudies (StudyInsta, StudyDate, StudyTime, StudyID, StudyDescr, AccessionN, StudyModal, PatientNam, PatientBir, PatientSex, PatientID, AccessTime) VALUES ('1.2.826.0.1.3680043.6.49952.18092.20201012064348.2824.78.329653', '20201012', '092338', '2001048630F', 'Abdomen, Whole Abdomen (Appendix is not included)', '2001048630F', 'US', 'NGAN', '19760416', 'F', 'K112864A', 1602466496)
10/12/2020 9:35:15 AM [DICOM1] ***Error: 2627: 23000: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__DICOMStu__3B309566C4403DA2'. Cannot insert duplicate key in object 'dbo.DICOMStudies'. The duplicate key value is (1.2.826.0.1.3680043.6.49952.18092.20201012064348.2824.78.329653).
10/12/2020 9:35:15 AM [DICOM1] ***Error saving to SQL: K552864A\1.2.840.113663.1500.1.369996779.2.1.20201012.92339.31_0001_000001_160246651585c2.dcm
2nd image and coming images for the same patient & study can save to the system.