# Error Running Query on Vision Client **URL:** \ **Category:** Ignition\ **Tags:** vision\ **Created:** [April 12, 2024, 5:12pm UTC](https://forum.inductiveautomation.com/t/error-running-query-on-vision-client/88748 "2024-04-12T17:12:22Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Nathan\_Heck](https://avatars.discourse-cdn.com/v4/letter/n/c57346/32.png) [@Nathan\_Heck](https://forum.inductiveautomation.com/u/Nathan_Heck)\ **Post date:** [April 12, 2024, 5:12pm UTC](https://forum.inductiveautomation.com/t/error-running-query-on-vision-client/88748/1 "2024-04-12T17:12:23Z")
Hello, I am getting this error. Which to my limited understanding is saying The current user does not have the required rols for this operaton at com.inductiveautomation.ignition.client.gateway\_interface. How would I solve this? Message: [componentName=Numeric Label,targetProperty=value] Error running query: SQLQuery(query=SELECT Setpoint\_Prod\_Max\_Flow FROM recipe\_prod\_table WHERE recipe\_prod\_ndx = 12, database=Historian\_Database)@0ms On: Processing.Root Container.Numeric Label.value Time: Fri Apr 12 1:04:36PM Severity: WARN Logger: Vision.Binding.SQLPropertyAdapter Stack Trace: java.lang.Exception: Error running query: SQLQuery(query=SELECT Setpoint\_Prod\_Max\_Flow FROM recipe\_prod\_table WHERE recipe\_prod\_ndx = 12, database=Historian\_Database)@0ms On: Processing.Root Container.Numeric Label.value     at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:311)     at java.base/java.lang.Thread.run(Unknown Source) Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Error executing function 'RunQuery': The current user does not have the required roles for this operation.     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.newGatewayException(GatewayInterface.java:360)     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:334)     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:287)     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.runLimitQuery(GatewayInterface.java:893)     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.runQuery(GatewayInterface.java:864)     at com.inductiveautomation.factorypmi.application.gateway.SQLQuery.execute(SQLQuery.java:50)     at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.execute(QueryManager.java:668)     at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:308)     ... 1 common frames omitted Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayResponse$GatewayThrowable: The current user does not have the required roles for this operation.     at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:431)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:523)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)     at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:86)     at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1410)     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)     at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1665)     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:527)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:131)     at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:578)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:223)     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1384)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1306)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)     at com.inductiveautomation.catapult.handlers.RemoteHostNameLookupHandler.handle(RemoteHostNameLookupHandler.java:121)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)     at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:301)     at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:51)     at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:141)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)     at org.eclipse.jetty.server.Server.handle(Server.java:563)     at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)     at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)     at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:140)     at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)     at java.lang.Thread.run(null) ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [April 12, 2024, 5:16pm UTC](https://forum.inductiveautomation.com/t/error-running-query-on-vision-client/88748/2 "2024-04-12T17:16:23Z")
Take a look at the Project Permissions, in particular, Legacy Database Access. > **[Vision Project Properties | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/vision/vision-project-properties#vision-permissions-properties)** > > There are a number of properties you can set for your Vision projects within the Designer. For example, there are properties for setting the Touch Screen mode, customizing a client's auto-login, or configuring how the clients receive updates, and... ---
**Author:** ![Nathan\_Heck](https://avatars.discourse-cdn.com/v4/letter/n/c57346/32.png) [@Nathan\_Heck](https://forum.inductiveautomation.com/u/Nathan_Heck)\ **Post date:** [April 12, 2024, 5:21pm UTC](https://forum.inductiveautomation.com/t/error-running-query-on-vision-client/88748/3 "2024-04-12T17:21:02Z")
That was it. I didn't even think about it on the project side. Thank you so much.