# Designer to Vision issue

**URL:** <https://forum.inductiveautomation.com/t/designer-to-vision-issue/18366>\
**Category:** Ignition\
**Created:** [June 8, 2018, 7:02pm UTC](https://forum.inductiveautomation.com/t/designer-to-vision-issue/18366 "2018-06-08T19:02:20Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ingeniero.aplicacion](https://avatars.discourse-cdn.com/v4/letter/i/57b2e6/32.png) [@ingeniero.aplicacion](https://forum.inductiveautomation.com/u/ingeniero.aplicacion)\
**Post date:** [June 8, 2018, 7:02pm UTC](https://forum.inductiveautomation.com/t/designer-to-vision-issue/18366/1 "2018-06-08T19:02:20Z")

</div>

Hi everyone,

I have a Map Panel and a table that receives the information by a DB Browse in the designer, i see the information in the table and a point in the map as seen below.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/ee6f6754f7c1b83abc37b06eb4a44d0bf0a423b0.png)

But when i launch the project, the table generates an error and the map does not show the point

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/72389f91e03c5d0564908347e6b4e16fdc205cb0.png)

What could be happening?

I appreciate your help

---

<div class="post-metadata">

**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Post date:** [June 8, 2018, 7:09pm UTC](https://forum.inductiveautomation.com/t/designer-to-vision-issue/18366/2 "2018-06-08T19:09:41Z")

</div>

In your SQL binding on the table, did you set the default database correctly?

What does the query look like?

---

<div class="post-metadata">

**Author:** ![ingeniero.aplicacion](https://avatars.discourse-cdn.com/v4/letter/i/57b2e6/32.png) [@ingeniero.aplicacion](https://forum.inductiveautomation.com/u/ingeniero.aplicacion)\
**Post date:** [June 8, 2018, 7:11pm UTC](https://forum.inductiveautomation.com/t/designer-to-vision-issue/18366/3 "2018-06-08T19:11:36Z")

</div>

![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/aa4745bc4d84dbb7166ca772b979a1cd6c478e42.png)

---

<div class="post-metadata">

**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Post date:** [June 8, 2018, 7:15pm UTC](https://forum.inductiveautomation.com/t/designer-to-vision-issue/18366/4 "2018-06-08T19:15:49Z")

</div>

If you open the Diagnostics window in your client (in the menu under Help)  
does a specific error appear when you first open that window?

---

<div class="post-metadata">

**Author:** ![ingeniero.aplicacion](https://avatars.discourse-cdn.com/v4/letter/i/57b2e6/32.png) [@ingeniero.aplicacion](https://forum.inductiveautomation.com/u/ingeniero.aplicacion)\
**Post date:** [June 8, 2018, 7:19pm UTC](https://forum.inductiveautomation.com/t/designer-to-vision-issue/18366/5 "2018-06-08T19:19:31Z")

</div>

14:17:27.735 [AWT-EventQueue-2] WARN Vision.Binding.SQLPropertyAdapter - Error running query:  
SQLQuery(query=SELECT LGP\_Est\_Lat, LGP\_Est\_Long FROM Variables\_Estáticas\_LGPs WHERE LGP\_Est\_ID = ‘DAS874AE442474DV’, database=MySQL)@0ms  
On: Main Window.Root Container.Table.data  
java.lang.Exception: Error running query:  
SQLQuery(query=SELECT LGP\_Est\_Lat, LGP\_Est\_Long FROM Variables\_Estáticas\_LGPs WHERE LGP\_Est\_ID = ‘DAS874AE442474DV’, database=MySQL)@0ms  
On: Main Window.Root Container.Table.data  
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:308)  
at 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: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.runLimitQuery(GatewayInterface.java:819)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.runQuery(GatewayInterface.java:789)  
at com.inductiveautomation.factorypmi.application.gateway.SQLQuery.execute(SQLQuery.java:50)  
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.execute(QueryManager.java:657)  
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.access$500(QueryManager.java:630)  
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:306)  
… 1 common frames omitted

---

<div class="post-metadata">

**Author:** ![ingeniero.aplicacion](https://avatars.discourse-cdn.com/v4/letter/i/57b2e6/32.png) [@ingeniero.aplicacion](https://forum.inductiveautomation.com/u/ingeniero.aplicacion)\
**Post date:** [June 8, 2018, 7:22pm UTC](https://forum.inductiveautomation.com/t/designer-to-vision-issue/18366/6 "2018-06-08T19:22:48Z")

</div>

My user is admin, how can i change roles?

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [June 8, 2018, 7:32pm UTC](https://forum.inductiveautomation.com/t/designer-to-vision-issue/18366/7 "2018-06-08T19:32:20Z")

</div>

Looks like this is a new project and you haven’t enabled [legacy database access](https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-ClientPermissions) for clients.
