Hi,
I am running conquest versions 1.4.17d and 1.4.15 and I have started getting the following error when receiving images. We use postgres version 9 with Redhat 7.
QuoteDisplay More
***Unable to update record
***SQL: UPDATE DICOMStudies SET StudyInsta = '1.2.841.113619.6.95.31.0.3.4.1.1109.13.2242784', StudyDate = '20150205', StudyTime = '114246.328000', StudyID = '2402784', StudyDescr = 'My Scan', AccessionN = 'C2232784', ReferPhysi = 'JONES^ GRAEME', PatientsAg = '021Y', StudyModal = 'CT\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\NM', PatientNam = 'SOMEONE^BLAH^^MR^', PatientBir = '19631021', PatientSex = 'M', PatientID = '4056834', AccessTime = 1423523232 WHERE StudyInsta = '1.2.840.113619.6.95.31.0.4.4.1.1109.14.2202784'
***Error: ERROR: value too long for type character varying(64)
***Error saving to SQL: 4056834/1.2.840.113619.6.95.31.0.2.4.1.1109.13.2202784/1.3.12.2.1107.5.6.1.69214.20000015020422533493700000315/1.3.12.3.1107.5.6.1.69214.30000015020422533493700000372.dcm
Server Command := 0001
Message ID := 0f7e
FreeStore Left 455543 on /research/conquest
*** ERROR: value too long for type character varying(64)
I have confirmed that the problem is with the StudyModal field and I have tried to alter the column width to accomodate, but I still get the same type of error, but with the larger field size.
The only reason I can think of why there might be a problem is that we recently upgraded to Redhat 7