Posts by sf

sorry - you are right.
i forgot to change die dicom.sql to the postgres.

thank you very much

sf

With 1.4.13 it works probably with 1.4.14b. NOT

Error occurs by sending Images from Fuji CR to CQ

#####################################################Wed Apr 16 11:40:40 2008 ***Unable to DB.Add()Wed Apr 16 11:40:40 2008 ***SQL: INSERT INTO DICOMImages (SOPInstanc,SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTWed Apr 16 11:40:40 2008 ***Error: Unknown column 'PatientNam' in 'fieldlist'Wed Apr 16 11:40:40 2008 ***Error saving to SQL:10437652/1.2.392.200036.9125.3.112193711948.64550870350.190463_1001_001001_12083Wed Apr 16 11:41:13 2008 ***Failed MYSQLExec : INSERT INTO DICOMImages(SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime,Wed Apr 16 11:41:13 2008 ***Error: Unknown column 'PatientNam' in 'fieldlist'Wed Apr 16 11:41:13 2008 ***Unable to DB.Add()Wed Apr 16 11:41:13 2008 ***SQL: INSERT INTO DICOMImages (SOPInstanc,SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTWed Apr 16 11:41:13 2008 ***Error: Unknown column 'PatientNam' in 'fieldlist'Wed Apr 16 11:41:13 2008 ***Error saving to SQL:10437652/1.2.392.200036.9125.3.112193711948.64550870350.190463_1001_001001_12083Wed Apr 16 11:41:46 2008 ***Failed MYSQLExec : INSERT INTO DICOMImages(SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime,Wed Apr 16 11:41:46 2008 ***Error: Unknown column 'PatientNam' in 'fieldlist'Wed Apr 16 11:41:46 2008 ***Unable to DB.Add()

Columns     :
PatientID,PatientNam,PatientBir,PatientSex,StudyInsta,ReqPhysici,Modality
Where       : AccessionN = '140438'
Order       : (null)
Query Tables: DICOMImages
Columns     : ObjectFile, DeviceName
Where       : SOPInstanc =
'1.2.392.200036.9125.9.0.118485854.6556416.635121783' AND ImagePat =
'10846501'
Order       : (null)
FreeStore Left 5290 on /data/conquest_images_1/
Add to Table: DICOMImages
Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate,
AcqTime, AcqNumber, SamplesPer, PhotoMetri, Rows, Colums, BitsStored,
ImageType, ImagePat, PatientNam, PatientBir, PatientSex, StudyInsta,
StudyDate, StudyTime, StudyDescr, SeriesNumb, SeriesDate, SeriesTime,
Modality, Manufactur, SeriesInst, AccessTime, ObjectFile, DeviceName
Values: '1.2.392.200036.9125.9.0.118485854.6556416.635121783',
'1.2.840.10008.5.1.4.1.1.1', '1001', '20080417', '075725.109', '20080417',
'075715.359', '001', '1', 'MONOCHROME1', '1760', '2140', '10',
'DERIVED\\PRIMARY\\POST_PROCESSED\\100000', '10846501', 'NACHN^VORN',
'19220528', 'F', '1.2.840.113619.6.95.31.0.3.4.1.6018.13.140438',
'20080417', '075647.000', 'Rö. Thoraxbereich', '1001', '20080417',
'075715.000', 'CR', 'FUJIFILM Corporation',
'1.2.392.200036.9125.3.112193711948.64550937433.19162', 1208416992,
'10846501/1.2.392.200036.9125.3.112193711948.64550937433.19162_1001_001001_12084170160001.v2',
'MAG0'
***Failed MYSQLExec : INSERT INTO DICOMImages (SOPInstanc, SOPClassUI,
ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, AcqNumber, SamplesPer,
PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, PatientNam,
PatientBir, PatientSex, StudyInsta, StudyDate, StudyTime, StudyDescr,
SeriesNumb, SeriesDate, SeriesTime, Modality, Manufactur, SeriesInst,
AccessTime, ObjectFile, DeviceName) VALUES
('1.2.392.200036.9125.9.0.118485854.6556416.635121783',
'1.2.840.10008.5.1.4.1.1.1', '1001', '20080417', '075725.109', '20080417',
'075715.359', '001', '1', 'MONOCHROME1', '1760', '2140', '10',
'DERIVED\\PRIMARY\\POST_PROCESSED\\100000', '10846501', 'NACHN^VORN',
'19220528', 'F', '1.2.840.113619.6.95.31.0.3.4.1.6018.13.140438',
'20080417', '075647.000', 'Rö. Thoraxbereich', '1001', '20080417',
'075715.000', 'CR', 'FUJIFILM Corporation',
'1.2.392.200036.9125.3.112193711948.64550937433.19162', 1208416992,
'10846501/1.2.392.200036.9125.3.112193711948.64550937433.19162_1001_001001_12084170160001.v2',
'MAG0')
***Error: Unknown column 'PatientNam' in 'field list'
PatientNam
***Unable to DB.Add()

Howto compile CQ with mysql for Linux
tested with the 1.4.13 and 1.4.14beta

1. Extract source
2. Extract jped

3. write create script

g++ -DUNIX -DNATIVE_ENDIAN=1 -DNOINTJPEG -DUSEMYSQL total.cxx -o dgate -lpthread -L/usr/lib/mysql -lmysqlclient

changes in the source

4. => odbci.hpp:61
VOR 61:#include "C:\mysql-5.0.22-win32\include\mysql.h"
NACH 61:#include "/usr/include/mysql/mysql.h"

6. change de dicom.sql.postgres to dicom.sql

7. configigure dicom.ini
# Host, database, username and password for postgres server
SQLHost = localhost
SQLServer = conquest
Username = conquestuser
Password = ypurmysqlpass
MySQL = 1

okey. thanks, i use AE-Titles without any "_ "and "- ". And it works fine

mh..

is this the first time you want to use this?
Did it work, any time befor?

=> you can regen de DB.
=> enought space left on hd?

set debuglevel and psot the output.

something like this:

AE_A3 172.17.1.16 104 un

Hey,

is this the right way to tell you a bug?

You kown i use the
ExportConverter0 = forward to AE_A1;

i must write forward to AE_A1;

if i want to send to AE-A1
there musst be an error.

But wen i want to triger from the Client (Kpacs) it must be the right way, if i want to get the images,

you know waht i mean

greez

hey,

i only kown that conquest have this feature.
I think it is doumentet in de windows-howto.pdf in your conquest dir.

greez

you have an PM

thanks for this info:

by the "start-stop-daemon" you musst do "--" bevor

linke:

start-stop-daemon --start --quiet --oknodo --chdir /opt/conquest --background --make-pidfile $PIDFILE --pidfile $PIDFILE --startas $DAEMON -- -^/opt/conquest/logfile

Question:

do this logfile "auto-rotate" or is it LIMI in it's size.?
greez

Hello,

i use my conquest under linux.
i want to know where the logfile is?

i start dgate as an daemn with the start-stop-daemon under debian.

here is my script:

PATH=/sbin:/bin:/usr/sbin:/usr/bin


. /lib/lsb/init-functions


NAME=conquest
DAEMON=/opt/conquest/dgate
PIDFILE=/var/run/dgate.pid


test -x $DAEMON || exit 5


if [ -r /etc/default/$NAME ]; then
        . /etc/default/$NAME
fi




RUNASUSER=conquest
UGID=$(getent passwd $RUNASUSER | cut -f 3,4 -d:) || true


case $1 in
        start)
                log_daemon_msg "Starting conquest server" "dgate"
                if [ -z "$UGID" ]; then
                        log_failure_msg "user \"$RUNASUSER\" does not exist"
                        exit 1
                fi
                start-stop-daemon --start --quiet --oknodo --chdir /opt/conquest --background --make-pidfile $PIDFILE --pidfile $PIDFILE --startas $DAEMON -v 
                log_end_msg $?
                ;;
        stop)
                log_daemon_msg "Stopping conquest server" "dgate"
                start-stop-daemon --stop --quiet --oknodo --pidfile $PIDFILE
                log_end_msg $?
                rm -f $PIDFILE
                ;;
        status)
                pidofproc -p $PIDFILE $DAEMON >/dev/null
                status=$?
                if [ $status -eq 0 ]; then
                        log_success_msg "conquest server is running"
                else
                        log_failure_msg "conquest server is not running."
                fi
                exit $status
                ;;
        *)
                echo "Usage: $0 {start|stop|status}"
                exit 2
                ;;
esac

should i add an parameter with the path to the logfile?
greez
sf

cool

Yes I want to test this for you!

greets

SUPER! It works.

Thank you very much

an nother question:

it is possible to do somesink like this

I wan't to forward all Images wehre
ReferPhysi LIKE 'HE%'
and Additionally all images for this patient of the 2 last years.
But only the images form the same modality as the actually pics.

thanks

For Info:

i do this SQl-Querry via phpmyadmin and i geht a positiv result:

SELECT *
FROM `DICOMImages` , `DICOMSeries` , `DICOMStudies` , `DICOMPatients`
WHERE (
ReferPhysi LIKE 'HE%'
)
AND DICOMImages.SopInstanc = '1.2.392.200036.9125.9.0.118441489.231213824.635121783'
AND DICOMStudies.PatientID = DICOMPatients.PatientID
AND DICOMImages.SeriesInst = DICOMSeries.SeriesInst
AND DICOMSeries.StudyInsta = DICOMStudies.StudyInsta
AND DICOMImages.ImagePat = '10848245'
LIMIT 0 , 30

oh soory you're right:

I exported the log in an textfile, so it is now complete:
./dgate -v >> serverstatus.log

UPACS THREAD 1: ENDED AT: Fri Feb 22 09:47:40 2008
UPACS THREAD 1: TOTAL RUNNING TIME: 0 SECONDS
Query Tables: DICOMImages, DICOMSeries, DICOMStudies, DICOMPatients
Columns     : DicomImages.ObjectFile
Where       : (ReferPhysi LIKE 'HE%') and DICOMImages.SopInstanc = '1.2.392.200036.9125.9.0.118441489.231213824.635121783' and DICOMStudies.PatientID = DICOMPatients.PatientID and DICOMImages.SeriesInst = DICOMSeries.SeriesInst and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta AND DICOMImages.ImagePat = '10848245'
Order       : (null)
***Filter: Unable to query for image record
UPACS THREAD 0: ENDED AT: Fri Feb 22 09:47:40 2008
UPACS THREAD 0: TOTAL RUNNING TIME: 1 SECONDS

can you see anything.
thanks
SF

Hello,

i have following:

*Debian Etch 2.6.18-5-amd64 (64 BIT)
*./dgate -version
DGATE (1.4.13, build Thu Feb 21 14:40:36 2008) is running as threaded server
Started 1 export queue thread(s)
*and MySQL 5.0.32

I have fixed the
odbci.hpp and changed the path of mysql.h

i compiled it with this
g++ -DUNIX -DNATIVE_ENDIAN=1 -DNOINTJPEG -DUSEMYSQL total.cxx -o dgate -lpthread -L/usr/lib/mysql -lmysqlclient

And it works fine.
Now i wan't to add a Autoforward

All Images with
ReferPhysi LIKE 'HE%'
should forward to AE_Fisch

i do this:
ExportConverters = 1
ExportFilter0 = ReferPhysi LIKE 'HE%'
ExportConverter0 = forward to AE_FISCH

In the Log:

Query Tables: DICOMImages
Columns : ObjectFile, DeviceName
Where : SOPInstanc = '1.2.392.200036.9125.9.0.118487311.202050304.635121783' AND ImagePat = '10848180'
Order : (null)
Query Tables: DICOMImages
Columns : SOPInstanc,SOPClassUI,ImageNumbe,ImageDate,ImageTime,EchoNumber,NumberOfFr,AcqDate,AcqTime,ReceivingC,AcqNumber,SliceLocat,SamplesPer,PhotoMetri,Rows,Colums,BitsStored,ImageType,ImageID,ImagePat,SeriesInst
Where : SOPInstanc = '1.2.392.200036.9125.9.0.118487311.202050304.635121783' AND ImagePat = '10848180'
Order : (null)
Update Table: DICOMImages
Updates : SOPInstanc = '1.2.392.200036.9125.9.0.118487311.202050304.635121783', SOPClassUI = '1.2.840.10008.5.1.4.1.1.1', ImageNumbe = '1003', ImageDate = '20080219', ImageTime = '101228.203', AcqDate = '20080219', AcqTime = '101215.312', AcqNumber = '018', SamplesPer = '1', PhotoMetri = 'MONOCHROME1', Rows = '2140', Colums = '1760', BitsStored = '10', ImageType = 'DERIVED\\PRIMARY\\POST_PROCESSED\\100000', ImagePat = '10848180', SeriesInst = '1.2.392.200036.9125.3.112193711948.64545759538.1828196', AccessTime = 1203608832, ObjectFile = '10848180/1.2.392.200036.9125.3.112193711948.64545759538.1828196_1001_001003_12035979670188.v2', DeviceName = 'MAG0'
Where : SOPInstanc = '1.2.392.200036.9125.9.0.118487311.202050304.635121783' AND ImagePat = '10848180'
Written file: ./data/10848180/1.2.392.200036.9125.3.112193711948.64545759538.1828196_1001_001003_12035979670188.v2
Arena 0:
system bytes = 7569408
in use bytes = 315424
Arena 1:
system bytes = 135168
in use bytes = 2240
Total (incl. mmap):
system bytes = 8839168
in use bytes = 1452256
max mmap regions = 7
max mmap bytes = 23744512
C-Move (StudyRoot)
Arena 0:
system bytes = 7569408
in use bytes = 346608
Arena 1:
system bytes = 135168
in use bytes = 2240
Total (incl. mmap):
system bytes = 8839168
in use bytes = 1483440
max mmap regions = 7
max mmap bytes = 23744512
UPACS THREAD 3: ENDED AT: Thu Feb 21 15:47:27 2008
UPACS THREAD 3: TOTAL RUNNING TIME: 0 SECONDS
Query Tables: DICOMImages, DICOMSeries, DICOMStudies, DICOMPatients
Columns : DicomImages.ObjectFile
Where : (ReferPhysi LIKE 'HE%') and DICOMImages.SopInstanc = '1.2.392.200036.9125.9.
Inst = DICOMSeries.SeriesInst and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta AND DIC
Order : (null)
***Filter: Unable to query for image record
UPACS THREAD 2: ENDED AT: Thu Feb 21 15:47:28 2008
UPACS THREAD 2: TOTAL RUNNING TIME: 1 SECONDS

Without a filter ist works..

thanks for your help