Conquest Nightly Move with MSSQL

fulfordadmin · Jul 12th 2007

Hi There.. hope you can help. I'm getting an error when trying to use the Nightly Move option. I'm guessing it's a problem with MSSQL as the dicom.ini line TruncateFieldNames value needs to be bigger than 10 to get conquest to work properly for some reason. (I wasn't the original installer so I'm not sure why MSSQL was used, maybe for worklists) .. The MAGS read ok etc.. I'm tempted to reinstall the database as DBase or Mysql but thought I'd ask the question here:
The error is as follows:

---------- Start archival operation -----------
MoveDataToDevice: *** could not create patient list
failed nightly moving

------------------- Show free space on devices --------------------

Free space on MAG Device 0 := 8406 MByte
Free space on MAG Device 1 := 427816 MByte

marcelvanherk · Jul 12th 2007

Hi,

Which version? Was TruncateFieldNames changed during the install?

Marcel

fulfordadmin · Jul 16th 2007

It's Version 1.4.11 and I'm unsure whether the truncate field was changed during install as the previous admin installed it.

Thanks.

marcelvanherk · Jul 16th 2007

You can use sql entreprise manager to list the database layout and compare that with dicim.sql

Marcel

fulfordadmin · Jul 24th 2007

The field names are identical in the dicom.sql and SQL 2005 Tables. I've updated Conquest to 1.4.12c also. Any other ideas?

marcelvanherk · Jul 25th 2007

Hi,

the field names should be truncated to 10 characters in the sql server.

Marcel

Conquest Nightly Move with MSSQL

Participate now!

Share