# system.db.runQuery error **URL:** \ **Category:** Ignition\ **Tags:** ignition80, scripting, database, perspective\ **Created:** [August 10, 2020, 3:19pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554 "2020-08-10T15:19:12Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\ **Post date:** [August 10, 2020, 3:19pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554/1 "2020-08-10T15:19:12Z")
I created 2 more columns based on the example. My NamedQuery “Insert Data” errors on a column error. def runAction(self, event): areaNum = self.getSibling(“Dropdown”).props.value machineName = self.getSibling(“Text Field”).props.text operer = self.getSibling(“DropdownOP”).props.value mainter = self.getSibling(“DropdownMa”).props.value system.db.runNamedQuery(“Insert Data”, {“machineName”:machineName, “areaNumber”:areaNum, “operer”:operer, “mainter”:mainter}) _com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘operer’._ ---
**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\ **Post date:** [August 10, 2020, 3:19pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554/2 "2020-08-10T15:19:52Z")
```auto ''' com.inductiveautomation.ignition.client.gateway_interface.GatewayException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'operer'. at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:341) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:315) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:268) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.invoke(GatewayInterface.java:917) at com.inductiveautomation.ignition.designer.db.namedquery.workspace.NamedQueryTestingPanel$1$1.doInBackground(NamedQueryTestingPanel.java:300) at com.inductiveautomation.ignition.designer.db.namedquery.workspace.NamedQueryTestingPanel$1$1.doInBackground(NamedQueryTestingPanel.java:282) 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: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'operer'. at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor$NamedQueryInstance.execute(NamedQueryExecutor.java:414) at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor.execute(NamedQueryExecutor.java:200) at com.inductiveautomation.ignition.gateway.db.namedquery.GatewayNamedQueryManager.execute(GatewayNamedQueryManager.java:108) at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.NamedQueryFunctions.executeNamedQuery(NamedQueryFunctions.java:72) at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(null) at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(null) at java.lang.reflect.Method.invoke(null) at com.inductiveautomation.ignition.gateway.servlets.gateway.AbstractGatewayFunction.invoke(AbstractGatewayFunction.java:225) at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:411) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:86) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:852) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:535) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:335) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) at org.eclipse.jetty.server.Server.handle(Server.java:530) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:347) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:256) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102) at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:382) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:708) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:626) at java.lang.Thread.run(null) Ignition v8.0.6 (b2019111216) Java: Azul Systems, Inc. 11.0.4 ``` ---
**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\ **Post date:** [August 10, 2020, 3:24pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554/3 "2020-08-10T15:24:45Z")
![opererror](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/e/5e1dcb4fd39b8584577503633afa98d2873205d0.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [August 10, 2020, 3:34pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554/4 "2020-08-10T15:34:11Z")
Missing colons. ---
**Author:** ![kaushik.shah](https://avatars.discourse-cdn.com/v4/letter/k/34f0e0/32.png) [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\ **Post date:** [August 10, 2020, 3:34pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554/5 "2020-08-10T15:34:13Z")
seems like the values are not linked to parameters. can you please try to **put ‘COLON(:)’** in front of it, or drag and drop those parameters again ! ---
**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\ **Post date:** [August 10, 2020, 3:56pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554/6 "2020-08-10T15:56:26Z")
Fixed NamedQuery, but not writing values for dropdownMa or DropdownOP ![value](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/0/90f6c18cd2ac2f3dfa41ebab030b02ef6a862eb3.png) ---
**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\ **Post date:** [August 10, 2020, 3:57pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554/7 "2020-08-10T15:57:53Z")
![sql](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/d/1dcc46eaf2ca4418edb7546d7b0ab4444c3d128a.png) ---
**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\ **Post date:** [August 10, 2020, 3:58pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554/8 "2020-08-10T15:58:26Z")
the named query works, but not writing to db, pics posted ---
**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\ **Post date:** [August 10, 2020, 4:02pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-error/37554/9 "2020-08-10T16:02:42Z")
![colun](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/1/313be392880522322aa7b2321a396d5299450062.png)