We have 3 Fuji CR, including 1 Profect. The images are sending directly to conquest with no problem (more or less).
The only problem is with MAMMO that the QA image layer are not being sent to conquest, so the image is not suitable for radiologists. What does LUT mean ? As we have a HIC station, the x-ray tech, send the images to HIC too.
Any one has some solution ?
Carlos Alexandre
On the botton of page n.51, there is a reference of how to start each server on different TCP port. I tried but with no success. I ran a program to monitor the TCP ports opened (tcpview), but saw nothing, except 5678 (default).
in fact:
1) running conquest on different ports is the perfomance improved ?
2) what is the side effects ?
3) and how to start: what does mean alt-right ?
tks.
Carlos Alexandre
You just have to configure a Printer SCU (US, CR, CT, etc) device to point the conquest server.
When conquest receive the image, it prints on windows default printer.
Just like that !
I correct the syntax, removing the trailing ',' in all series, but error persist.
Perhaps the size of the string ? Too long ?
May the DCMStudydata property be to shoort for this study ?
I configured the Fuji Profect CR to read worklist from Conquest. The worklist table was loaded and the query from wlm SCU work, but:
[PACSFE1] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.ReqProcID
[PACSFE1] Values: DICOMWorkList.Modality = 'CR' and DICOMWorkList.ScheduledA = '' and DICOMWorkList.StartDate = '20070209'
[PACSFE1] Tables: DICOMWorkList
On this day, there was more than 100 records, but conquest return none.
The reason was the oracle field table DICOMWorkList.ScheduledA is NULL, and NULL is <> ''. I try to set the field to '', and the result was the same.
My suggestion to Conquest is if some field in the query is '', this field should not be included. In this case, only DICOMWorkList.Modality = 'CR' and DICOMWorkList.StartDate = '20070209'.
Second: how can I workround this problem without filling the field ? I can not because we have 3 CR and all 3 do the same job with different StationName.
tks,
looking in Documents and Settings\"Current User name"\Local Settings\Temporary Internet Files\DCMViewerCache
In fact, I do not swee th directoy DCMViewerCache, even with IE/ezDICOM loaded. And the images it self are located in
Documents and Settings\"Current User name"\Local Settings\Temporary Internet Files
I say that because I am testing the OCX that you provide. I convert to PHP/Oracle and is in testing phase. My ideia is to publish the php/oracle/apache solution. But I am experiance some 'strange' error, perhaps you could help:
Read beyong end of file
Catastrofic Fail (the sentece appears to my in Protugues - my lang)
This is a CT study. Below is the provide PARAM to OCX. Is it correct ? What is the syntax ?
PARAM name="DCMStudydata" value="ANA_JULIA_EUFRASIO|ANA JULIA EUFRASIO-CT-20070129--BASE 3MM-||1.3.12.2.1107.5.1.1.20706.20070129211803318.3|
CT000005|http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211858751.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211840121.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211833931.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211846332.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211827741.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211815291.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211821551.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211906051.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211808181.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211803318.3/1.3.12.2.1107.5.1.1.20706.20070129211852541.4.dcm,||1.3.12.2.1107.5.1.1.20706.20070129211424469.3|
CT000003|http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211515203.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211457331.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211518002.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211503141.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211511940.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211506231.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211500243.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211520691.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211445792.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211424469.3/1.3.12.2.1107.5.1.1.20706.20070129211509003.4.dcm,||1.3.12.2.1107.5.1.1.20706.20070129211515905.3|
CT000004|http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211600881.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211606332.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211537402.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211552004.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211555324.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211557901.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211546251.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211540421.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211549081.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211515905.3/1.3.12.2.1107.5.1.1.20706.20070129211543211.4.dcm,||1.3.12.2.1107.5.1.1.20706.20070129211907500.3|
CT000006|http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129211930771.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129211924561.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129211936971.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129211955591.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129211949361.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129211918371.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129212001761.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129211912082.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129212008011.4.dcm,http://10.60.64.21/img/1.3.12.2.1107.5.1.1.20706.20070129210932983.2/1.3.12.2.1107.5.1.1.20706.20070129211907500.3/1.3.12.2.1107.5.1.1.20706.20070129211943151.4.dcm,||1.3.12.2.1107.5.1.1.20706.20070129211310869.3|
CT000002|http://10.60.64.21/img/1.3.12.…6.20070129211342251.4.dcm,">
tks
Eduard,
Exists some method/way to clear cache before open ActiveX ? Or
Where the cache is stored ?
Thank????s
Carlos Alexandre
Marcel,
When I change the dicom.ini paramenter WorkListMode from 1 to 0, I saw no more error. I am filling a 250GB with images from CT (incl. MAMMO), MR and CR for testing. Until now, no errors.
Carlos Alexandre
Marcel,
For further information, the error occurs with
WorkListMode = 1
when I change to 0, the error does not happen.
Carlos Alexandre
Quote from PatjeDisplay Moretry to use "password" Quote before and after
another prolem when rebuilding the database,
[CONQUESTSRV1] ***Error: 936: S1000: [Oracle][ODBC][Ora]ORA-00936: missing expression
any ideas???
YES,
The error is on SELECT. I discovered by enabling debug GUI. There is an [AND[/b] after WHERE ????
[PACSFE1] ***Failed SQLExecDirect : SELECT StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,StationNam,Institutio,PatientNam,PatientBir,PatientSex,PatientID FROM DICOMStudies WHERE AND PatientID = '725772'
[PACSFE1] ***Error: 936: S1000: [Oracle][ODBC][Ora]ORA-00936: missing expression
I do not know how to solve !!!!!
-------------------------------------------------------------
PACSFE1] 0000,0002 26 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.1"
[PACSFE1] 0000,0100 2 US CommandField 1
[PACSFE1] 0000,0110 2 US MessageID 10
[PACSFE1] 0000,0700 2 US Priority 0
[PACSFE1] 0000,0800 2 US DataSetType 0
[PACSFE1] 0000,1000 54 UI AffectedSOPInstanceU "1.2.392.200036.9125.4.0.84872214.3976598528.841116714"
[PACSFE1] [recompress]: recompressed with mode = j2 (strip=0)
[PACSFE1] Importconverter0.0 executes: ifequal "NONE","MAMMOGRAPHIC"
[PACSFE1] Importconverter0.1 not executed because of previous statement
[PACSFE1] FreeStore Left 235948 on F:\
[PACSFE1] ***Failed SQLExecDirect : SELECT StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,StationNam,Institutio,PatientNam,PatientBir,PatientSex,PatientID FROM DICOMStudies WHERE AND PatientID = '725772'
[PACSFE1] ***Error: 936: S1000: [Oracle][ODBC][Ora]ORA-00936: missing expression
[PACSFE1] ***Error saving to SQL: \1.2.392.200036.9125.3.20345042108.64512605134.18922340\1.2.392.200036.9125.4.0.84872214.3976598528.841116714.dcm
[PACSFE1] UPACS THREAD 1: ENDED AT: Wed Feb 07 17:40:37 2007
[PACSFE1] UPACS THREAD 1: TOTAL RUNNING TIME: 42 SECONDS
On Server Status Window, I enable debug, and when I send an image to the server, happens an error on SELECT. See bellow:
[PACSFE1] ***Failed SQLExecDirect : SELECT PatientID,PatientNam,PatientBir,PatientSex,StudyInsta,Modality FROM DICOMWorkList WHERE 2AccessionN = '844814'
Strange the number 2 before AccessionN ???
Can I bypass this ?
------------------------------------------
[PACSFE1] set debug level from GUI
[PACSFE1] set debug log from GUI
[PACSFE1]
[PACSFE1] UPACS THREAD 0: STARTED AT: Wed Feb 07 17:29:35 2007
[PACSFE1] A-ASSOCIATE-RQ Packet Dump
[PACSFE1] Calling Application Title : "INPACSS1 "
[PACSFE1] Called Application Title : "PACSFE1 "
[PACSFE1] Application Context : "1.2.840.10008.3.1.1.1"
[PACSFE1] Number of Proposed Presentation Contexts: 3
[PACSFE1] Presentation Context 0 "1.2.840.10008.5.1.4.1.1.2"
[PACSFE1] Presentation Context 1 "1.2.840.10008.5.1.4.1.1.4"
[PACSFE1] Presentation Context 2 "1.2.840.10008.5.1.4.1.1.1"
[PACSFE1] Server Command := 0001
[PACSFE1] 0000,0002 26 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.1"
[PACSFE1] 0000,0100 2 US CommandField 1
[PACSFE1] 0000,0110 2 US MessageID 1
[PACSFE1] 0000,0700 2 US Priority 0
[PACSFE1] 0000,0800 2 US DataSetType 0
[PACSFE1] 0000,1000 54 UI AffectedSOPInstanceU "1.2.392.200036.9125.9.0.251991489.3556769984.756118910"
[PACSFE1] [recompress]: recompressed with mode = j2 (strip=0)
[b][PACSFE1] ***Failed SQLExecDirect : SELECT PatientID,PatientNam,PatientBir,PatientSex,StudyInsta,Modality FROM DICOMWorkList WHERE 2AccessionN = '844814'[b]
[PACSFE1] ***Error: 920: S1000: [Oracle][ODBC][Ora]ORA-00920: invalid relational operator
[PACSFE1] Importconverter0.0 executes: ifequal "NONE","MAMMOGRAPHIC"
[PACSFE1] Importconverter0.1 not executed because of previous statement
[PACSFE1] FreeStore Left 235953 on F:\
[PACSFE1] Written file: F:\DICOMDIR\1.2.392.200036.9125.2.691110677.64512586043.596491\1.2.392.200036.9125.3.691110677.64512586043.596492\1.2.392.200036.9125.9.0.251991489.3556769984.756118910.dcm
[PACSFE1] Server Command := 0001
[PACSFE1] 0000,0002 26 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.1"
[PACSFE1] 0000,0100 2 US CommandField 1
[PACSFE1] 0000,0110 2 US MessageID 2
[PACSFE1] 0000,0700 2 US Priority 0
[PACSFE1] 0000,0800 2 US DataSetType 0
[PACSFE1] 0000,1000 54 UI AffectedSOPInstanceU "1.2.392.200036.9125.9.0.251991490.2801795264.756118910"
[PACSFE1] [recompress]: recompressed with mode = j2 (strip=0)
[PACSFE1] Importconverter0.0 executes: ifequal "NONE","MAMMOGRAPHIC"
[PACSFE1] Importconverter0.1 not executed because of previous statement
[PACSFE1] FreeStore Left 235950 on F:\
[PACSFE1] Written file: F:\DICOMDIR\1.2.392.200036.9125.2.691110677.64512586043.596491\1.2.392.200036.9125.3.691110677.64512586176.596496\1.2.392.200036.9125.9.0.251991490.2801795264.756118910.dcm
[PACSFE1] UPACS THREAD 0: ENDED AT: Wed Feb 07 17:29:39 2007
[PACSFE1] UPACS THREAD 0: TOTAL RUNNING TIME: 4 SECONDS
I discovery some Oracle errors by enabling the tracing on ODBC conection (Contol Painel). Windows records a log which can be viewed, but it????s a long one.
The my problem of password with %%, I tried puting escape (\%\%) and between '.
But, with double quote (") WORKS !!!!!!
Thank????s
I forgot:
The real password is hsl%%des1
Hi,
I have been succeden in working with Coquent on DBase III. But, now, as the IT Hospital solution is on Oracle plataform, I move Conquest to Oracle.
But something odd happens: the OS is Windows, 1.4.12c, Oracle 10G.
When I run throught interface (no service), works fine, but when I run as service, a password error occurs. The odd is that the password have 2 '%' on it.
the Troublelog shows the following:
20070206 23:01:39 ***Error connecting datasource:conquest1 user:itsok password:hsl2009202249es1
where I put the password between ',
20070206 22:51:56 ***Error connecting datasource:conquest1 user:hslgestao password:hsl\\13762540es1
I would like do not change the password, so.
I????ll be glad for some help ....
