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