# Error query missing

**URL:** <https://forum.inductiveautomation.com/t/error-query-missing/60566>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [June 9, 2022, 5:15pm UTC](https://forum.inductiveautomation.com/t/error-query-missing/60566 "2022-06-09T17:15:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wladimir\_Celedon](https://avatars.discourse-cdn.com/v4/letter/w/9e8a1a/32.png) [@Wladimir\_Celedon](https://forum.inductiveautomation.com/u/Wladimir_Celedon)\
**Post date:** [June 9, 2022, 5:15pm UTC](https://forum.inductiveautomation.com/t/error-query-missing/60566/1 "2022-06-09T17:15:03Z")

</div>

Hi, I have an issue when I make a update query from ignition. I’ve checked the table and the change is realized, but always I get the following error:

**12:29:56.712 [UpdateExecuter 2] ERROR com.inductiveautomation.factorypmi.application.gateway.QueryManager - Error running update query:**  
**""@-1ms**  
**On: aceitado2.Root Container.tb\_calibres.data**  
**com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: SQL error for “”: Query missing.**

The query is:

```auto
tabla = event.source
datos = event.source.data
fila = event.source.selectedRow
if fila >= 0:
	columna = event.source.selectedColumn
	columnas = system.dataset.getColumnHeaders(datos)
	ndx = datos.getValueAt(fila,'NDX')
	parametro = columnas[columna]
	valor = datos.getValueAt(fila,parametro)
	query = "UPDATE PARAMETROS_LINEA_ACEITADO SET %s = %s WHERE NDX = %d" % (parametro,valor,ndx)
	txID = system.db.beginTransaction(database = "main",timeout = 5000)
	system.db.runUpdateQuery(query,"main",txID)
	system.db.commitTransaction(txID)
	system.db.closeTransaction(txID)
	system.db.refresh(tabla,'data')

```

I put some print between the system.db.runUpdate and system.db.commitTransaction, but the error is printed after the system.db.refresh(tabla,‘data’). So, I created a button that execute the last line, but there is no error when I clicked.

What would be the problem?

---

<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:** [June 9, 2022, 5:52pm UTC](https://forum.inductiveautomation.com/t/error-query-missing/60566/3 "2022-06-09T17:52:15Z")

</div>

Does your table have a query binding to the data property? If not, `system.db.refresh` wouldn’t have anything to refresh, maybe?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [June 9, 2022, 5:58pm UTC](https://forum.inductiveautomation.com/t/error-query-missing/60566/4 "2022-06-09T17:58:44Z")

</div>

Wladimir, please use the `</>` code formatting button. Don’t post code as a bullet list! There is an edit button (pencil icon) below your post so you can fix it.

---

<div class="post-metadata">

**Author:** ![Wladimir\_Celedon](https://avatars.discourse-cdn.com/v4/letter/w/9e8a1a/32.png) [@Wladimir\_Celedon](https://forum.inductiveautomation.com/u/Wladimir_Celedon)\
**Post date:** [June 9, 2022, 6:04pm UTC](https://forum.inductiveautomation.com/t/error-query-missing/60566/5 "2022-06-09T18:04:38Z")

</div>

I have a binding query in the table, with a button that execute the system.db.refresh it works.

---

<div class="post-metadata">

**Author:** ![Wladimir\_Celedon](https://avatars.discourse-cdn.com/v4/letter/w/9e8a1a/32.png) [@Wladimir\_Celedon](https://forum.inductiveautomation.com/u/Wladimir_Celedon)\
**Post date:** [August 25, 2022, 8:23pm UTC](https://forum.inductiveautomation.com/t/error-query-missing/60566/6 "2022-08-25T20:23:31Z")

</div>

I made some tests. That is the result:

```auto
QueryManager - Error running update query: ""@-1ms
On: aceitado2.Root Container.tb_calibres.data com.inductiveautomation.ignition.client.gateway_interface.GatewayException: SQL error for "": Query missing.

```

The table is binding with a SQL Query and polling mode is off. In another table I can make changes the first time, but when I tried to modify a columm twice times, I get that error:

```auto
Traceback (most recent call last):

  File "<event:cellEdited>", line 11, in <module>

java.lang.Exception: java.lang.Exception: Error executing system.db.beginTransaction(main, 2, 5000)

	caused by Exception: Error executing system.db.beginTransaction(main, 2, 5000)
	caused by GatewayException: ORA-01453: SET TRANSACTION must be first statement of transaction

	caused by SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction

```

Any suggestion?