# Error deleting device

**URL:** <https://forum.inductiveautomation.com/t/error-deleting-device/3042>\
**Category:** Module Development\
**Created:** [June 28, 2011, 1:13pm UTC](https://forum.inductiveautomation.com/t/error-deleting-device/3042 "2011-06-28T13:13:44Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![smorini](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@smorini](https://forum.inductiveautomation.com/u/smorini)\
**Post date:** [June 28, 2011, 1:13pm UTC](https://forum.inductiveautomation.com/t/error-deleting-device/3042/1 "2011-06-28T13:13:44Z")

</div>

Hi I have this message  
“More than one record in result set (2) [SQuery [SRecM DeviceRecord]]  
See log for details.”  
when I try to delete a device.

Can you help me?

Regards,  
Stefano

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [June 28, 2011, 3:19pm UTC](https://forum.inductiveautomation.com/t/error-deleting-device/3042/2 "2011-06-28T15:19:41Z")

</div>

That was a bug we had in an earlier version. I would recommend upgrading to the lastest. However, right now you can delete the duplicate device in the raw settings viewer. So, log into the Ignition Gateway configuration page and select Console under System. Once there select the Advacned tab and click Raw Settings Viewer.

First find the id of the device: `SELECT * FROM DEVICES`Next you can perform the following two queries:`DELETE FROM DRIVERPROPERTIES WHERE DEVICEID = ? 
DELETE FROM DEVICES WHERE DEVICE_ID = ? `Once you do those queries you need to restart Ignition in order for it to take affect. Let me know if you have any other questions or run into any problems.

---

<div class="post-metadata">

**Author:** ![giulianacaula](https://avatars.discourse-cdn.com/v4/letter/g/779978/32.png) [@giulianacaula](https://forum.inductiveautomation.com/u/giulianacaula)\
**Post date:** [January 22, 2018, 6:22pm UTC](https://forum.inductiveautomation.com/t/error-deleting-device/3042/3 "2018-01-22T18:22:11Z")

</div>

Hi, Travis.

Where is this in the new version of Ignition? I would really like to know  
Thanks,

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [January 22, 2018, 6:37pm UTC](https://forum.inductiveautomation.com/t/error-deleting-device/3042/4 "2018-01-22T18:37:39Z")

</div>

On the downloads page:

[https://inductiveautomation.com/downloads/ignition](https://inductiveautomation.com/downloads/ignition)

---

<div class="post-metadata">

**Author:** ![giulianacaula](https://avatars.discourse-cdn.com/v4/letter/g/779978/32.png) [@giulianacaula](https://forum.inductiveautomation.com/u/giulianacaula)\
**Post date:** [January 22, 2018, 6:39pm UTC](https://forum.inductiveautomation.com/t/error-deleting-device/3042/5 "2018-01-22T18:39:31Z")

</div>

No, I’m sorry.  
I ment where is the Raw Settings Viewer in the new version of Ignition.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [January 22, 2018, 6:41pm UTC](https://forum.inductiveautomation.com/t/error-deleting-device/3042/6 "2018-01-22T18:41:57Z")

</div>

Oh I see. Yeah it is a little hidden. Go the following page in the Gateway Configuration section:

[http://localhost:8088/main/web/status/sys.internaldb](http://localhost:8088/main/web/status/sys.internaldb)

---

<div class="post-metadata">

**Author:** ![giulianacaula](https://avatars.discourse-cdn.com/v4/letter/g/779978/32.png) [@giulianacaula](https://forum.inductiveautomation.com/u/giulianacaula)\
**Post date:** [January 22, 2018, 6:45pm UTC](https://forum.inductiveautomation.com/t/error-deleting-device/3042/7 "2018-01-22T18:45:37Z")

</div>

Thanks a lot !!!