# DCM form, hangs computer with SQL Failed error message

**URL:** <https://discourse.slicer.org/t/dcm-form-hangs-computer-with-sql-failed-error-message/2337>\
**Category:** Support\
**Created:** [March 16, 2018, 4:51pm UTC](https://discourse.slicer.org/t/dcm-form-hangs-computer-with-sql-failed-error-message/2337 "2018-03-16T16:51:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JohnK](https://avatars.discourse-cdn.com/v4/letter/j/59ef9b/32.png) [@JohnK](https://discourse.slicer.org/u/JohnK)\
**Post date:** [March 16, 2018, 4:51pm UTC](https://discourse.slicer.org/t/dcm-form-hangs-computer-with-sql-failed-error-message/2337/1 "2018-03-16T16:51:19Z")

</div>

Using Slicer 4.9, Windows 7 64bit

I have a major error occurring on my DCM form when it initially shows (no button clicks yet). My entire computer hangs and not even Task Manager shows up so I can stop the slicer process / App

"SQL Failed  
Bad SQL: SELECT value FROM TagCache WHERE SOPInstanceUID = :SOPInstanceUID AND Tag = :Tag

error text: disk I/O error unable to fetch row. "

I suspect the error comes from not allowing the system to background events, but this is pretty serious. Any suggestions?

---

<div class="post-metadata">

**Author:** ![lassoan](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.slicer.org/lassoan/32/13_2.png) [@lassoan](https://discourse.slicer.org/u/lassoan)\
**Post date:** [March 16, 2018, 5:14pm UTC](https://discourse.slicer.org/t/dcm-form-hangs-computer-with-sql-failed-error-message/2337/2 "2018-03-16T17:14:47Z")

</div>

If the whole system hangs then most likely it is indeed a disk error. If your local disk is not acting up otherwise, then it is probably due to an inaccessible network drive. To fix that, make all the mapped network drive accessible, or remove those that are inaccessible.

---

<div class="post-metadata">

**Author:** ![JohnK](https://avatars.discourse-cdn.com/v4/letter/j/59ef9b/32.png) [@JohnK](https://discourse.slicer.org/u/JohnK)\
**Post date:** [March 16, 2018, 5:24pm UTC](https://discourse.slicer.org/t/dcm-form-hangs-computer-with-sql-failed-error-message/2337/3 "2018-03-16T17:24:22Z")

</div>

All disks /net drive appear to function normally otherwise. I suspect the DICOM listener is acting up (it never worked in the first place). Is there a way to turn off the listener in SLICER without using the DCM form?

---

<div class="post-metadata">

**Author:** ![lassoan](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.slicer.org/lassoan/32/13_2.png) [@lassoan](https://discourse.slicer.org/u/lassoan)\
**Post date:** [March 16, 2018, 5:45pm UTC](https://discourse.slicer.org/t/dcm-form-hangs-computer-with-sql-failed-error-message/2337/4 "2018-03-16T17:45:50Z")

</div>

Can you try to open a file selector dialog in Slicer? It would be important to know if those hang, too.

You can edit all application settings in Slicer.ini and Slicer-NNNN.ini files in your user profile folder (AppData/Roaming/NA-MIC/… or something like that). You can also start Slicer with default settings by running `Slicer.exe --disable-settings`.

---

<div class="post-metadata">

**Author:** ![JohnK](https://avatars.discourse-cdn.com/v4/letter/j/59ef9b/32.png) [@JohnK](https://discourse.slicer.org/u/JohnK)\
**Post date:** [March 16, 2018, 5:55pm UTC](https://discourse.slicer.org/t/dcm-form-hangs-computer-with-sql-failed-error-message/2337/5 "2018-03-16T17:55:03Z")

</div>

Yes, choosing files to add works fine.  
This gets me back to the point that Slicer does not crash my computer:  
-copied the database to a new folder

- in the slicer.ini file remove any fields from  
StoragePort=  
ServerNodeCount=  
CallingAETitle=  
StorageAETitle=

So I suspect my database was corrupt ( will just restart from scratch) or the DICOM listener was hanging up.  
Either way that part of the 3Dslicer code is absolutely evil since it does not allow you to shut down its process!

Thanks so much for your help.