# Connection to gateway disconnects/connects because of query?

**URL:** <https://forum.inductiveautomation.com/t/connection-to-gateway-disconnects-connects-because-of-query/7611>\
**Category:** Ignition\
**Created:** [November 22, 2013, 4:43am UTC](https://forum.inductiveautomation.com/t/connection-to-gateway-disconnects-connects-because-of-query/7611 "2013-11-22T04:43:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cacordova](https://avatars.discourse-cdn.com/v4/letter/c/bbce88/32.png) [@cacordova](https://forum.inductiveautomation.com/u/cacordova)\
**Post date:** [November 22, 2013, 4:43am UTC](https://forum.inductiveautomation.com/t/connection-to-gateway-disconnects-connects-because-of-query/7611/1 "2013-11-22T04:43:00Z")

</div>

Hi, I have this very long query wherein i do

[code]SET @location = ‘2/12 Influent Wells - EW-12-05-180-M’;

SELECT @location AS LOCATION,  
ROUND(sum(CASE WHEN t2.tagid = ‘2874’ THEN t2.floatvalue ELSE 0 END), 2) AS Meter\_Reading,  
ROUND(sum(CASE WHEN t2.tagid = ‘2734’ THEN t2.floatvalue ELSE 0 END), 2) AS GPM,  
ROUND(sum(CASE WHEN t2.tagid = ‘2735’ THEN t2.floatvalue ELSE 0 END), 2) AS PSI,  
ROUND(sum(CASE WHEN t2.tagid = ‘2736’ THEN t2.floatvalue ELSE 0 END), 2) AS DTW

FROM sqlt\_data\_2\_2013\_11 t2

INNER JOIN sqlth\_te t1  
ON t1.id = t2.tagid

WHERE t2.t\_stamp = (SELECT MAX(t2.t\_stamp)  
FROM sqlt\_data\_2\_2013\_11 t2  
WHERE t1.id = t2.tagid)

UNION ALL

SELECT ‘aes/fortord/site 12 slc/ew 12 06 180m/fiq’ AS LOCATION, /_EW-12-06-180-M_/  
ROUND(sum(CASE WHEN t2.tagid = ‘2876’ THEN t2.floatvalue ELSE 0 END), 2) AS Meter\_Reading,  
ROUND(sum(CASE WHEN t2.tagid = ‘2743’ THEN t2.floatvalue ELSE 0 END), 2) AS GPM,  
ROUND(sum(CASE WHEN t2.tagid = ‘2744’ THEN t2.floatvalue ELSE 0 END), 2) AS PSI,  
ROUND(sum(CASE WHEN t2.tagid = ‘2742’ THEN t2.floatvalue ELSE 0 END), 2) AS DTW

FROM sqlt\_data\_2\_2013\_11 t2

INNER JOIN sqlth\_te t1  
ON t1.id = t2.tagid

WHERE t2.t\_stamp = (SELECT MAX(t2.t\_stamp)  
FROM sqlt\_data\_2\_2013\_11 t2  
WHERE t1.id = t2.tagid)

.  
.  
.  
.  
.  
UNION ALL [/code]

I’ve noticed that since I started that sql query my connection to the gateway on the designer keeps disconnecting then connects back again and again.

Could it be because of this? Could it be something like query overload can that happen?

---

<div class="post-metadata">

**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\
**Post date:** [December 24, 2013, 12:24am UTC](https://forum.inductiveautomation.com/t/connection-to-gateway-disconnects-connects-because-of-query/7611/2 "2013-12-24T00:24:56Z")

</div>

That is a distinct possibility. Do you get any errors in the Designer Console? Also, check the Gateway “Status \> Database Connections” page and see what the stats for that connection are.