Added column is populated on regen but not on adding file

Hi all,

I am new to conquest, i have installed dicomserver1419c1. I have changed my dicom.sql to include the deviceserialnumber in my database on table series. When i run reinitialise database then the extra column is populated but when I add a file to incoming and read by conquest, the deviceserialnumber colum is not populated. I am on Windows server 2016 and running SQL Server 2014 as database. Am I missing something

 { 0x0018, 0x1000, "DeviceSerialNumber", 64, SQL_C_CHAR, DT_STR },

Yes I did

 { 0x0018, 0x5100, "PatientPosition", 16, SQL_C_CHAR, DT_STR },
 { 0x0018, 0x0010, "ContrastBolusAgent", 64, SQL_C_CHAR, DT_STR },
 { 0x0008, 0x0070, "Manufacturer", 64, SQL_C_CHAR, DT_STR },
 { 0x0008, 0x1090, "ModelName", 64, SQL_C_CHAR, DT_STR },
 { 0x0018, 0x1000, "DeviceSerialNumber", 64, SQL_C_CHAR, DT_STR },
 { 0x0018, 0x0015, "BodyPartExamined", 64, SQL_C_CHAR, DT_STR },
 { 0x0018, 0x1030, "ProtocolName", 64, SQL_C_CHAR, DT_STR },
 { 0x0008, 0x1010, "StationName", 16, SQL_C_CHAR, DT_STR },
 { 0x0008, 0x0080, "Institution", 64, SQL_C_CHAR, DT_STR },

First I thought the problem was the Dicom File itself but when I reinitialise then it picks it up.

N

Quote from marcelvanherk

Hi,

is it this:

change dicom.sql

try to enter (does not work, because database column has not been added)

reinit, picks it up

try to enter another (should now work)

Marcel

Display More

Nope

Changed Dicom.sql,

reinit - picks them up,

try to enter another -not picked up,

reinit again - picks up.

Anyway, overwrote the files with the new version and they are now picked up. Not sure what the problem was, now working.