# Historical data and SQL queries not working on launched project

**URL:** <https://forum.inductiveautomation.com/t/historical-data-and-sql-queries-not-working-on-launched-project/72385>\
**Category:** Ignition\
**Created:** [April 13, 2023, 1:58am UTC](https://forum.inductiveautomation.com/t/historical-data-and-sql-queries-not-working-on-launched-project/72385 "2023-04-13T01:58:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![richard.d.white](https://avatars.discourse-cdn.com/v4/letter/r/b2d939/32.png) [@richard.d.white](https://forum.inductiveautomation.com/u/richard.d.white)\
**Post date:** [April 13, 2023, 1:58am UTC](https://forum.inductiveautomation.com/t/historical-data-and-sql-queries-not-working-on-launched-project/72385/1 "2023-04-13T01:58:20Z")

</div>

Very weird - I have a project with screens that display historical data (easy chart) as well as pull in SQL data via queries. Everything looks great on designer.

However, when I launch the project (from Designer, same laptop) it looks like none of these queries is going through. Please see the screenshot showing designer in the background with the launched project (same screen) in the foreground. Can anyone advise what I'm doing wrong? What could cause everything to work properly in Designer but not in a launched project? There are no user permissions involved here.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/b/2b9a58d7c2dfcde72a528aa6d363c603ec916b12.png)

---

<div class="post-metadata">

**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:** [April 13, 2023, 2:02am UTC](https://forum.inductiveautomation.com/t/historical-data-and-sql-queries-not-working-on-launched-project/72385/2 "2023-04-13T02:02:29Z")

</div>

> [@richard.d.white](#):
>
> There are no user permissions involved here.

But there are. Look in the project properties for SQL query permissions, separate from any authentication. Affects all Vision Client scripted queries, regular query bindings, and EasyChart **database pens**.

---

<div class="post-metadata">

**Author:** ![richard.d.white](https://avatars.discourse-cdn.com/v4/letter/r/b2d939/32.png) [@richard.d.white](https://forum.inductiveautomation.com/u/richard.d.white)\
**Post date:** [April 13, 2023, 2:20am UTC](https://forum.inductiveautomation.com/t/historical-data-and-sql-queries-not-working-on-launched-project/72385/3 "2023-04-13T02:20:13Z")

</div>

As usual you were correct - none of the permissions under Vision / Permissions were checked. I clicked Enable All, and now everything is working!

Mahalo for your help!

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/2/12e3e95acbb154e2ccfc472381923683b6f7459c.png)

---

<div class="post-metadata">

**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:** [April 13, 2023, 11:57am UTC](https://forum.inductiveautomation.com/t/historical-data-and-sql-queries-not-working-on-launched-project/72385/4 "2023-04-13T11:57:52Z")

</div>

> [@richard.d.white](#):
>
> I clicked Enable All

Oy!

Did you really need them all? Each is a potential security hole.