# system.db.runUpdateQuery Error

**URL:** <https://forum.inductiveautomation.com/t/system-db-runupdatequery-error/26314>\
**Category:** Ignition\
**Tags:** scripting, database\
**Created:** [July 5, 2019, 2:26pm UTC](https://forum.inductiveautomation.com/t/system-db-runupdatequery-error/26314 "2019-07-05T14:26:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![theerthraj.munusamy](https://avatars.discourse-cdn.com/v4/letter/t/45deac/32.png) [@theerthraj.munusamy](https://forum.inductiveautomation.com/u/theerthraj.munusamy)\
**Post date:** [July 5, 2019, 2:26pm UTC](https://forum.inductiveautomation.com/t/system-db-runupdatequery-error/26314/1 "2019-07-05T14:26:29Z")

</div>

Hi,

Am trying to update a table using

system.db.runUpdateQuery(""“UPDATE public.“limits” SET “LSL”=‘10’ WHERE “ID”=‘2’;”"", “postgres”)

But I get this error:

Traceback (most recent call last):  
File “”, line 1, in   
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runUpdateQuery(AbstractDBUtilities.java:183)  
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.Exception: java.lang.Exception: Error executing system.db.runUpdateQuery(UPDATE public.“limits” SET “LSL”=‘10’ WHERE “ID”=‘2’;, postgres, , false)  
at org.python.core.Py.JavaError(Py.java:552)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runUpdateQuery(AbstractDBUtilities.java:183)  
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)  
at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction. **call** (ScriptManager.java:514)  
at org.python.core.PyObject. **call** (PyObject.java:497)  
at org.python.core.PyObject. **call** (PyObject.java:501)  
at org.python.pycode.\_pyx13.f$0(:1)  
at org.python.pycode.\_pyx13.call\_function()  
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 org.python.core.Py.exec(Py.java:1658)  
at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:276)  
at org.python.util.InteractiveInterpreter.runcode(InteractiveInterpreter.java:131)  
at org.python.util.InteractiveInterpreter.runsource(InteractiveInterpreter.java:116)  
at com.inductiveautomation.ignition.designer.gui.tools.jythonconsole.JythonConsole$InterpreterWorker.doInBackground(JythonConsole.java:506)  
at com.inductiveautomation.ignition.designer.gui.tools.jythonconsole.JythonConsole$InterpreterWorker.doInBackground(JythonConsole.java:494)  
at java.desktop/javax.swing.SwingWorker$1.call(Unknown Source)  
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)  
at java.desktop/javax.swing.SwingWorker.run(Unknown Source)  
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at java.base/java.lang.Thread.run(Unknown Source)  
Caused by: java.lang.Exception: Error executing system.db.runUpdateQuery(UPDATE public.“limits” SET “LSL”=‘10’ WHERE “ID”=‘2’;, postgres, , false)  
… 27 more  
Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Cannot run this function when in read-only mode.  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.getResponse(GatewayInterface.java:374)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:273)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:268)  
at com.inductiveautomation.ignition.client.script.ClientDBUtilities.\_runUpdateQuery(ClientDBUtilities.java:189)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runUpdateQuery(AbstractDBUtilities.java:181)  
… 25 more  
Traceback (most recent call last):  
File “”, line 1, in   
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runUpdateQuery(AbstractDBUtilities.java:183)  
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.Exception: java.lang.Exception: Error executing system.db.runUpdateQuery(UPDATE public.“limits” SET “LSL”=‘10’ WHERE “ID”=‘2’;, postgres, , false)

---

<div class="post-metadata">

**Author:** ![theerthraj.munusamy](https://avatars.discourse-cdn.com/v4/letter/t/45deac/32.png) [@theerthraj.munusamy](https://forum.inductiveautomation.com/u/theerthraj.munusamy)\
**Post date:** [July 5, 2019, 3:03pm UTC](https://forum.inductiveautomation.com/t/system-db-runupdatequery-error/26314/2 "2019-07-05T15:03:31Z")

</div>

Got it fixed. It was the damn client security.

Thanks.