# Re: Error getting sample data when open Report template in ignition designer lanucher

**URL:** <https://forum.inductiveautomation.com/t/re-error-getting-sample-data-when-open-report-template-in-ignition-designer-lanucher/85520>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [February 10, 2024, 11:37am UTC](https://forum.inductiveautomation.com/t/re-error-getting-sample-data-when-open-report-template-in-ignition-designer-lanucher/85520 "2024-02-10T11:37:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Apeksha\_Patil](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@Apeksha\_Patil](https://forum.inductiveautomation.com/u/Apeksha_Patil)\
**Post date:** [February 10, 2024, 11:37am UTC](https://forum.inductiveautomation.com/t/re-error-getting-sample-data-when-open-report-template-in-ignition-designer-lanucher/85520/1 "2024-02-10T11:37:56Z")

</div>

When Open Report Template in designer then it shows error like:  
ExecutionException: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Read timed out  
caused by GatewayException: Read timed out  
caused by SocketTimeoutException: Read timed out

Ignition v8.1.37 (b2024013011)  
Java: Azul Systems, Inc. 17.0.9

If anyone has insight on this topic, please kindly share your thoughts  
Thank You

---

<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:** [February 10, 2024, 4:36pm UTC](https://forum.inductiveautomation.com/t/re-error-getting-sample-data-when-open-report-template-in-ignition-designer-lanucher/85520/2 "2024-02-10T16:36:49Z")

</div>

That means the report is too complex to execute within the 60-second time limit for designer-gateway requests.

---

<div class="post-metadata">

**Author:** ![Apeksha\_Patil](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@Apeksha\_Patil](https://forum.inductiveautomation.com/u/Apeksha_Patil)\
**Post date:** [February 12, 2024, 4:06am UTC](https://forum.inductiveautomation.com/t/re-error-getting-sample-data-when-open-report-template-in-ignition-designer-lanucher/85520/3 "2024-02-12T04:06:02Z")

</div>

Thank you for replying. Could you please tell me the solution for this error?  
When I use this named query then it is taking lot of time and after report template is not open

 ![StoredProcedure](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/7/17d2b2899546e312a8facbc2c2cd42e43f94617f.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:** [February 12, 2024, 12:59pm UTC](https://forum.inductiveautomation.com/t/re-error-getting-sample-data-when-open-report-template-in-ignition-designer-lanucher/85520/4 "2024-02-12T12:59:12Z")

</div>

How long does the named query take when you run it by itself? (Using the default date/times configured in your report.)

(Also, your named query is more than one statement. While that can pass through to drivers that support SQL scripts in JDBC, JDBC officially only supports single statements. Beware.)

---

<div class="post-metadata">

**Author:** ![Apeksha\_Patil](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@Apeksha\_Patil](https://forum.inductiveautomation.com/u/Apeksha_Patil)\
**Post date:** [February 13, 2024, 5:40am UTC](https://forum.inductiveautomation.com/t/re-error-getting-sample-data-when-open-report-template-in-ignition-designer-lanucher/85520/5 "2024-02-13T05:40:57Z")

</div>

It takes lot of time such as 7 -8 sec to execute.  
Could you please review the named query that is already saved in the MS SQL database.

 ![StoredProcAlarmPNG](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/2/8289139deba1e21da0455bdd311d23830b036646.png)

and after report template is open with error