BUG 1.4.14beta: SQL Error

sf · Apr 17th 2008

With 1.4.13 it works probably with 1.4.14b. NOT

Error occurs by sending Images from Fuji CR to CQ

Code

#####################################################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()

Code

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()

Display More

marcelvanherk · Apr 17th 2008

Hi,

can you re-install the server and try again? I think you somehow have the DICOM.SQL for DBASEIII and use it with a MySQL database that was correctly made.

Marcel

sf · Apr 28th 2008

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

thank you very much

sf

BUG 1.4.14beta: SQL Error

Participate now!

Share