Hi!
I am a newbie, trying to make a server using mysql and got an unexpected result:
when i save dicom file to incoming dir in log get error:
Sun Mar 5 07:19:28 2023 ***Failed MYSQLExec : INSERT INTO DICOMSeries (SeriesInst, SeriesNumb, Modality, Manufactur, ModelName, StationNam, Institutio, SeriesPat, StudyInsta, AccessTime) VALU
ES ('1.2.826.0.1.3680043.2.634.0.64691.20230220.171804.8', '0', 'DX', 'NIPK ELEKTRON', 'KRT', '........ .......', '...', 'auto3048', '1.2.826.0.1.3680043.2.634.0.29918.20230220.171757.7', 1678
000768)
Sun Mar 5 07:19:28 2023 ***Error: Incorrect string value: '\xBD\xD0\xD7\xD2\xD0\xDD...' for column 'StationNam' at row 1
Sun Mar 5 07:19:28 2023 ***Unable to DB.Add()
Sun Mar 5 07:19:28 2023 ***SQL: INSERT INTO DICOMSeries (SeriesInst, SeriesNumb, Modality, Manufactur, ModelName, StationNam, Institutio, SeriesPat, StudyInsta, AccessTime) VALUES ('1.2.826.0
.1.3680043.2.634.0.64691.20230220.171804.8', '0', 'DX', 'NIPK ELEKTRON', 'KRT', '........ .......', '...', 'auto3048', '1.2.826.0.1.3680043.2.634.0.29918.20230220.171757.7', 1678000768)
Sun Mar 5 07:19:28 2023 ***Error: Incorrect string value: '\xBD\xD0\xD7\xD2\xD0\xDD...' for column 'StationNam' at row 1
Sun Mar 5 07:19:28 2023 ***Error saving to SQL: auto3048/1.2.826.0.1.3680043.2.634.0.64691.20230220.171804.8_0000_000000_1678000768003e.dcm
Sun Mar 5 07:19:28 2023 ***[AddImageFile] Error entering object into server: /conquest/mag0/incoming/1.2.826.0.1.3680043.2.634.0.64691.20230220.171804.8_0000_000000_167695793910bc.v2
...
Sun Mar 5 07:53:48 2023 ***Unable to DB.Add()
Sun Mar 5 07:53:48 2023 ***SQL: INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, SamplesPer, PhotoMetri, QRows, QColumns, BitsStored, ImageType, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.2.826.0.1.3680043.
2.634.0.20312.20230222.115543.2', '1.2.840.10008.5.1.4.1.1.1.1', '0', '20230222', '115543', '1', 'MONOCHROME2', '3072', '3072', '16', E'ORIGINAL\\PRIMARY', '454674441', '1.2.826.0.1.3680043.2.634.0.19184.20230222.115540.1', 1678002816, '454674441/1.2.826.0.1.3680043.
2.634.0.19184.20230222.115540.1_0000_000000_16780028280001.dcm', 'MAG0')
Sun Mar 5 07:53:48 2023 ***Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ORIGINAL\\PRIMARY', '454674441', '1.2.826.0.1.3680043.2.634.0.19184.20230222.11' at line 1
Sun Mar 5 07:53:48 2023 ***Error saving to SQL: 454674441/1.2.826.0.1.3680043.2.634.0.19184.20230222.115540.1_0000_000000_16780028280001.dcm
Sun Mar 5 07:54:23 2023 ***[AddImageFile] Error entering object into server: /conquest/mag0/incoming/1.2.826.0.1.3680043.2.634.0.19184.20230222.115540.1_0000_000000_16770525930003.v2
...
Sun Mar 5 07:57:03 2023 ***Unable to DB.Add()
Sun Mar 5 07:57:03 2023 ***SQL: INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, SamplesPer, PhotoMetri, QRows, QColumns, BitsStored, ImageType, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.2.826.0.1.3680043.
2.634.0.37080.20230301.134128.6', '1.2.840.10008.5.1.4.1.1.1.1', '0', '20230301', '134128', '1', 'MONOCHROME2', '2785', '3036', '16', E'ORIGINAL\PRIMARY', 'auto11012', '1.2.826.0.1.3680043.2.634.0.4828.20230301.134127.5', 1678003008, 'auto11012/1.2.826.0.1.3680043.2.
634.0.4828.20230301.134127.5_0000_000000_16780030230005.dcm', 'MAG0')
Sun Mar 5 07:57:03 2023 ***Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ORIGINAL\PRIMARY', 'auto11012', '1.2.826.0.1.3680043.2.634.0.4828.20230301.1341' at line 1
Sun Mar 5 07:57:03 2023 ***Error saving to SQL: auto11012/1.2.826.0.1.3680043.2.634.0.4828.20230301.134127.5_0000_000000_16780030230005.dcm
...
Sun Mar 5 07:57:57 2023 ***Unable to DB.Add()
Sun Mar 5 07:57:57 2023 ***SQL: INSERT INTO DICOMSeries (SeriesInst, SeriesNumb, Modality, Manufactur, ModelName, StationNam, Institutio, SeriesPat, StudyInsta, AccessTime) VALUES ('1.2.826.0.1.3680043.2.634.0.4828.20230301.134127.5', '0', 'DX', 'NIPK ELEKTRON', 'KR
T', 'KRT', '.÷ .. "........... ........ ..........."', 'auto11012', '1.2.826.0.1.3680043.2.634.0.6685.20230301.125213.2', 1678003072)
Sun Mar 5 07:57:57 2023 ***Error: Incorrect string value: '\xB3\xC3\xB7 \xC1\xBE...' for column 'Institutio' at row 1
Sun Mar 5 07:57:57 2023 ***Error saving to SQL: auto11012/1.2.826.0.1.3680043.2.634.0.4828.20230301.134127.5_0000_000000_16780030770006.dcm
Sun Mar 5 07:57:57 2023 ***[AddImageFile] Error entering object into server: /conquest/mag0/incoming/1.2.826.0.1.3680043.2.634.0.4828.20230301.134127.5_0000_000000_16776639030003.v2
Sun Mar 5 07:58:02 2023 ***Failed MYSQLExec : INSERT INTO DICOMSeries (SeriesInst, SeriesNumb, Modality, Manufactur, ModelName, StationNam, Institutio, SeriesPat, StudyInsta, AccessTime) VALUES ('1.2.826.0.1.3680043.2.634.0.4828.20230301.134127.5', '0', 'DX', 'NIPK
ELEKTRON', 'KRT', 'KRT', '.÷ .. "........... ........ ..........."', 'auto11012', '1.2.826.0.1.3680043.2.634.0.6685.20230301.125213.2', 1678003072)
Sun Mar 5 07:58:02 2023 ***Error: Incorrect string value: '\xB3\xC3\xB7 \xC1\xBE...' for column 'Institutio' at row 1
Sun Mar 5 07:58:02 2023 ***Unable to DB.Add()
Sun Mar 5 07:58:02 2023 ***SQL: INSERT INTO DICOMSeries (SeriesInst, SeriesNumb, Modality, Manufactur, ModelName, StationNam, Institutio, SeriesPat, StudyInsta, AccessTime) VALUES ('1.2.826.0.1.3680043.2.634.0.4828.20230301.134127.5', '0', 'DX', 'NIPK ELEKTRON', 'KR
T', 'KRT', '.÷ .. "........... ........ ..........."', 'auto11012', '1.2.826.0.1.3680043.2.634.0.6685.20230301.125213.2', 1678003072)
Sun Mar 5 07:58:02 2023 ***Error: Incorrect string value: '\xB3\xC3\xB7 \xC1\xBE...' for column 'Institutio' at row 1
Sun Mar 5 07:58:02 2023 ***Error saving to SQL: auto11012/1.2.826.0.1.3680043.2.634.0.4828.20230301.134127.5_0000_000000_16780030820007.dcm
Sun Mar 5 07:58:02 2023 ***[AddImageFile] Error entering object into server: /conquest/mag0/incoming/1.2.826.0.1.3680043.2.634.0.4828.20230301.134127.5_0000_000000_16776639030003.v2
what i can do?
and second question - anyone use dockerized version of conquest in production pacs? and if yes - can you get Dockerfile?
thanks in advance!