Posts by gorec2005

    Hi!


    i was remove %callingae

    (FileNameSyntax = %studydate[2,7]/%id/%seriesid/%sopuid.dcm) result:

    Hi!


    Help please - revised all, configuration,server's config and can't understand what i do wrong:

    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!

    for additional debug setup one more conquest between.... and so this:

    on intermediary:

    Code
    ExportConverter0.0: forward /data/conquest/data/22062125738/1.2.826.1695649623.12689047.130_0001_000001_16958809360000.dcm to PACS-BRP
    dgate: ./src/dgate/dicomlib/array.tcc:114: DATATYPE& Array<DATATYPE>::Get(unsigned int) [with DATATYPE = BufferSpace*]: Assertion `Index<ArraySize' failed.
    Aborted

    after this dgate crashed :-(


    dicom.ini on intermediary:

    Code
    ExportConverters = 1
    ExportConverter0 = forward to PACS org PACS2

    log on PACS:

    Code
    Thu Sep 28 10:00:27 2023 ***No valid presentation contexts/transfer syntax found in 0 candidates
    Thu Sep 28 10:00:27 2023 ***In 0 presentation contexts
    Thu Sep 28 10:00:27 2023 ***#Possible transfer syntaxes: 13
    Thu Sep 28 10:00:27 2023 *** multiplex: connection terminated

    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?

    Hi!

    Quote

    keen 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 :-))) :

    Code
    ***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'
    ***Error: Data too long for column 'StudyModal' at row 1

    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...

    Quote

    Normally 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 :

    Quote

    DoubleBackSlashToDB = 0

    UseEscapeStringConstants = 0

    try 0,0; 0,1; 1,0

    after that i uncoment debug printf recompile and get this:


    Code
    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)
    ***Error: Incorrect string value: '\xC4\xC6' for column 'ModelName' at row 1
    ***Unable to DB.Add()
    ***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)
    ***Error: Incorrect string value: '\xC4\xC6' for column 'ModelName' at row 1
    ***Error saving to SQL: auto3086/1.2.826.0.1.3680043.2.634.0.22165.20230222.135744.5_0000_000000_16780988250000.dcm

    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...


    Code
    ModelName

    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:

    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!