Query problem

Hello and greeting from Australia.

We set up two Conquest server on one computer to receive patient data respectively from our Picker and Siemens Gamma camera, they worked quite well for the past three year till last week;

When I tried to do a query from the Picker to the Conquest Picker database, it only returned back data of the 2006 and 2007, no data of the 2008; and if I from the Picker tried to query the Siemens database, everything was fine;

Also if I query from our GE Xeleris to both the Conquest database, both results are normal;

quite strange problem and anyone can help?

thanks in advance.

Quote from marcelvanherk

Hi,

can you show the debug log of the correct and failed query?

Marcel

Thanks Marcel for your reply, also thanks very much for your wonderful job on Conquest.

Sorry I was off for several days.

dicom.ini file for the wrong DICOM server:

# This file contains configuration information for the DICOM server
# Do not edit unless you know what you are doing

[sscscp]
MicroPACS = sscscp
Edition = Personal

# Network configuration: server name and TCP/IP port#
MyACRNema = PICKER3_DB
TCPPort = 107

# Reference to other files: known dicom servers; database layout; sops
ACRNemaMap = acrnema.map
kFactorFile = dicom.sql
SOPClassList = dgatesop.lst

# Host(ignored), name, username and password for ODBC data source
SQLHost = localhost
SQLServer = S:\dbase\
Username = conquest
Password = conquest
DoubleBackSlashToDB = 0

# Configure database
TruncateFieldNames = 10
MaxFieldLength = 254
FileNameSyntax = 3
MaxFileNameLength = 255
FixPhilips = 0
FixKodak = 0
KeepAlive = 60
LargeFileSizeKB = 1024
ZipTime = 05:
UIDPrefix = 1.2.826.0.1.3680043.2.135.732666.68020625
EnableReadAheadThread = 1
PatientQuerySortOrder = 0
StudyQuerySortOrder =
SeriesQuerySortOrder =
ImageQuerySortOrder =
IndexDBF = 1
PackDBF = 0
LongQueryDBF = 1000
TCPIPTimeOut = 300
FailHoldOff = 60
RetryDelay = 100
QueueSize = 128
WorkListMode = 0
DebugLevel = 0

# Configuration of compression for incoming images and archival
DroppedFileCompression = un
IncomingCompression = un
ArchiveCompression = as

# Names of the database tables
PatientTableName = DICOMPatients
StudyTableName = DICOMStudies
SeriesTableName = DICOMSeries
ImageTableName = DICOMImages
DMarkTableName = DICOMAccessUpdates
RegisteredMOPDeviceTable = RegisteredMOPIDs
UIDToMOPIDTable = UIDToMOPID
UIDToCDRIDTable = UIDToCDRID

# Banner and host for debug information
PACSName = PICKER3_DB
OperatorConsole = 127.0.0.1

# Configuration of disk(s) to store images
MAGDeviceThreshhold = 0
MAGDevices = 1
MAGDevice0 = S:\
NightlyCleanThreshhold = 0

# Configuration of converter programs to export DICOM slices
ExportConverters = 1
ExportConverter0 = forward to JSWS2

dgatesop.lst file for the wrong server:

#
# DICOM Application / sop / transfer UID list.
#
# This list is used by the CheckedPDU_Service ( "filename" ) service
# class. All incoming associations will be verified against this
# file.
#
# Revision 2: disabled GEMRStorage and GECTStorage
# Revision 3: extended with new sops and with JPEG transfer syntaxes
# Revision 4: added Modality Worklist query
#
#None none RemoteAE
#None none LocalAE
#DICOM 1.2.840.10008.3.1.1.1 application
Verification 1.2.840.10008.1.1 sop
StoredPrintStorage 1.2.840.10008.5.1.1.27 sop
HardcopyGrayscaleImageStorage 1.2.840.10008.5.1.1.29 sop
HardcopyColorImageStorage 1.2.840.10008.5.1.1.30 sop
CRStorage 1.2.840.10008.5.1.4.1.1.1 sop
DXStorageForPresentation 1.2.840.10008.5.1.4.1.1.1.1 sop
DXStorageForProcessing 1.2.840.10008.5.1.4.1.1.1.1.1 sop
DMStorageForPresentation 1.2.840.10008.5.1.4.1.1.1.2 sop
DMStorageForProcessing 1.2.840.10008.5.1.4.1.1.1.2.1 sop
DOralStorageForPresentation 1.2.840.10008.5.1.4.1.1.1.3 sop
DOralStorageForProcessing 1.2.840.10008.5.1.4.1.1.1.3.1 sop
CTStorage 1.2.840.10008.5.1.4.1.1.2 sop
RetiredUSMultiframeStorage 1.2.840.10008.5.1.4.1.1.3 sop
USMultiframeStorage 1.2.840.10008.5.1.4.1.1.3.1 sop
MRStorage 1.2.840.10008.5.1.4.1.1.4 sop
MRImageStorageEnhanced 1.2.840.10008.5.1.4.1.1.4.1 sop
MRStorageSpectroscopy 1.2.840.10008.5.1.4.1.1.4.2 sop
RetiredNMStorage 1.2.840.10008.5.1.4.1.1.5 sop
RetiredUSStorage 1.2.840.10008.5.1.4.1.1.6 sop
USStorage 1.2.840.10008.5.1.4.1.1.6.1 sop
SCStorage 1.2.840.10008.5.1.4.1.1.7 sop
SCStorageSingleBitMF 1.2.840.10008.5.1.4.1.1.7.1 sop
SCStorageGrayscaleByteMF 1.2.840.10008.5.1.4.1.1.7.2 sop
SCStorageGrayscaleWordMF 1.2.840.10008.5.1.4.1.1.7.3 sop
SCStorageTrueColorMF 1.2.840.10008.5.1.4.1.1.7.4 sop
StandaloneOverlayStorage 1.2.840.10008.5.1.4.1.1.8 sop
StandaloneCurveStorage 1.2.840.10008.5.1.4.1.1.9 sop
#WFStorageTwelveLeadECG 1.2.840.10008.5.1.4.1.1.9.1.1 sop
#WFStorageGeneralECG 1.2.840.10008.5.1.4.1.1.9.1.2 sop
#WFStorageAmbulatoryECG 1.2.840.10008.5.1.4.1.1.9.1.3 sop
#WFStorageHemodynamic 1.2.840.10008.5.1.4.1.1.9.2.1 sop
#WFStorageCardiacElectrophysiology 1.2.840.10008.5.1.4.1.1.9.3.1 sop
#WFStorageBasicVoiceAudio 1.2.840.10008.5.1.4.1.1.9.4.1 sop
StandaloneModalityLUTStorage 1.2.840.10008.5.1.4.1.1.10 sop
StandaloneVOILUTStorage 1.2.840.10008.5.1.4.1.1.11 sop
GrayscaleSoftcopyPresentationStateStorage 1.2.840.10008.5.1.4.1.1.11.1 sop
RetiredXASinglePlaneStorage 1.2.840.10008.5.1.4.1.1.12 sop
XASinglePlaneStorage 1.2.840.10008.5.1.4.1.1.12.1 sop
RFStorage 1.2.840.10008.5.1.4.1.1.12.2 sop
XABiPlaneStorage 1.2.840.10008.5.1.4.1.1.12.3 sop
NMStorage 1.2.840.10008.5.1.4.1.1.20 sop
VLImageStorage 1.2.840.10008.5.1.4.1.1.77.1 sop
VLMultiFrameImageStorage 1.2.840.10008.5.1.4.1.1.77.2 sop
VLMicroscopicSlideStorage 1.2.840.10008.5.1.4.1.1.77.3 sop
VLPhotographicStorage 1.2.840.10008.5.1.4.1.1.77.4 sop
VLEndoscopicImageStorage 1.2.840.10008.5.1.4.1.1.77.1.1 sop
VLMicroscopicImageStorage 1.2.840.10008.5.1.4.1.1.77.1.2 sop
VLSlideCoordinatesMicroscopicImageStorage 1.2.840.10008.5.1.4.1.1.77.1.3 sop
VLPhotographicImageStorage 1.2.840.10008.5.1.4.1.1.77.1.4 sop
BasicTextSR 1.2.840.10008.5.1.4.1.1.88.11 sop
EnhancedSR 1.2.840.10008.5.1.4.1.1.88.22 sop
ComprehensiveSR 1.2.840.10008.5.1.4.1.1.88.33 sop
MammographyCADSR 1.2.840.10008.5.1.4.1.1.88.50 sop
KeyObjectSelectionDocument 1.2.840.10008.5.1.4.1.1.88.59 sop
PETStorage 1.2.840.10008.5.1.4.1.1.128 sop
StandalonePETCurveStorage 1.2.840.10008.5.1.4.1.1.129 sop
RTImageStorage 1.2.840.10008.5.1.4.1.1.481.1 sop
RTDoseStorage 1.2.840.10008.5.1.4.1.1.481.2 sop
RTStructureStorage 1.2.840.10008.5.1.4.1.1.481.3 sop
RTTreatmentRecordStorage 1.2.840.10008.5.1.4.1.1.481.4 sop
RTPlanStorage 1.2.840.10008.5.1.4.1.1.481.5 sop
RTBrachyTreatmentRecordStorage 1.2.840.10008.5.1.4.1.1.481.6 sop
RTTreatmentSummaryRecordStorage 1.2.840.10008.5.1.4.1.1.481.7 sop
#GEMRStorage 1.2.840.113619.4.2 sop
#GECTStorage 1.2.840.113619.4.3 sop
GE3DModelObjectStorage 1.2.840.113619.4.26 sop
GERTPlanStorage 1.2.840.113619.5.249 sop
GERTPlanStorage2 1.2.840.113619.4.5.249 sop
GESaturnTDSObjectStorage 1.2.840.113619.5.253 sop
Philips3DVolumeStorage 1.2.46.670589.5.0.1 sop
Philips3DObjectStorage 1.2.46.670589.5.0.2 sop
PhilipsSurfaceStorage 1.2.46.670589.5.0.3 sop
PhilipsCompositeObjectStorage 1.2.46.670589.5.0.4 sop
PhilipsMRCardioProfileStorage 1.2.46.670589.5.0.7 sop
PhilipsMRCardioImageStorage 1.2.46.670589.5.0.8 sop
PatientRootQuery 1.2.840.10008.5.1.4.1.2.1.1 sop
PatientRootRetrieve 1.2.840.10008.5.1.4.1.2.1.2 sop
StudyRootQuery 1.2.840.10008.5.1.4.1.2.2.1 sop
StudyRootRetrieve 1.2.840.10008.5.1.4.1.2.2.2 sop
PatientStudyOnlyQuery 1.2.840.10008.5.1.4.1.2.3.1 sop
PatientStudyOnlyRetrieve 1.2.840.10008.5.1.4.1.2.3.2 sop
FindModalityWorkList 1.2.840.10008.5.1.4.31 sop
PatientRootRetrieveNKI 1.2.826.0.1.3680043.2.135.1066.5.1.4.1.2.1.2 sop
StudyRootRetrieveNKI 1.2.826.0.1.3680043.2.135.1066.5.1.4.1.2.2.2 sop
PatientStudyOnlyRetrieveNKI 1.2.826.0.1.3680043.2.135.1066.5.1.4.1.2.3.2 sop
BasicGrayscalePrintManagementMeta 1.2.840.10008.5.1.1.9 sop
BasicColorPrintManagementMeta 1.2.840.10008.5.1.1.18 sop
BasicFilmSession 1.2.840.10008.5.1.1.1 sop
BasicFilmBox 1.2.840.10008.5.1.1.2 sop
BasicGrayscaleImageBox 1.2.840.10008.5.1.1.4 sop
BasicColorImageBox 1.2.840.10008.5.1.1.4.1 sop
BasicPrinter 1.2.840.10008.5.1.1.16 sop
LittleEndianImplicit 1.2.840.10008.1.2 transfer
#LittleEndianExplicit 1.2.840.10008.1.2.1 transfer
#BigEndianExplicit 1.2.840.10008.1.2.2 transfer
#JPEGBaseLine1 1.2.840.10008.1.2.4.50 transfer LittleEndianExplicit
#JPEGExtended2and4 1.2.840.10008.1.2.4.51 transfer LittleEndianExplicit
#JPEGExtended3and5 1.2.840.10008.1.2.4.52 transfer LittleEndianExplicit
#JPEGSpectralNH6and8 1.2.840.10008.1.2.4.53 transfer LittleEndianExplicit
#JPEGSpectralNH7and9 1.2.840.10008.1.2.4.54 transfer LittleEndianExplicit
#JPEGFulllNH10and12 1.2.840.10008.1.2.4.55 transfer LittleEndianExplicit
#JPEGFulllNH11and13 1.2.840.10008.1.2.4.56 transfer LittleEndianExplicit
#JPEGLosslessNH14 1.2.840.10008.1.2.4.57 transfer LittleEndianExplicit
#JPEGLosslessNH15 1.2.840.10008.1.2.4.58 transfer LittleEndianExplicit
#JPEGExtended16and18 1.2.840.10008.1.2.4.59 transfer LittleEndianExplicit
#JPEGExtended17and19 1.2.840.10008.1.2.4.60 transfer LittleEndianExplicit
#JPEGSpectral20and22 1.2.840.10008.1.2.4.61 transfer LittleEndianExplicit
#JPEGSpectral21and23 1.2.840.10008.1.2.4.62 transfer LittleEndianExplicit
#JPEGFull24and26 1.2.840.10008.1.2.4.63 transfer LittleEndianExplicit
#JPEGFull25and27 1.2.840.10008.1.2.4.64 transfer LittleEndianExplicit
#JPEGLossless28 1.2.840.10008.1.2.4.65 transfer LittleEndianExplicit
#JPEGLossless29 1.2.840.10008.1.2.4.66 transfer LittleEndianExplicit
#JPEGLossless 1.2.840.10008.1.2.4.70 transfer LittleEndianExplicit
#JPEGLS_Lossless 1.2.840.10008.1.2.4.80 transfer LittleEndianExplicit
#JPEGLS_Lossy 1.2.840.10008.1.2.4.81 transfer LittleEndianExplicit
#RLELossless 1.2.840.10008.1.2.5 transfer LittleEndianExplicit
#LittleEndianExplicitDeflated 1.2.840.10008.1.2.1.99 transfer LittleEndianExplicit
#JPEG2000LosslessOnly 1.2.840.10008.1.2.4.90 transfer LittleEndianExplicit
#JPEG2000 1.2.840.10008.1.2.4.91 transfer LittleEndianExplicit

dicom.sql file for the wrong server:

/*
# DICOM Database layout
# Example version for built-in DbaseIII driver (denormalized)
#
# (File DICOM.SQL)
# ** DO NOT EDIT THIS FILE UNLESS YOU KNOW WHAT YOU ARE DOING **
#
# Version with modality moved to the series level and EchoNumber in image table
# Revision 3: Patient birthday and sex, bolus agent, correct field lengths
# Revision 4: Studymodality, Station and Department in study
# Manufacturer, Model, BodyPart and Protocol in series
# Acqdate/time, coil, acqnumber, slicelocation and pixel info in images
# Notes for revision 4:
# InstitutionalDepartmentName in study (should officially be in series, but eFilm expects it in study)
# StationName is in study (should officially be in series, but more useful in study)
# Revision 5: Added patientID in series and images for more efficient querying
# Revision 6: Added frame of reference UID in series table
# Revision 7: Added ImageType in image table, StudyModality to 64 chars, AcqDate to SQL_C_DATE
# Revision 8: Denormalized study table (add patient ID, name, birthdate) to show consistency problems
# Revision 9: Denormalized series and image table for full query support with built-in DBF driver
# Revision 10: Fixed width of ReceivingCoil: to 16 chars
# Revision 11: Added Manufacturer to denormalized image table for built-in DBF driver
# Revision 12: Removed duplicate STUDYINST field in series for built-in DBF driver
# Revision 13: Added ImageID to image database
# Revision 14: Added WorkList database with HL7 tags
#
#
# 5 databases need to be defined:
#
# *Patient*
# *Study*
# *Series*
# *Image*
# *WorkList*
#
#
# The last defined element of Study is a link back to Patient
# The last defined element of Series is a link back to Study
# The last defined element of Image is a link back to Series
#
#
# Format for DICOM databases :
# { Group, Element, Column Name, Column Length, SQL-Type, DICOM-Type }
# Format for Worklist database :
# { Group, Element, Column Name, Column Length, SQL-Type, DICOM-Type, HL7 tag}
# HL7 tags include SEQ.N, SEQ.N.M, SEQ.N.DATE, SEQ.N.TIME, *AN, *UI
*/

*Patient*
{
{ 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR },
{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR },
{ 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR }
}

*Study*
{
{ 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI },
{ 0x0008, 0x0020, "StudyDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0008, 0x0030, "StudyTime", 16, SQL_C_CHAR, DT_TIME },
{ 0x0020, 0x0010, "StudyID", 16, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x1030, "StudyDescription", 64, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0050, "AccessionNumber", 16, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0090, "ReferPhysician", 64, SQL_C_CHAR, DT_STR },
{ 0x0010, 0x1010, "PatientsAge", 16, SQL_C_CHAR, DT_STR },
{ 0x0010, 0x1030, "PatientsWeight", 16, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0061, "StudyModality", 64, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x1010, "StationName", 16, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x1040, "InstitutionalDepartmentName", 64, SQL_C_CHAR, DT_STR },

{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR },
{ 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR }

{ 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR }
}

*Series*
{
{ 0x0020, 0x000e, "SeriesInstanceUID", 64, SQL_C_CHAR, DT_UI },
{ 0x0020, 0x0011, "SeriesNumber", 12, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0021, "SeriesDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0008, 0x0031, "SeriesTime", 16, SQL_C_CHAR, DT_TIME },
{ 0x0008, 0x103e, "SeriesDescription", 64, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0060, "Modality", 16, SQL_C_CHAR, DT_STR },
{ 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, 0x0015, "BodyPartExamined", 64, SQL_C_CHAR, DT_STR },
{ 0x0018, 0x1030, "ProtocolName", 64, SQL_C_CHAR, DT_STR },
{ 0x0020, 0x0052, "FrameOfReferenceUID", 64, SQL_C_CHAR, DT_UI },
{ 0x0010, 0x0020, "SeriesPat", 64, SQL_C_CHAR, DT_STR },

{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR },
{ 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR }

{ 0x0008, 0x0020, "StudyDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0008, 0x0030, "StudyTime", 16, SQL_C_CHAR, DT_TIME },
{ 0x0020, 0x0010, "StudyID", 16, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x1030, "StudyDescription", 64, SQL_C_CHAR, DT_STR },

{ 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI }
}

*Image*
{
{ 0x0008, 0x0018, "SOPInstanceUID", 64, SQL_C_CHAR, DT_UI },
{ 0x0008, 0x0016, "SOPClassUID", 64, SQL_C_CHAR, DT_UI },
{ 0x0020, 0x0013, "ImageNumber", 12, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0023, "ImageDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0008, 0x0033, "ImageTime", 16, SQL_C_CHAR, DT_TIME },
{ 0x0018, 0x0086, "EchoNumber", 12, SQL_C_CHAR, DT_STR },
{ 0x0028, 0x0008, "NumberOfFrames", 12, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0022, "AcqDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0008, 0x0032, "AcqTime", 16, SQL_C_CHAR, DT_TIME },
{ 0x0018, 0x1250, "ReceivingCoil", 16, SQL_C_CHAR, DT_STR },
{ 0x0020, 0x0012, "AcqNumber", 12, SQL_C_CHAR, DT_STR },
{ 0x0020, 0x1041, "SliceLocation", 16, SQL_C_CHAR, DT_STR },
{ 0x0028, 0x0002, "SamplesPerPixel", 5, SQL_C_CHAR, DT_UINT16 },
{ 0x0028, 0x0004, "PhotoMetricInterpretation", 16, SQL_C_CHAR, DT_STR },
{ 0x0028, 0x0010, "Rows", 5, SQL_C_CHAR, DT_UINT16 },
{ 0x0028, 0x0011, "Colums", 5, SQL_C_CHAR, DT_UINT16 },
{ 0x0028, 0x0101, "BitsStored", 5, SQL_C_CHAR, DT_UINT16 },
{ 0x0008, 0x0008, "ImageType", 128, SQL_C_CHAR, DT_STR },
{ 0x0054, 0x0400, "ImageID", 16, SQL_C_CHAR, DT_STR },
{ 0x0010, 0x0020, "ImagePat", 64, SQL_C_CHAR, DT_STR },

{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR },
{ 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR }

{ 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI },
{ 0x0008, 0x0020, "StudyDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0008, 0x0030, "StudyTime", 16, SQL_C_CHAR, DT_TIME },
{ 0x0020, 0x0010, "StudyID", 16, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x1030, "StudyDescription", 64, SQL_C_CHAR, DT_STR },

{ 0x0020, 0x0011, "SeriesNumber", 12, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0021, "SeriesDate", 8, SQL_C_DATE, DT_DATE },
{ 0x0008, 0x0031, "SeriesTime", 16, SQL_C_CHAR, DT_TIME },
{ 0x0008, 0x103e, "SeriesDescription", 64, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0060, "Modality", 16, SQL_C_CHAR, DT_STR },
{ 0x0020, 0x0052, "FrameOfReferenceUID", 64, SQL_C_CHAR, DT_UI },
{ 0x0008, 0x0070, "Manufacturer", 64, SQL_C_CHAR, DT_STR },

{ 0x0020, 0x000e, "SeriesInstanceUID", 64, SQL_C_CHAR, DT_UI }
}

*WorkList*
{
{ 0x0008, 0x0050, "AccessionNumber", 16, SQL_C_CHAR, DT_STR, "OBR.3" },
{ 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR, "PID.4" },
{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR, "PID.5" },
{ 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE, "PID.7" },
{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR, "PID.8" },

{ 0x0010, 0x2000, "MedicalAlerts", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0010, 0x2110, "ContrastAllergies", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI, "---" },
{ 0x0032, 0x1032, "ReqPhysician", 64, SQL_C_CHAR, DT_STR, "OBR.16" },
{ 0x0032, 0x1060, "ReqProcDescription", 16, SQL_C_CHAR, DT_STR, "OBR.4.1" },

{ 0x0040, 0x0100, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },
{ 0x0008, 0x0060, "Modality", 16, SQL_C_CHAR, DT_STR, "OBR.21" },
{ 0x0032, 0x1070, "ReqContrastAgent", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0001, "ScheduledAE", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0002, "StartDate", 8, SQL_C_DATE, DT_DATE, "OBR.7.DATE" },
{ 0x0040, 0x0003, "StartTime", 16, SQL_C_CHAR, DT_TIME, "OBR.7.TIME" },
{ 0x0040, 0x0006, "PerfPhysician", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0007, "SchedPSDescription", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0009, "SchedPSID", 16, SQL_C_CHAR, DT_STR, "OBR.4" },
{ 0x0040, 0x0010, "SchedStationName", 16, SQL_C_CHAR, DT_STR, "OBR.24" },
{ 0x0040, 0x0011, "SchedPSLocation", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0012, "PreMedication", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0400, "SchedPSComments", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0100, "---------", 0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },

{ 0x0040, 0x1001, "ReqProcID", 16, SQL_C_CHAR, DT_STR, "OBR.4.0" },
{ 0x0040, 0x1003, "ReqProcPriority", 16, SQL_C_CHAR, DT_STR, "OBR.27 }
}

The problem is that everytime when I do a query, it only returns data of 2006 and 2007, lost the data of 2008 and, I can see the data if I browse the patient.

it worked fine and proble just began last week.

Thanks

Thaks Marcel,

ya it is strange, simply say:

we set up on one computer C two conquest server receiving data from A and B, on C we have A_DB and B_DB to store the data, it worked perfectly till last week.

Now from A I can query both A_DB and B_DB, but from B I can query A_DB but when try to query B_DB, it only returns part of the data, not all ( only can get data of 2006 and 2007, no 2008 and 2009).

We also have a Xeleris, from it querying A_DB and B_DB works fine.

in B_DB we have more than 70k images, does that cause the problem?

Thanks Marcel, I will do that today and report you the result.

Also we still use 1.4.12, and just use built-in dbaseIII driver, in the manual it said for small archives of up to 100.000 images, totally in the two folder we have more than that, is it a problem?

Cheers