# Unable to read response from gateway

**URL:** <https://forum.inductiveautomation.com/t/unable-to-read-response-from-gateway/44491>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [March 15, 2021, 6:18pm UTC](https://forum.inductiveautomation.com/t/unable-to-read-response-from-gateway/44491 "2021-03-15T18:18:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![seanbuckley2698](https://avatars.discourse-cdn.com/v4/letter/s/d6d6ee/32.png) [@seanbuckley2698](https://forum.inductiveautomation.com/u/seanbuckley2698)\
**Post date:** [March 15, 2021, 6:18pm UTC](https://forum.inductiveautomation.com/t/unable-to-read-response-from-gateway/44491/1 "2021-03-15T18:18:59Z")

</div>

When trying to execute my sql query to see if there is duplicate usernames

```auto
SELECT IF(EXISTS(SELECT username FROM auto_users WHERE username = "sean1"), 1, 0)

```

I am getting the following error…

GatewayException: Unable to read response from Gateway.  
caused by org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 76; Element type “column” must be followed by either attribute specifications, “\>” or “/\>”.

Ignition v8.0.16 (b2020082513)  
Java: Azul Systems, Inc. 11.0.7

Does anyone know why this is happening, the SQL is working in MYSQL.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 15, 2021, 7:59pm UTC](https://forum.inductiveautomation.com/t/unable-to-read-response-from-gateway/44491/2 "2021-03-15T19:59:21Z")

</div>

Is this being used in a script? If so, It may help tho see it.

---

<div class="post-metadata">

**Author:** ![seanbuckley2698](https://avatars.discourse-cdn.com/v4/letter/s/d6d6ee/32.png) [@seanbuckley2698](https://forum.inductiveautomation.com/u/seanbuckley2698)\
**Post date:** [March 16, 2021, 2:17pm UTC](https://forum.inductiveautomation.com/t/unable-to-read-response-from-gateway/44491/3 "2021-03-16T14:17:45Z")

</div>

Hi Jordan, I havent tried it as a script yet I am just testing it as a named query.

---

<div class="post-metadata">

**Author:** ![Sangeeta\_Gorai](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@Sangeeta\_Gorai](https://forum.inductiveautomation.com/u/Sangeeta_Gorai)\
**Post date:** [April 10, 2023, 6:14am UTC](https://forum.inductiveautomation.com/t/unable-to-read-response-from-gateway/44491/4 "2023-04-10T06:14:33Z")

</div>

Is there any solution for this , why I m getting the error.

---

<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 10, 2023, 11:49am UTC](https://forum.inductiveautomation.com/t/unable-to-read-response-from-gateway/44491/5 "2023-04-10T11:49:49Z")

</div>

Exactly that error? Consider starting a new topic, and share all potentially relevant information.