ERROR on SELECT on work list (debug)

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

Marcel,

For further information, the error occurs with

WorkListMode = 1

when I change to 0, the error does not happen.

Carlos Alexandre

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,