Hi!
sorry to bother you...
any news?
Hi!
sorry to bother you...
any news?
Hi!
i was remove %callingae
(FileNameSyntax = %studydate[2,7]/%id/%seriesid/%sopuid.dcm) result:
2023-10-18T00:25:06.759640+00:00 PACS2 systemd[1]: Started conquest.service - conquest dicom server service.
2023-10-18T00:25:06.773148+00:00 PACS2 conquest-server[437730]: Monitoring for files in: /zsdb/MAG0/incoming/
2023-10-18T00:25:06.774105+00:00 PACS2 conquest-server[437730]: DGATE (1.5.0d, build Sun Sep 10 18:05:15 2023, bits 64) is running as threaded server
2023-10-18T00:25:06.774986+00:00 PACS2 conquest-server[437730]: Database type: built-in SQLite driver
2023-10-18T00:25:06.875783+00:00 PACS2 conquest-server[437730]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:06.875925+00:00 PACS2 conquest-server[437730]: message repeated 2 times: [ Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm]
2023-10-18T00:25:06.875978+00:00 PACS2 conquest-server[437730]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:06.876096+00:00 PACS2 conquest-server[437730]: message repeated 2 times: [ ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3]
2023-10-18T00:25:06.876853+00:00 PACS2 conquest-server[437730]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:06.876976+00:00 PACS2 conquest-server[437730]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:06.877045+00:00 PACS2 conquest-server[437730]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:06.877251+00:00 PACS2 conquest-server[437730]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:07.061085+00:00 PACS2 conquest-server[437730]: dgate: ./src/dgate/dicomlib/array.tcc:114: DATATYPE& Array<DATATYPE>::Get(unsigned int) [with DATATYPE = BufferSpace*]: Assertio
2023-10-18T00:25:07.061439+00:00 PACS2 systemd[1]: conquest.service: Main process exited, code=killed, status=11/SEGV
2023-10-18T00:25:17.241678+00:00 PACS2 systemd[1]: conquest.service: Scheduled restart job, restart counter is at 11.
2023-10-18T00:25:17.241884+00:00 PACS2 systemd[1]: Stopped conquest.service - conquest dicom server service.
2023-10-18T00:25:17.263586+00:00 PACS2 systemd[1]: Started conquest.service - conquest dicom server service.
2023-10-18T00:25:17.277237+00:00 PACS2 conquest-server[437737]: Monitoring for files in: /zsdb/MAG0/incoming/
2023-10-18T00:25:17.278145+00:00 PACS2 conquest-server[437737]: DGATE (1.5.0d, build Sun Sep 10 18:05:15 2023, bits 64) is running as threaded server
2023-10-18T00:25:17.279588+00:00 PACS2 conquest-server[437737]: Database type: built-in SQLite driver
2023-10-18T00:25:17.279766+00:00 PACS2 conquest-server[437737]: Starting 5 DelayedForwarderThreads 2023-10-18T00:25:17.280400+00:00 PACS2 conquest-server[437737]: Started 1 export queue thread(s) 2023-10-18T00:25:17.380281+00:00 PACS2 conquest-server[437737]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:17.380832+00:00 PACS2 conquest-server[437737]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:17.380930+00:00 PACS2 conquest-server[437737]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:17.380973+00:00 PACS2 conquest-server[437737]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:17.381012+00:00 PACS2 conquest-server[437737]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:17.381051+00:00 PACS2 conquest-server[437737]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:17.381091+00:00 PACS2 conquest-server[437737]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:17.381130+00:00 PACS2 conquest-server[437737]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:17.381193+00:00 PACS2 conquest-server[437737]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:17.381566+00:00 PACS2 conquest-server[437737]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:17.566271+00:00 PACS2 conquest-server[437737]: dgate: ./src/dgate/dicomlib/array.tcc:114: DATATYPE& Array<DATATYPE>::Get(unsigned int) [with DATATYPE = BufferSpace*]: Assertion `Index<ArraySize' failed.
2023-10-18T00:25:17.566382+00:00 PACS2 conquest-server[437737]: dgate: ./src/dgate/dicomlib/array.tcc:114: DATATYPE& Array<DATATYPE>::Get(unsigned int) [with DATATYPE = BufferSpace*]: Assertion `Index<ArraySize' failed.
2023-10-18T00:25:17.580289+00:00 PACS2 conquest-server[437737]: dgate: ./src/dgate/dicomlib/array.tcc:114: DATATYPE& Array<DATATYPE>::Get(unsigned int) [with DATATYPE = BufferSpace*]: Assertio
2023-10-18T00:25:17.580611+00:00 PACS2 systemd[1]: conquest.service: Main process exited, code=killed, status=6/ABRT
2023-10-18T00:25:27.741670+00:00 PACS2 systemd[1]: conquest.service: Scheduled restart job, restart counter is at 12.
2023-10-18T00:25:27.741830+00:00 PACS2 systemd[1]: Stopped conquest.service - conquest dicom server service.
2023-10-18T00:25:27.759596+00:00 PACS2 systemd[1]: Started conquest.service - conquest dicom server service.
2023-10-18T00:25:27.773192+00:00 PACS2 conquest-server[437744]: Monitoring for files in: /zsdb/MAG0/incoming/
2023-10-18T00:25:27.774125+00:00 PACS2 conquest-server[437744]: DGATE (1.5.0d, build Sun Sep 10 18:05:15 2023, bits 64) is running as threaded server
2023-10-18T00:25:27.775182+00:00 PACS2 conquest-server[437744]: Database type: built-in SQLite driver
2023-10-18T00:25:27.876022+00:00 PACS2 conquest-server[437744]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:27.876083+00:00 PACS2 conquest-server[437744]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:27.876254+00:00 PACS2 conquest-server[437744]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:27.876354+00:00 PACS2 conquest-server[437744]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:27.876398+00:00 PACS2 conquest-server[437744]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:27.876492+00:00 PACS2 conquest-server[437744]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:27.876791+00:00 PACS2 conquest-server[437744]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:27.876939+00:00 PACS2 conquest-server[437744]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:27.879220+00:00 PACS2 conquest-server[437744]: Queue: retrying processing of file /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm
2023-10-18T00:25:27.879283+00:00 PACS2 conquest-server[437744]: ExportConverter0.0: forward /zsdb/MAG0/231002/84391689/1/1.2.826.1696224823.5672328.346.dcm to PACS3
2023-10-18T00:25:28.057774+00:00 PACS2 conquest-server[437744]: dgate: ./src/dgate/dicomlib/array.tcc:114: DATATYPE& Array<DATATYPE>::Get(unsigned int) [with DATATYPE = BufferSpace*]: Assertion `Index<ArraySize' failed.
2023-10-18T00:25:28.057910+00:00 PACS2 conquest-server[437744]: message repeated 2 times: [ dgate: ./src/dgate/dicomlib/array.tcc:114: DATATYPE& Array<DATATYPE>::Get(unsigned int) [with DATATYPE = BufferSpace*]: Assertion `Index<ArraySize' failed.]
2023-10-18T00:25:28.072285+00:00 PACS2 systemd[1]: conquest.service: Main process exited, code=killed, status=6/ABRT
Hi!
Help please - revised all, configuration,server's config and can't understand what i do wrong:
QuoteDisplay More2023-10-17T03:01:15.777405+00:00 pacs2 conquest-server[314939]: Monitoring for files in: /zsdb/MAG0/incoming/
2023-10-17T03:01:15.778366+00:00 pacs2 conquest-server[314939]: DGATE (1.5.0d, build Sun Sep 10 18:05:15 2023, bits 64) is running as threaded server
2023-10-17T03:01:15.779144+00:00 pacs2 conquest-server[314939]: Database type: built-in SQLite driver
2023-10-17T03:01:15.779415+00:00 pacs2 conquest-server[314939]: Starting 5 DelayedForwarderThreads
2023-10-17T03:01:15.779915+00:00 pacs2 conquest-server[314939]: Started 1 export queue thread(s)
2023-10-17T03:01:15.879964+00:00 pacs2 conquest-server[314939]: Queue: retrying processing of file /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm
2023-10-17T03:01:15.880101+00:00 pacs2 conquest-server[314939]: message repeated 2 times: [ Queue: retrying processing of file /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm]
2023-10-17T03:01:15.880194+00:00 pacs2 conquest-server[314939]: ExportConverter0.0: forward /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm to PACS3
2023-10-17T03:01:15.880239+00:00 pacs2 conquest-server[314939]: Queue: retrying processing of file /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm
2023-10-17T03:01:15.880277+00:00 pacs2 conquest-server[314939]: ExportConverter0.0: forward /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm to PACS3
2023-10-17T03:01:15.880614+00:00 pacs2 conquest-server[314939]: message repeated 2 times: [ ExportConverter0.0: forward /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm to PACS3]
2023-10-17T03:01:15.880973+00:00 pacs2 conquest-server[314939]: Queue: retrying processing of file /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm
2023-10-17T03:01:15.881046+00:00 pacs2 conquest-server[314939]: ExportConverter0.0: forward /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm to PACS3
2023-10-17T03:01:16.000412+00:00 pacs2 systemd[1]: conquest.service: Main process exited, code=killed, status=11/SEGV
2023-10-17T03:01:16.000726+00:00 pacs2 systemd[1]: conquest.service: Failed with result 'signal'.
2023-10-17T03:01:26.241719+00:00 pacs2 systemd[1]: conquest.service: Scheduled restart job, restart counter is at 14.
2023-10-17T03:01:26.242100+00:00 pacs2 systemd[1]: Stopped conquest.service - conquest dicom server service.
2023-10-17T03:01:26.255645+00:00 pacs2 systemd[1]: Started conquest.service - conquest dicom server service.
2023-10-17T03:01:26.269325+00:00 pacs2 conquest-server[314946]: Monitoring for files in: /zsdb/MAG0/incoming/
2023-10-17T03:01:26.270297+00:00 pacs2 conquest-server[314946]: DGATE (1.5.0d, build Sun Sep 10 18:05:15 2023, bits 64) is running as threaded server
2023-10-17T03:01:26.271255+00:00 pacs2 conquest-server[314946]: Database type: built-in SQLite driver
2023-10-17T03:01:26.271351+00:00 pacs2 conquest-server[314946]: Starting 5 DelayedForwarderThreads
2023-10-17T03:01:26.271833+00:00 pacs2 conquest-server[314946]: Started 1 export queue thread(s)
2023-10-17T03:01:26.372845+00:00 pacs2 conquest-server[314946]: Queue: retrying processing of file /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm
2023-10-17T03:01:26.373406+00:00 pacs2 conquest-server[314946]: ExportConverter0.0: forward /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm to PACS3
2023-10-17T03:01:26.373462+00:00 pacs2 conquest-server[314946]: Queue: retrying processing of file /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm
2023-10-17T03:01:26.373563+00:00 pacs2 conquest-server[314946]: Queue: retrying processing of file /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm
2023-10-17T03:01:26.373607+00:00 pacs2 conquest-server[314946]: ExportConverter0.0: forward /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm to PACS3
2023-10-17T03:01:26.373645+00:00 pacs2 conquest-server[314946]: ExportConverter0.0: forward /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm to PACS3
2023-10-17T03:01:26.373692+00:00 pacs2 conquest-server[314946]: Queue: retrying processing of file /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm
2023-10-17T03:01:26.373732+00:00 pacs2 conquest-server[314946]: ExportConverter0.0: forward /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm to PACS3
2023-10-17T03:01:26.373770+00:00 pacs2 conquest-server[314946]: Queue: retrying processing of file /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm
2023-10-17T03:01:26.373809+00:00 pacs2 conquest-server[314946]: ExportConverter0.0: forward /zsdb/MAG0/230912//124335760/1/1.2.826.1694524056.20532531.346.dcm to PACS3
2023-10-17T03:01:26.499431+00:00 pacs2 conquest-server[314946]: malloc(): invalid size (unsorted)
2023-10-17T03:01:26.510712+00:00 pacs2 systemd[1]: conquest.service: Main process exited, code=killed, status=6/ABRT
2023-10-17T03:01:26.511152+00:00 pacs2 systemd[1]: conquest.service: Failed with result 'signal'.
2023-10-17T03:01:36.741736+00:00 pacs2 systemd[1]: conquest.service: Scheduled restart job, restart counter is at 15.
2023-10-17T03:01:36.741976+00:00 pacs2 systemd[1]: Stopped conquest.service - conquest dicom server service.
2023-10-17T03:01:36.763615+00:00 pacs2 systemd[1]: Started conquest.service - conquest dicom server service.
dicom files contain utf8 - I can send them wherever you say (to a non-public place) unchanged...
or i can get you access (ssh) to my server's for experiment...
Hi!
root@pacs3:/data/conquest# ./dgate -v
Monitoring for files in: /data/conquest/MAG0/incoming/
DGATE (1.5.0d, build Mon Sep 11 06:59:33 2023, bits 64) is running as threaded server
Database type: built-in SQLite driver
dicom.ini:
root@pacs2:/data/conquest# /data/conquest/dgate -w/data/conquest -v
Monitoring for files in: /data/conquest/data/incoming/
DGATE (1.5.0d, build Sun Sep 10 22:05:15 2023, bits 64) is running as threaded server
Database type: built-in SQLite driver
Starting 5 DelayedForwarderThreads
Started 1 export queue thread(s)
dicom.ini:
via ImportConverter0 = forward to PACS3 org PACS;nop %u %m %i %o this .dcm go ok, but ImportConverter does not have retry-send...
via ExportConverter0 = forward to PACS3 org PACS;nop %u %m %i %o dgate crashed
Hi! sorry for long time answer - i was absent :-(...
how i can send dcm file to you?
Hi!
for additional debug setup one more conquest between.... and so this:
on intermediary:
after this dgate crashed
dicom.ini on intermediary:
log on PACS:
Hi!
ExportConverters "forward to" have a retry mechanism, Importconverters not.
This is an important clarification!
What OS are you on? Some Linux variants are known to give network errors on Conquest.
root@pacs:/data/conquest# uname -a
Linux pacs 6.2.16-12-pve #1 SMP PREEMPT_DYNAMIC PMX 6.2.16-12 (2023-09-04T13:21Z) x86_64 x86_64 x86_64 GNU/Linux
root@pacs:/data/conquest# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 23.04
Release: 23.04
Codename: lunar
Is regular transmission to PACS2 reliable?
yes! errors sometimes appear...
Hi!
I have one conquest srv AE:PACS and remote AE:PACS2
in dicom.ini:
...
ImportConverters = 2
ImportConverter0 = forward to PACS2; nop %u %m %i %o
[lua]
association = package.path=package.path..';'..Global.basedir..'lua/?.lua'
ImportConverter1 = dofile('/conquest/lua/ImportConverter.lua');
QueryResultConverter0 = dofile('/conquest/lua/QueryResultConverter.lua');
...
i have enable debug to file (run in conquest folder):
./dgate --debuglevel:6
./dgate --debuglog_on:debug.txt
and some time in log this:
Thu Sep 21 13:47:58 2023 ImportConverter0.0: forwarded object to PACS2
Thu Sep 21 13:48:33 2023 Importconverter0.1: nop IRIS1 MG 123456789 1.3.51.0.7.11740735244.64250.44111.45637.36524.33411.2401
Thu Sep 21 13:48:33 2023 ImportConverter0.0: Forward association closed by STUDY
Thu Sep 21 13:48:33 2023 ****** ImportConverter.lua BEGIN ******
Thu Sep 21 13:48:33 2023 ...
Thu Sep 21 13:48:33 2023 ****** ImportConverter.lua END ******
but some time this:
Sun Sep 17 13:27:47 2023 ImportConverter0.0: forwarded object to PACS2
Sun Sep 17 13:27:47 2023 PDU:Connect failed due to corrupt transmission 46
Sun Sep 17 13:27:47 2023 *** ImportConverter0.0: Forward failed to connect to host PACS2
Sun Sep 17 13:27:47 2023 Importconverter0.1: nop DS DX 123456788990 1.2.826.1694942589.958750.346
Sun Sep 17 13:27:47 2023 ****** ImportConverter.lua BEGIN ******
Sun Sep 17 13:27:47 2023 ...
Sun Sep 17 13:27:47 2023 ****** ImportConverter.lua END ******
How i can additional debug forward?
and what better/faster/correct forward in ImportConverter (before modification and SQL query) or in ExportConverter?
and how i can make guaranteed forward?
Found it : QueryResultConverter
Thank you for such good programm!
Is there a way to transcode entries in C-FIND commands using a lua script like in ImportConverter, ExportConverter and RegenConverter?
Hi!
Quotekeen to see some tests of char vs varchar
some time ago (approx 10y. ) i have test on middle dataset (~10 000 000 records) and got fixed length of row with using indexes more than one and a half times faster...
But after reading about the situation now, I see that it is not so clear-cut at the moment. need testing and compare but don't have so much dataset now...
new trouble :-))) :
***Failed MYSQLExec : UPDATE DICOMStudies SET StudyInsta = '1.3.12.2.1107.5.2.46.175148.30000023020110495129300000355', StudyDate = '20230201', StudyTime = '160108.400000', StudyID = '8c8bd3d6-18db-4d', StudyDescr = 'c-spine stand', PatientsAg = '053Y', PatientsWe = '90', StudyModal = 'MR\MRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRMRSR', PatientNam = ' Bruce J.', PatientBir = '19700404', PatientSex = 'M', PatientID = 'TEST', AccessTime = 1678125760 WHERE StudyInsta = '1.3.12.2.1107.5.2.46.175148.30000023020110495129300000355'
strlen(StudyModel) =67 but field in table structure is varchar(64)... expand field length to 70 don't fix this :-(...
and once more - (IMHO) varchar type is not good - overhead to work with varchar field in mysql too much... (in big data of course) better use static length fields text or char...
QuoteNormally backslashes should be doubled in mySQL and you do see: (ORIGINAL\\PRIMARY). The model name may be in a strange code page. Conquest would pass that as is. There are experimental options to translate ISO_IR 100 into UTF: UTF8ToDB and UTF8fromDB. You can try those.
how i can do this?
UTF8ToDB = 1
UTF8FromDB = 1
in config ? right?
i check it - it's work! thank you so much!!!
Hi!
i have try'ed all variant's :
QuoteDoubleBackSlashToDB = 0
UseEscapeStringConstants = 0
try 0,0; 0,1; 1,0
after that i uncoment debug printf recompile and get this:
line 3669 MysqlExec UPDATE DICOMImages SET SOPInstanc = '1.2.826.0.1.3680043.2.634.0.8303.20230222.135749.6', SOPClassUI = '1.2.840.10008.5.1.4.1.1.1.1', ImageNumbe = '0', ImageDate = '20230222', ImageTime = '135749', SamplesPer = '1', PhotoMetri = 'MONOCHROME1', QRows = '996', QColumns = '1432', BitsStored = '16', ImageType = 'ORIGINAL\\PRIMARY', ImagePat = 'auto3086', SeriesInst = '1.2.826.0.1.3680043.2.634.0.22165.20230222.135744.5', AccessTime = 1678099456, ObjectFile = 'auto3086/1.2.826.0.1.3680043.2.634.0.22165.20230222.135744.5_0000_000000_16780988250000.dcm', DeviceName = 'MAG0' WHERE SOPInstanc = '1.2.826.0.1.3680043.2.634.0.8303.20230222.135749.6' AND ImagePat = 'auto3086'
line 3669 MysqlExec SELECT SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,StudyInsta FROM DICOMSeries WHERE SeriesInst = '1.2.826.0.1.3680043.2.634.0.22165.20230222.135744.5' AND SeriesPat = 'auto3086'
line 3669 MysqlExec INSERT INTO DICOMSeries (SeriesInst, SeriesNumb, Modality, Manufactur, ModelName, StationNam, Institutio, SeriesPat, StudyInsta, AccessTime) VALUES ('1.2.826.0.1.3680043.2.634.0.22165.20230222.135744.5', '0', 'DX', 'NIPK ELEKTRON', '��', '��', '�÷ �� "����������� �������� �����������"', 'auto3086', '1.2.826.0.1.3680043.2.634.0.45353.20230222.135258.4', 1678099456)
***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.22165.20230222.135744.5', '0', 'DX', 'NIPK ELEKTRON', '��', '��', '�÷ �� "����������� �������� �����������"', 'auto3086', '1.2.826.0.1.3680043.2.634.0.45353.20230222.135258.4', 1678099456)
***SQL: INSERT INTO DICOMSeries (SeriesInst, SeriesNumb, Modality, Manufactur, ModelName, StationNam, Institutio, SeriesPat, StudyInsta, AccessTime) VALUES ('1.2.826.0.1.3680043.2.634.0.22165.20230222.135744.5', '0', 'DX', 'NIPK ELEKTRON', '��', '��', '�÷ �� "����������� �������� �����������"', 'auto3086', '1.2.826.0.1.3680043.2.634.0.45353.20230222.135258.4', 1678099456)
i think in Institutio field trouble - Double quotes - and fix this only via https://dev.mysql.com/doc/c-ap…l-real-escape-string.html ?
but what incorrect in the ModelName field - i don't know...
Display MoreHi,
these errors relate to formatting of strings.
Can you try to change these settings in dicom.ini:
DoubleBackSlashToDB = 0
UseEscapeStringConstants = 0
try 0,0; 0,1; 1,0
Marcel
I try'ed this without success...
and yes this issue from charset... and i did not understand why this appear when UseEscapeStringConstants = 1 ?
my knowledge in c and c++ don't enough for correct this, but i think problem here:
in StatementText variable... - i will try to delete comment from SystemDebug.printf, recompile and check log...
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!