# Named Query Transaction Closed

**URL:** <https://forum.inductiveautomation.com/t/named-query-transaction-closed/43595>\
**Category:** Ignition\
**Created:** [February 18, 2021, 10:59pm UTC](https://forum.inductiveautomation.com/t/named-query-transaction-closed/43595 "2021-02-18T22:59:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\
**Post date:** [February 18, 2021, 10:59pm UTC](https://forum.inductiveautomation.com/t/named-query-transaction-closed/43595/1 "2021-02-18T22:59:54Z")

</div>

Why when I run the following code in a gateway script I get an error on line 3 saying the transaction has been closed? If I run the same code in the script console it works fine.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/8/38fd0bd71f2e3ec7f98bcc3d899e80865333bf2e.png)

> com.inductiveautomation.ignition.common.script.JythonExecException: Traceback (most recent call last): File "", line 3, in at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor$NamedQueryInstance.execute(NamedQueryExecutor.java:413) at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor.execute(NamedQueryExecutor.java:176) at com.inductiveautomation.ignition.gateway.db.namedquery.GatewayNamedQueryManager.execute(GatewayNamedQueryManager.java:91) at com.inductiveautomation.ignition.gateway.script.GatewayDBUtilities.runNamedQuery(GatewayDBUtilities.java:402) at jdk.internal.reflect.GeneratedMethodAccessor40.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.Exception: java.lang.Exception: java.sql.SQLException: Transaction "cf24130f-799d-40ba-b1fa-830cb651e99d" is closed.