Posts by mmarauch

Hi,

I found the eFilm 1.5.3 Version and after installation the query from it to conquest works very fine.

I thank you all for your help

Andreas

Hi,

thank you for your suggestion. But I don’t have any fields with NULL in the tables Patients and Studys.

I tried now a third installation, now with MS SQL Express 2005. And you guess, the same in yellow.
I don’t understand it, because all is going but the request from eFilm to conquest when I use any Database but the Built-in DBASEIII without ODBC. Why do the DBASE work and not the other?

I believe we must install a newer version from eFilm. As I know the last free version is 1.5? Can anyone help me where I can get it? Or can you give me a good alternative for eFilm, as possible free? You know, veterinarys have no much money

Thanks
Andreas

Hi,

Conquest – 1.4.14
MySQL – 5.1.34

I tried the installation two times as per description in the windowsmanual.pdf, appendix 2 without php and apache. First with Native MySQL and second the current with ODBC. In both versions are the same issues.

marcelvanherk – your tip doesn’t sadly work.

Not that I am aware but I don’t believe that it is a MySQL configuration error because the query from conquest works. As I understand the query to MySQL comes in both cases from conquest? eFilm make the request at conquest and not at the MySQL directly, or is it incorrect?

Andreas

Hi,

thanks for your fast reply. Here is the log from conquest:

[CONQUESTSRV1]
[CONQUESTSRV1] UPACS THREAD 419: STARTED AT: Thu May 28 09:39:41 2009
[CONQUESTSRV1] A-ASSOCIATE-RQ Packet Dump
[CONQUESTSRV1] Calling Application Title : "AE_TITLE "
[CONQUESTSRV1] Called Application Title : "CONQUESTSRV1 "
[CONQUESTSRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384
[CONQUESTSRV1] Number of Proposed Presentation Contexts: 1
[CONQUESTSRV1] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
[CONQUESTSRV1] Server Command := 0020
[CONQUESTSRV1] Message ID := 001f
[CONQUESTSRV1] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.2.2.1"
[CONQUESTSRV1] 0000,0100 2 US CommandField 32
[CONQUESTSRV1] 0000,0110 2 US MessageID 31
[CONQUESTSRV1] 0000,0700 2 US Priority 0
[CONQUESTSRV1] 0000,0800 2 US DataSetType 258
[CONQUESTSRV1] (StudyRootQuery) search level: STUDY
[CONQUESTSRV1] 0008,0020 0 DA StudyDate (empty)
[CONQUESTSRV1] 0008,0030 0 TM StudyTime (empty)
[CONQUESTSRV1] 0008,0050 2 SH AccessionNumber "*"
[CONQUESTSRV1] 0008,0052 6 CS QueryRetrieveLevel "STUDY "
[CONQUESTSRV1] 0008,0090 2 PN ReferringPhysicianNa "*"
[CONQUESTSRV1] 0008,1030 0 LO StudyDescription (empty)
[CONQUESTSRV1] 0008,1040 0 LO InstitutionalDepartm (empty)
[CONQUESTSRV1] 0010,0010 2 PN PatientName "*"
[CONQUESTSRV1] 0010,0020 2 LO PatientID "*"
[CONQUESTSRV1] 0010,0030 0 DA PatientBirthDate (empty)
[CONQUESTSRV1] 0010,0040 0 CS PatientSex (empty)
[CONQUESTSRV1] 0020,000d 0 UI StudyInstanceUID (empty)
[CONQUESTSRV1] 0020,0010 0 SH StudyID (empty)
[CONQUESTSRV1] Query On Study
[CONQUESTSRV1] Failed on VR Search: 0008 1040
[CONQUESTSRV1] (testing phase) - ignored
[CONQUESTSRV1] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID
[CONQUESTSRV1] Values: DICOMStudies.AccessionN LIKE '%' and DICOMStudies.ReferPhysi LIKE '%' and DICOMStudies.PatientNam LIKE '%' and DICOMStudies.PatientID LIKE '%'
[CONQUESTSRV1] Tables: DICOMStudies
[CONQUESTSRV1] Sorting (DICOMStudies.PatientNam) DoSort := 1
[CONQUESTSRV1] Query Distinct Tables: DICOMStudies
[CONQUESTSRV1] Columns : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID
[CONQUESTSRV1] Where : DICOMStudies.AccessionN LIKE '%' and DICOMStudies.ReferPhysi LIKE '%' and DICOMStudies.PatientNam LIKE '%' and DICOMStudies.PatientID LIKE '%'
[CONQUESTSRV1] Order : DICOMStudies.PatientNam
[CONQUESTSRV1] Records = 0
[CONQUESTSRV1] C-Find (StudyRoot) located 0 records
[CONQUESTSRV1] UPACS THREAD 419: ENDED AT: Thu May 28 09:39:42 2009
[CONQUESTSRV1] UPACS THREAD 419: TOTAL RUNNING TIME: 1 SECONDS

This was an empty query but its the same issue as with an existing dataset.

Andreas

Hi,
at first, i am a newbie with dicom, pacs , efilm, conquest and in this forum. Hi all.

Please pardon my bad English.

We have a new purchase, a veterinary. He would save the dicom files in an archive and databasesystem like conquest. (At now the data is local stored on one eFilm PC)

My first test-installation was the conquest server with the Build-In Dbase II Database. On a separate PC runs an eFilm 1.4 Client. After short trouble the system runs very well. But we have 200 GB dicom files and I belief a MySQL Server is the better solution for the future. So I was very motivated to install a MySQL Server and the Conquest again, but this doesn’t work. I installed the server like the windowsmanual.pdf and the ODBC configuration. I also installed the server with Nativ MySQL driver. Both are the same issue.

I can query the database from conquest, send data from conquest to the eFilm client and send data from eFilm to conquest. But the important, query the database from the eFilm client doesn’t work. I had no error at the eFilm client. The log on the Conquest is:

[CONQUESTSRV1] UPACS THREAD 416: STARTED AT: Thu May 28 00:02:08 2009
[CONQUESTSRV1] Calling Application Title : "AE_TITLE "
[CONQUESTSRV1] Called Application Title : "CONQUESTSRV1 "
[CONQUESTSRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384
[CONQUESTSRV1] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
[CONQUESTSRV1] (StudyRootQuery) search level: STUDY
[CONQUESTSRV1] C-Find (StudyRoot) located 0 records
[CONQUESTSRV1] UPACS THREAD 416: ENDED AT: Thu May 28 00:02:08 2009
[CONQUESTSRV1] UPACS THREAD 416: TOTAL RUNNING TIME: 0 SECONDS

Here I realize that the search level is STUDY, at the first installation the search level was PATIENT? Also the search level from conquest is PATIENT, look here: (works)

[CONQUESTSRV1] UPACS THREAD 417: STARTED AT: Thu May 28 00:02:36 2009
[CONQUESTSRV1] Calling Application Title : "CONQUESTSRV1 "
[CONQUESTSRV1] Called Application Title : "CONQUESTSRV1 "
[CONQUESTSRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384
[CONQUESTSRV1] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.1.1" 1
[CONQUESTSRV1] Presentation Context 1 "1.2.840.10008.5.1.4.1.2.2.1" 1
[CONQUESTSRV1] Presentation Context 2 "1.2.840.10008.5.1.4.1.2.3.1" 1
[CONQUESTSRV1] Presentation Context 3 "1.2.840.10008.5.1.4.31" 1
[CONQUESTSRV1] (PatientRootQuery) search level: PATIENT
[CONQUESTSRV1] C-Find (PatientRoot) located 2 records
[CONQUESTSRV1] UPACS THREAD 417: ENDED AT: Thu May 28 00:02:37 2009
[CONQUESTSRV1] UPACS THREAD 417: TOTAL RUNNING TIME: 1 SECONDS

Can anyone help me ore have an idea where i have to look?

tia Andreas