# Need help with error code and named queries

**URL:** <https://forum.inductiveautomation.com/t/need-help-with-error-code-and-named-queries/57863>\
**Category:** Ignition\
**Tags:** ignition80, database, vision, scripting\
**Created:** [March 31, 2022, 11:59am UTC](https://forum.inductiveautomation.com/t/need-help-with-error-code-and-named-queries/57863 "2022-03-31T11:59:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tyler\_Muckley](https://avatars.discourse-cdn.com/v4/letter/t/b4bc9f/32.png) [@Tyler\_Muckley](https://forum.inductiveautomation.com/u/Tyler_Muckley)\
**Post date:** [March 31, 2022, 11:59am UTC](https://forum.inductiveautomation.com/t/need-help-with-error-code-and-named-queries/57863/1 "2022-03-31T11:59:29Z")

</div>

Hello everyone,

I have a named query I am trying to run and I am getting an error I can’t seem to find the answer to. I have mediocre ignition experience and I haven’t used it in 8 months so I am a bit rusty here and need some help. Below is my query, error code and code I am running:

**ERROR CODE FULL**

Traceback (most recent call last):  
File “event:actionPerformed”, line 5, in   
at com.inductiveautomation.ignition.common.TypeUtilities.coerce(TypeUtilities.java:1434)  
at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.coerce(PyArgumentMap.java:130)  
at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:82)  
at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:40)  
at com.inductiveautomation.ignition.client.script.ClientDBUtilities.runNamedQuery(ClientDBUtilities.java:105)  
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)  
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.base/java.lang.reflect.Method.invoke(Unknown Source)  
java.lang.ClassCastException: java.lang.ClassCastException: Cannot coerce value ‘P1551370-07-D:STRR220710G0AK9’ into type: interface java.util.Map

```
at org.python.core.Py.JavaError(Py.java:552)
at org.python.core.Py.JavaError(Py.java:543)
at org.python.core.PyReflectedFunction. __call__ (PyReflectedFunction.java:190)
at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction. __call__ (ScriptManager.java:539)
at org.python.core.PyObject. __call__ (PyObject.java:497)
at org.python.core.PyObject. __call__ (PyObject.java:501)
at org.python.pycode._pyx37.f$0(<event:actionPerformed>:5)
at org.python.pycode._pyx37.call_function(<event:actionPerformed>)
at org.python.core.PyTableCode.call(PyTableCode.java:171)
at org.python.core.PyCode.call(PyCode.java:18)
at org.python.core.Py.runCode(Py.java:1614)
at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:799)
at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.runActions(ActionAdapter.java:206)
at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.invoke(ActionAdapter.java:297)
at com.inductiveautomation.factorypmi.application.binding.action.RelayInvocationHandler.invoke(RelayInvocationHandler.java:57)
at com.sun.proxy.$Proxy63.actionPerformed(Unknown Source)
at java.desktop/javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at java.desktop/javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.desktop/java.awt.Component.processMouseEvent(Unknown Source)
at java.desktop/javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.desktop/java.awt.Component.processEvent(Unknown Source)
at java.desktop/java.awt.Container.processEvent(Unknown Source)
at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Window.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)

```

Caused by: java.lang.ClassCastException: Cannot coerce value ‘P1551370-07-D:STRR220710G0AK9’ into type: interface java.util.Map  
at com.inductiveautomation.ignition.common.TypeUtilities.coerce(TypeUtilities.java:1434)  
at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.coerce(PyArgumentMap.java:130)  
at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:82)  
at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:40)  
at com.inductiveautomation.ignition.client.script.ClientDBUtilities.runNamedQuery(ClientDBUtilities.java:105)  
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)  
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.base/java.lang.reflect.Method.invoke(Unknown Source)  
at org.python.core.PyReflectedFunction. **call** (PyReflectedFunction.java:188)  
… 48 more

Ignition v8.1.7 (b2021060314)  
Java: Azul Systems, Inc. 11.0.11

**QUERY FULL**

SELECT Cell\_ID, Pre\_EFill\_Weight, Preweigh\_Lower\_Spec\_Okay, EFill\_Number, Fill\_Head, Boat\_Num, Boat\_Position, Weight\_Post\_EFill, Weight\_Delta, Date

FROM (SELECT component\_id as Cell\_ID, From\_UNIXTIME(observed\_at\_seconds) as Weigh\_timestamp\_PST, location\_name as EFill\_Number, event\_dt as Date

FROM `ion-rpt`.roadrunner\_ion\_observations\_taskresults

WHERE component\_id = :Component\_ID  
AND location\_name LIKE ‘cm2\_49%’  
) as main\_info

LEFT JOIN(SELECT component\_id, submitted\_value AS Boat\_Position  
FROM `ion-rpt`.roadrunner\_ion\_observations\_taskresults  
WHERE location\_name like ‘%cm2\_49%’  
AND task\_name = ‘preweigh\_data’  
AND parameter\_name = ‘cell\_boat\_position’) as BoatPos  
ON main\_info.Cell\_ID = BoatPos.component\_id

LEFT JOIN(SELECT component\_id, submitted\_value AS Fill\_Head  
FROM `ion-rpt`.roadrunner\_ion\_observations\_taskresults  
WHERE location\_name like ‘%cm2\_49%’  
AND task\_name = ‘electrolyte\_fill\_cell’  
AND parameter\_name = ‘fill\_head’) as FillHead  
ON main\_info.Cell\_ID = FillHead.component\_id

LEFT JOIN(SELECT component\_id, submitted\_value AS Boat\_Num  
FROM `ion-rpt`.roadrunner\_ion\_observations\_taskresults  
WHERE location\_name like ‘%cm2\_49%’  
AND task\_name = ‘preweigh\_data’  
AND parameter\_name = ‘boat\_id’) as BoatNum  
ON main\_info.Cell\_ID = BoatNum.component\_id

LEFT JOIN(SELECT component\_id, submitted\_value as Pre\_EFill\_Weight  
FROM `ion-rpt`.roadrunner\_ion\_observations\_taskresults  
WHERE location\_name like ‘%cm2\_49%’  
AND task\_name = ‘preweigh\_data’  
AND parameter\_name = ‘weight\_pre\_efill’) as PreFill  
ON main\_info.Cell\_ID = PreFill.component\_id

LEFT JOIN(SELECT component\_id, submitted\_value as Preweigh\_Lower\_Spec\_Okay  
FROM `ion-rpt`.roadrunner\_ion\_observations\_taskresults  
WHERE location\_name like ‘%cm2\_49%’  
AND task\_name = ‘preweigh\_data’  
AND parameter\_name = ‘preweigh\_lower\_spec\_okay’) as PreweighLowerSpec  
ON main\_info.Cell\_ID = PreWeighLowerSpec.component\_id

LEFT JOIN(SELECT component\_id, submitted\_value as Weight\_Post\_EFill  
FROM `ion-rpt`.roadrunner\_ion\_observations\_taskresults  
WHERE location\_name like ‘%cm2\_49%’  
AND task\_name = ‘postweigh\_filled\_cell’  
AND parameter\_name = ‘weight\_post\_efill’) as WeightPostFill  
ON main\_info.Cell\_ID = WeightPostFill.component\_id

LEFT JOIN(SELECT component\_id, submitted\_value as Weight\_Delta  
FROM `ion-rpt`.roadrunner\_ion\_observations\_taskresults  
WHERE location\_name like ‘%cm2\_49%’  
AND task\_name = ‘postweigh\_filled\_cell’  
AND parameter\_name = ‘weight\_delta\_efill’) as WeightDelta  
ON main\_info.Cell\_ID = WeightDelta.component\_id

LIMIT 1

**CODE**

table = event.source.parent.getComponent(‘Power Table’).data  
componentID = event.source.parent.getComponent(‘Text Field’).text

system.db.run(“TMuckley\_Test/ScanSearch”, componentID)

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [March 31, 2022, 12:04pm UTC](https://forum.inductiveautomation.com/t/need-help-with-error-code-and-named-queries/57863/2 "2022-03-31T12:04:05Z")

</div>

> [@Tyler\_Muckley](#):
>
> java.lang.ClassCastException: java.lang.ClassCastException: Cannot coerce value ‘P1551370-07-D:STRR220710G0AK9’ into type: interface java.util.Map

This is your problem. When you call `system.db.runNamedQuery()` you have to supply the parameters as a dictionary.

```auto
system.db.runNamedQuery("TMuckley_Test/ScanSearch", {"Component_ID":componentID})

```

---

<div class="post-metadata">

**Author:** ![Tyler\_Muckley](https://avatars.discourse-cdn.com/v4/letter/t/b4bc9f/32.png) [@Tyler\_Muckley](https://forum.inductiveautomation.com/u/Tyler_Muckley)\
**Post date:** [March 31, 2022, 12:29pm UTC](https://forum.inductiveautomation.com/t/need-help-with-error-code-and-named-queries/57863/3 "2022-03-31T12:29:41Z")

</div>

Oh my god I am an idiot. I even told myself earlier this evening to remember to do this. It’s been a long night LOL. Thank you very much sir. I really appreciate it!!