# Power table with SQL binding gives red overlay

**URL:** <https://forum.inductiveautomation.com/t/power-table-with-sql-binding-gives-red-overlay/64047>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [September 14, 2022, 1:12pm UTC](https://forum.inductiveautomation.com/t/power-table-with-sql-binding-gives-red-overlay/64047 "2022-09-14T13:12:06Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alfredo\_Egmo](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\
**Post date:** [September 14, 2022, 1:12pm UTC](https://forum.inductiveautomation.com/t/power-table-with-sql-binding-gives-red-overlay/64047/1 "2022-09-14T13:12:06Z")

</div>

Why the power table with an SQL query (polled) turns red some times (short periods)?  
the SQL server is active and responding properly.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/f/9f06650d1f5a546574ff94fdf4c519c9f0321d24.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:** [September 14, 2022, 1:23pm UTC](https://forum.inductiveautomation.com/t/power-table-with-sql-binding-gives-red-overlay/64047/2 "2022-09-14T13:23:49Z")

</div>

Open the client’s diagnostic window (from the help menu) and look for errors in the console that might explain it.

{ Added the “vision” tag to the topic for you. }

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 14, 2022, 1:40pm UTC](https://forum.inductiveautomation.com/t/power-table-with-sql-binding-gives-red-overlay/64047/3 "2022-09-14T13:40:02Z")

</div>

The vision component overlays are explained here:  
[https://docs.inductiveautomation.com/display/DOC81/Quality+Codes+and+Overlays#QualityCodesandOverlays-VisionComponentOverlays](https://docs.inductiveautomation.com/display/DOC81/Quality+Codes+and+Overlays#QualityCodesandOverlays-VisionComponentOverlays)

---

<div class="post-metadata">

**Author:** ![Alfredo\_Egmo](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\
**Post date:** [September 14, 2022, 2:05pm UTC](https://forum.inductiveautomation.com/t/power-table-with-sql-binding-gives-red-overlay/64047/4 "2022-09-14T14:05:21Z")

</div>

The console looks empty, even having the red in the table it remains empty  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/d/fd20a7339d20d00c89469f71c3e87a3c3b636715.png)

if I check “run diagnostic” in the table I get this, but with no more details. The weird thing is that the query is pretty simple and the data is properly showed in the table.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/5/859d707f369c21c0e3b6102241e5cca14f9d2aec.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:** [September 14, 2022, 2:07pm UTC](https://forum.inductiveautomation.com/t/power-table-with-sql-binding-gives-red-overlay/64047/5 "2022-09-14T14:07:03Z")

</div>

Uh-oh. You have a binding on the component name. Don’t do that.

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [September 14, 2022, 2:09pm UTC](https://forum.inductiveautomation.com/t/power-table-with-sql-binding-gives-red-overlay/64047/6 "2022-09-14T14:09:01Z")

</div>

Your designer diagnostics is saying the query used to populate your data is fine. But apparently you have a database query determining the name of your component, and that query seems to be messing up.

However, I would ask why are you doing that in the first place? Changing the name of a component will surely only mess up any scripts you have, and I don’t know how expressions would work with a component who’s name is changing.

---

<div class="post-metadata">

**Author:** ![Alfredo\_Egmo](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\
**Post date:** [September 14, 2022, 2:12pm UTC](https://forum.inductiveautomation.com/t/power-table-with-sql-binding-gives-red-overlay/64047/7 "2022-09-14T14:12:23Z")

</div>

It was a mistake binding of the name … thanks!