topic Re: DQL error: "exceeded maximum execution time" in DQL

DQL error: "exceeded maximum execution time"

Ellery — Mon, 14 Aug 2023 07:22:57 GMT

Hello,

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

Re: DQL error: "exceeded maximum execution time"

Ed_Cox — Fri, 04 Aug 2023 12:49:56 GMT

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

Re: DQL error: "exceeded maximum execution time"

NathanZ — Wed, 09 Aug 2023 15:46:33 GMT

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

Re: DQL error: "exceeded maximum execution time"

kumargauravin — Sat, 12 Aug 2023 18:44:10 GMT

Same here, any solution?

Re: DQL error: "exceeded maximum execution time"

sivart_89 — Tue, 15 Aug 2023 23:21:36 GMT

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.

Re: DQL error: "exceeded maximum execution time"

robaxelsen — Mon, 21 Aug 2023 14:16:50 GMT

Hi @Ellery - 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.

Re: DQL error: "exceeded maximum execution time"

LawrenceBarratt — Tue, 22 Aug 2023 17:41:13 GMT

Hi @Ellery

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:

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 here

Happy to look over your BizEvent query and make recommendations 🙂

Re: DQL error: "exceeded maximum execution time"

y_buccellato — Wed, 30 Aug 2023 11:31:04 GMT

Thanks @robaxelsen 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