DQL error: "exceeded maximum execution time"

[Ellery]

Hello,

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

 

[Ed_Cox]

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

[NathanZ]

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

[kumargauravin]

Same here, any solution?

[sivart_89]

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.

[robaxelsen]

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. 

[y_buccellato]

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

[LawrenceBarratt · Accepted solution]

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 🙂