DICOM files get saved, but Database file suspiciously small and search returns nothing

amirzolal · Dec 21st 2020

Hello,

I have a problem with a Conqest server running on a Carestream machine. Maybe there is some special configuration. When an xray is taken, you can see the DICOM files appearing in the Conquest Image directory. But the database files are relatively small for the amount of files.

I have already tried to regenerate the database, but that did not help. Also searching from the GUI does not work. But the database directory contains the DICOM data. In what config files can I look in this situation, where the files get saved but do not appear in any database search?

Code

DICOMSERVER] Connected by address: 7464a8c0

[DICOMSERVER] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'

[DICOMSERVER]

[DICOMSERVER] UPACS THREAD 56: STARTED AT: Wed Dec 16 15:18:50 2020

[DICOMSERVER] A-ASSOCIATE-RQ Packet Dump

[DICOMSERVER]  Calling Application Title : "RADIANT1        "

[DICOMSERVER]  Called Application Title : "CONQESTSRV1     "

[DICOMSERVER]  Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384

[DICOMSERVER]  Number of Proposed Presentation Contexts: 1

[DICOMSERVER]  Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1

[DICOMSERVER] Server Command   := 0020

[DICOMSERVER] Message ID       := 0001

[DICOMSERVER] 0000,0002     28 UI AffectedSOPClassUID    "1.2.840.10008.5.1.4.1.2.2.1"

[DICOMSERVER] 0000,0100      2 US CommandField           32

[DICOMSERVER] 0000,0110      2 US MessageID              1

[DICOMSERVER] 0000,0700      2 US Priority               2

[DICOMSERVER] 0000,0800      2 US DataSetType            258

[DICOMSERVER] 0002,0010     17 UI TransferSyntaxUID      "1.2.840.10008.1.2"

[DICOMSERVER] (StudyRootQuery) search level: STUDY

[DICOMSERVER] 0002,0010     17 UI TransferSyntaxUID      "1.2.840.10008.1.2"

[DICOMSERVER] 0008,0020     18 DA StudyDate              "20201216-20201216 "

[DICOMSERVER] 0008,0030      0 TM StudyTime              (empty)

[DICOMSERVER] 0008,0050      0 SH AccessionNumber        (empty)

[DICOMSERVER] 0008,0052      6 CS QueryRetrieveLevel     "STUDY "

[DICOMSERVER] 0008,0056      0 UN                        (empty)

[DICOMSERVER] 0008,0061      0 CS                        (empty)

[DICOMSERVER] 0008,0080      0 LO InstitutionName        (empty)

[DICOMSERVER] 0008,0090      0 PN ReferringPhysicianNa   (empty)

[DICOMSERVER] 0008,1030      0 LO StudyDescription       (empty)

[DICOMSERVER] 0008,1040      0 LO InstitutionalDepartm   (empty)

[DICOMSERVER] 0008,1050      0 PN PerformingPhysicianN   (empty)

[DICOMSERVER] 0008,1060      0 PN PhysicianReadingStud   (empty)

[DICOMSERVER] 0010,0010      0 PN PatientName            (empty)

[DICOMSERVER] 0010,0020      0 LO PatientID              (empty)

[DICOMSERVER] 0010,0030      0 DA PatientBirthDate       (empty)

[DICOMSERVER] 0010,0040      0 CS PatientSex             (empty)

[DICOMSERVER] 0020,000d      0 UI StudyInstanceUID       (empty)

[DICOMSERVER] 0020,0010      0 SH StudyID                (empty)

[DICOMSERVER] 0020,1208      0 IS NumberOfStudyRelated   (empty)

[DICOMSERVER] Query On Study

[DICOMSERVER] Queried item 0008 0056 is not in the database

[DICOMSERVER] Queried item 0008 0080 is not in the database

[DICOMSERVER] Queried item 0008 1040 is not in the database

[DICOMSERVER] Queried item 0008 1050 is not in the database

[DICOMSERVER] Queried item 0008 1060 is not in the database

[DICOMSERVER] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[DICOMSERVER] Values: DICOMStudies.StudyDate >= '20201216' and DICOMStudies.StudyDate <= '20201216'

[DICOMSERVER] Tables: DICOMStudies

[DICOMSERVER] Sorting (DICOMStudies.PatientNam) DoSort := 1

[DICOMSERVER] Query Distinct Tables: DICOMStudies

[DICOMSERVER] Columns              : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[DICOMSERVER] Where                : DICOMStudies.StudyDate >= '20201216' and DICOMStudies.StudyDate <= '20201216'

[DICOMSERVER] Order                : DICOMStudies.PatientNam

[DICOMSERVER] Records = 0

[DICOMSERVER] C-Find (StudyRoot) located 0 records

[DICOMSERVER] UPACS THREAD 56: ENDED AT: Wed Dec 16 15:18:50 2020

[DICOMSERVER] UPACS THREAD 56: TOTAL RUNNING TIME: 0 SECONDS

Display More

Also, when I search from the GUI, I there is also no result, whatever search configuration I try:

Code

[DICOMSERVER] UPACS THREAD 90: STARTED AT: Wed Dec 16 15:33:06 2020

[DICOMSERVER] A-ASSOCIATE-RQ Packet Dump

[DICOMSERVER]  Calling Application Title : "DICOMSERVER     "

[DICOMSERVER]  Called Application Title : "CONQUESTSRV1    "

[DICOMSERVER]  Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384

[DICOMSERVER]  Number of Proposed Presentation Contexts: 4

[DICOMSERVER]  Presentation Context 0 "1.2.840.10008.5.1.4.1.2.1.1" 1

[DICOMSERVER]  Presentation Context 1 "1.2.840.10008.5.1.4.1.2.2.1" 1

[DICOMSERVER]  Presentation Context 2 "1.2.840.10008.5.1.4.1.2.3.1" 1

[DICOMSERVER]  Presentation Context 3 "1.2.840.10008.5.1.4.31" 1

[DICOMSERVER] Server Command   := 0020

[DICOMSERVER] Message ID       := 0003

[DICOMSERVER] 0000,0002     28 UI AffectedSOPClassUID    "1.2.840.10008.5.1.4.1.2.1.1"

[DICOMSERVER] 0000,0100      2 US CommandField           32

[DICOMSERVER] 0000,0110      2 US MessageID              3

[DICOMSERVER] 0000,0700      2 US Priority               0

[DICOMSERVER] 0000,0800      2 US DataSetType            258

[DICOMSERVER] 0002,0010     17 UI TransferSyntaxUID      "1.2.840.10008.1.2"

[DICOMSERVER] (PatientRootQuery) search level: PATIENT

[DICOMSERVER] 0002,0010     17 UI TransferSyntaxUID      "1.2.840.10008.1.2"

[DICOMSERVER] 0008,0052      8 CS QueryRetrieveLevel     "PATIENT "

[DICOMSERVER] 0010,0010      4 PN PatientName            "*A* "

[DICOMSERVER] 0010,0020      0 LO PatientID              (empty)

[DICOMSERVER] Query On Patient

[DICOMSERVER] Issue Query on Columns: DICOMPatients.PatientNam, DICOMPatients.PatientID

[DICOMSERVER] Values: DICOMPatients.PatientNam LIKE '%A%'

[DICOMSERVER] Tables: DICOMPatients

[DICOMSERVER] Sorting (DICOMPatients.PatientNam) DoSort := 1

[DICOMSERVER] Query Distinct Tables: DICOMPatients

[DICOMSERVER] Columns              : DICOMPatients.PatientNam, DICOMPatients.PatientID

[DICOMSERVER] Where                : DICOMPatients.PatientNam LIKE '%A%'

[DICOMSERVER] Order                : DICOMPatients.PatientNam

[DICOMSERVER] Records = 0

[DICOMSERVER] C-Find (PatientRoot) located 0 records

[DICOMSERVER] UPACS THREAD 90: ENDED AT: Wed Dec 16 15:33:06 2020

[DICOMSERVER] UPACS THREAD 90: TOTAL RUNNING TIME: 0 SECONDS

[DICOMSERVER] Connected by address: 0100007f

Display More

marcelvanherk · Dec 22nd 2020

Hi,

Can you post your dicom.ini?

Marcel

amirzolal · Jan 5th 2021

Yes, sorry for the delay

Code

# 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                = DICOMSERVER
TCPPort                  = 10410
# 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                =
Username                 =
Password                 =
SqLite                   = 1
BrowseThroughDBF         = 1
DoubleBackSlashToDB      = 0
UseEscapeStringConstants = 0
# Configure database
TruncateFieldNames       = 10
MaxFieldLength           = 254
MaxFileNameLength        = 255
FixPhilips               = 0
FixKodak                 = 0
KeepAlive                = 0
LargeFileSizeKB          = 4096
PrintSquareLandscape     = 0
UseKpacsDecompression    = 1
ZipTime                  = 05:
UIDPrefix                = 1.2.826.0.1.3680043.2.135.734800.31317970
EnableReadAheadThread    = 1
PatientQuerySortOrder    =
StudyQuerySortOrder      =
SeriesQuerySortOrder     =
ImageQuerySortOrder      =
EnableComputedFields     = 1
IndexDBF                 = 1
PackDBF                  = 0
LongQueryDBF             = 1000
TCPIPTimeOut             = 300
FailHoldOff              = 60
RetryDelay               = 100
RetryForwardFailed       = 0
ImportExportDragAndDrop  = 0
QueueSize                = 128
WorkListMode             = 0
WorkListReturnsISO_IR_100 = 1
DebugLevel               = 0
Prefetcher               = 0
LRUSort                  =
AllowTruncate            =
DecompressNon16BitsJpeg  = 1
UseBuiltInJPEG           = 1
LossyQuality             = 95
IgnoreOutOfMemoryErrors  = 0
NoDICOMCheck             = 0
PadAEWithZeros           = 0
FileNameSyntax           = 10
# 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                 = DICOMSERVER
OperatorConsole          = 127.0.0.1
# Configure email of error messages
MailHost                 =
MailPort                 = smtp
MailSignon               =
MailFromName             =
MailRcptName1            =
MailCollectTime          = 1
MailWaitTime             = 10
# Configuration of disk(s) to store images
MAGDeviceThreshhold      = 0
MAGDeviceFullThreshHold  = 30
IgnoreMAGDeviceThreshold = 0
MAGDevices               = 1
MAGDevice0               = C:\dicomserver\data\
NightlyCleanThreshhold   = 0

Display More

marcelvanherk · Jan 5th 2021

SQLServer should be the filename of the sqlite database, e.g. after a regular install:

Code

# Host, database, username and password for database
SQLHost                  = localhost
SQLServer                = E:\dicom150beta3\Data\dbase\conquest.db3
Username                 =
Password                 =
SqLite                   = 1
DoubleBackSlashToDB      = 0
UseEscapeStringConstants = 0

DICOM files get saved, but Database file suspiciously small and search returns nothing

amirzolal Dec 21st 2020

Participate now!

Share

Tags