# Report Query Read Timed Out

**URL:** <https://forum.inductiveautomation.com/t/report-query-read-timed-out/40912>\
**Category:** Ignition\
**Created:** [November 24, 2020, 4:40am UTC](https://forum.inductiveautomation.com/t/report-query-read-timed-out/40912 "2020-11-24T04:40:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![aharris](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@aharris](https://forum.inductiveautomation.com/u/aharris)\
**Post date:** [November 24, 2020, 4:40am UTC](https://forum.inductiveautomation.com/t/report-query-read-timed-out/40912/1 "2020-11-24T04:40:40Z")

</div>

I’m getting a read timed out on some reports that were previously working fine. I ran the query in the query console and the results return instantly. Unless I’m not understanding the start and end day I think I ran retrieved the same data. I tried increasing the read timeout from 60 to 240 seconds which did seem to increase the timeout but the report still timed out. Any ideas out there on this one? I’m new to reports and trying to figure out the issue with this report create long ago by my colleague.

```auto

select res.dataday, rtl.reporttagdesc, res.StartCounts, 
		res.totalOnTime, res.avgOnTime, res.minOnTime, res.minOnOccur, res.maxOnTime, res.maxOnOccur, 
		res.totalOffTime, res.avgOffTime, res.minOffTime, res.minOffOccur, res.maxOffTime, res.maxOffOccur, rtl.TotalPumpsAtLiftStation, 
		res.TotalOnTimeSec,
		res.avgOnTimeSec, res.avgOffTimeSec, res.minOnTimeSec, res.maxOnTimeSec,
		rtl.ReportGroupDesc
	from report_tag_lookup rtl inner join
	report_equipment_summarized res on rtl.ReportTagId = res.ReportTagId
where res.DataDay >= ? and res.DataDay < ? and rtl.report = 'Equipment'
order by rtl.ReportGroupOrder, rtl.ReportTagOrderWithinGroup, res.dataday

```