# DQL error: "exceeded maximum execution time"

**URL:** <https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004>\
**Category:** DQL\
**Tags:** dql\
**Created:** [August 3, 2023, 12:41am UTC](https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004 "2023-08-03T00:41:15Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ellery](https://avatars.discourse-cdn.com/v4/letter/e/5e9695/32.png) [@Ellery](https://community.dynatrace.com/u/Ellery)\
**Post date:** [August 3, 2023, 12:41am UTC](https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004/1 "2023-08-03T00:41:15Z")

</div>

Hello,

I am generating a table from a DQL query to BIZ Event data, but after some time, I encounter this error:

 ![excede limite.JPG](https://global.discourse-cdn.com/dynatrace/original/2X/c/cfd4d6fa4e5680ee8fefa549252278a4c72bdf4f.jpeg)

---

<div class="post-metadata">

**Author:** ![Ed\_Cox](https://avatars.discourse-cdn.com/v4/letter/e/4bbf92/32.png) [@Ed\_Cox](https://community.dynatrace.com/u/Ed_Cox)\
**Post date:** [August 4, 2023, 12:49pm UTC](https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004/2 "2023-08-04T12:49:56Z")

</div>

I’m getting that in Log…The tile in the dashboard shows the error, but if I execute the DQL in “configure tile” it works fine with 0 seconds

---

<div class="post-metadata">

**Author:** ![NathanZ](https://avatars.discourse-cdn.com/v4/letter/n/cdc98d/32.png) [@NathanZ](https://community.dynatrace.com/u/NathanZ)\
**Post date:** [August 9, 2023, 3:46pm UTC](https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004/3 "2023-08-09T15:46:33Z")

</div>

I’m having that same issue when fetching logs. When editing the tile the execution time takes less than a second.

---

<div class="post-metadata">

**Author:** ![kumargauravin](https://avatars.discourse-cdn.com/v4/letter/k/a4c791/32.png) [@kumargauravin](https://community.dynatrace.com/u/kumargauravin)\
**Post date:** [August 12, 2023, 6:44pm UTC](https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004/4 "2023-08-12T18:44:10Z")

</div>

Same here, any solution?

---

<div class="post-metadata">

**Author:** ![sivart\_89](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@sivart\_89](https://community.dynatrace.com/u/sivart_89)\
**Post date:** [August 15, 2023, 11:21pm UTC](https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004/5 "2023-08-15T23:21:36Z")

</div>

Yep I am seeing the same thing on our end. Query runs in no time when running the query but it doesn’t load the data in the dashboard tile and shows the same message instead.

---

<div class="post-metadata">

**Author:** ![robaxelsen](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/robaxelsen/32/39552_2.png) [@robaxelsen](https://community.dynatrace.com/u/robaxelsen)\
**Post date:** [August 21, 2023, 2:16pm UTC](https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004/6 "2023-08-21T14:16:50Z")

</div>

Hi&nbsp;[@Ellery](https://community.dynatrace.com/user/65321) - thanks for reporting, and thanks for everyone else for chiming in with your own experiences around this issue. Our engineers are looking into this, and working on a fix.

---

<div class="post-metadata">

**Author:** ![LawrenceBarratt](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/lawrencebarratt/32/26634_2.png) [@LawrenceBarratt](https://community.dynatrace.com/u/LawrenceBarratt)\
**Post date:** [August 22, 2023, 5:41pm UTC](https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004/7 "2023-08-22T17:41:13Z")

</div>

Hi&nbsp;[@Ellery](https://community.dynatrace.com/user/65321)

On this occasion, I recommend using the Platform Dashboards for this use case. They will offer more visualizations and a better experience than using Dashboards Classic.

If you are returning too many rows, you can set your timeframe as shown below:

```java
fetch bizevents, from: now()-1d

```

To get the best experience from BizEvents and Logs, i suggest doing some processing on the values you want and then returning them - see&nbsp;[here](https://www.dynatrace.com/support/help/platform-modules/business-analytics/ba-events-processing)

Happy to look over your BizEvent query and make recommendations&nbsp;🙂

---

<div class="post-metadata">

**Author:** ![y\_buccellato](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/y_buccellato/32/160_2.png) [@y\_buccellato](https://community.dynatrace.com/u/y_buccellato)\
**Post date:** [August 30, 2023, 11:31am UTC](https://community.dynatrace.com/t/dql-error-exceeded-maximum-execution-time/41004/8 "2023-08-30T11:31:04Z")

</div>

Thanks&nbsp;[@robaxelsen](https://community.dynatrace.com/user/40723)&nbsp;I confirm I’m experiencing the same issue randomly in the “old” Dynatrace version when displaying in dashboard metric done via DQL (even if I specify a very limited amount of time).

Let us know as soon as this issue will be addressed on the overall platform,

Best regards
