# \[BUG-14717\] Deletion of Final Parameter of Named Query causes Ignition Designer to crash

**URL:** <https://forum.inductiveautomation.com/t/bug-14717-deletion-of-final-parameter-of-named-query-causes-ignition-designer-to-crash/26087>\
**Category:** Ignition Early Access\
**Tags:** ignition80\
**Created:** [June 25, 2019, 5:17pm UTC](https://forum.inductiveautomation.com/t/bug-14717-deletion-of-final-parameter-of-named-query-causes-ignition-designer-to-crash/26087 "2019-06-25T17:17:53Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![seth.thomas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/seth.thomas/32/6882_2.png) [@seth.thomas](https://forum.inductiveautomation.com/u/seth.thomas)\
**Post date:** [June 25, 2019, 5:17pm UTC](https://forum.inductiveautomation.com/t/bug-14717-deletion-of-final-parameter-of-named-query-causes-ignition-designer-to-crash/26087/1 "2019-06-25T17:17:53Z")

</div>

Something I noticed when working on some named queries today:  
Steps to recreate:

1. Create a named query
2. Set the database connection to “parameter” while there are still parameters defined for the query
3. Delete all parameters for the query
4. When attempting to delete the final parameter, the designer freezes up and cannot be recovered.

This can be worked around by temporarily setting the database connection to “default” and then deleting the parameters and setting the database connection back to “parameter”.

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [June 25, 2019, 5:50pm UTC](https://forum.inductiveautomation.com/t/bug-14717-deletion-of-final-parameter-of-named-query-causes-ignition-designer-to-crash/26087/2 "2019-06-25T17:50:48Z")

</div>

I wasn’t able to replicate with a build from Friday. What version/build are you using?

---

<div class="post-metadata">

**Author:** ![seth.thomas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/seth.thomas/32/6882_2.png) [@seth.thomas](https://forum.inductiveautomation.com/u/seth.thomas)\
**Post date:** [June 25, 2019, 6:28pm UTC](https://forum.inductiveautomation.com/t/bug-14717-deletion-of-final-parameter-of-named-query-causes-ignition-designer-to-crash/26087/3 "2019-06-25T18:28:40Z")

</div>

8.0.2 - b2019060511

---

<div class="post-metadata">

**Author:** ![awalker](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/awalker/32/6874_2.png) [@awalker](https://forum.inductiveautomation.com/u/awalker)\
**Post date:** [August 13, 2019, 5:41pm UTC](https://forum.inductiveautomation.com/t/bug-14717-deletion-of-final-parameter-of-named-query-causes-ignition-designer-to-crash/26087/4 "2019-08-13T17:41:28Z")

</div>

Hi @seth.thomas, have you come across this issue again since you first posted?

---

<div class="post-metadata">

**Author:** ![seth.thomas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/seth.thomas/32/6882_2.png) [@seth.thomas](https://forum.inductiveautomation.com/u/seth.thomas)\
**Post date:** [August 13, 2019, 5:58pm UTC](https://forum.inductiveautomation.com/t/bug-14717-deletion-of-final-parameter-of-named-query-causes-ignition-designer-to-crash/26087/5 "2019-08-13T17:58:52Z")

</div>

Since posting, we’ve generally moved away from named queries because stored procedures made more sense for the architecture of our project. We recently upgraded to 8.0.3. I just tested this again and got the same issue though. I was actually unable to delete any named query parameters once setting the database connection to be parameterized.

---

<div class="post-metadata">

**Author:** ![awalker](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/awalker/32/6874_2.png) [@awalker](https://forum.inductiveautomation.com/u/awalker)\
**Post date:** [August 13, 2019, 6:10pm UTC](https://forum.inductiveautomation.com/t/bug-14717-deletion-of-final-parameter-of-named-query-causes-ignition-designer-to-crash/26087/6 "2019-08-13T18:10:22Z")

</div>

Ok - thank you! I’m going to have someone look in to this and get back to you.

---

<div class="post-metadata">

**Author:** ![awalker](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/awalker/32/6874_2.png) [@awalker](https://forum.inductiveautomation.com/u/awalker)\
**Post date:** [September 9, 2019, 11:13pm UTC](https://forum.inductiveautomation.com/t/bug-14717-deletion-of-final-parameter-of-named-query-causes-ignition-designer-to-crash/26087/7 "2019-09-09T23:13:10Z")

</div>

This issue was fixed in the 8.0.4 RC.

If you are still seeing this behavior, please let us know.