topic Re: Dynatrace Workflow Auto-Fetch Execution Plan Returning Null Output in Automations

Dynatrace Workflow Auto-Fetch Execution Plan Returning Null Output

Amita_chede — Wed, 03 Sep 2025 09:20:51 GMT

Hello,

When I tried running the workflow for auto fetch execution plan , the execution plan column is null for all sql id.

Same thing observed with our custom Database as well. However when we go and check manually the execution plan is there and asks to view on DB performance page.

Why I am getting this null execution plan for auto fetch dql ?

Regards

Amita

Re: Dynatrace Workflow Auto-Fetch Execution Plan Returning Null Output

p_devulapalli — Fri, 05 Sep 2025 01:55:09 GMT

@Amita_chede What database are you seeing this issue with? I think there is some issue with the DQL query in the workflow, it does not fetch the sql_id for all of the statements which seems to be the issue here

Re: Dynatrace Workflow Auto-Fetch Execution Plan Returning Null Output

Amita_chede — Fri, 19 Sep 2025 12:36:30 GMT

Hello @p_devulapalli
We are trying this for Oracle DB.

Re: Dynatrace Workflow Auto-Fetch Execution Plan Returning Null Output

ASE — Fri, 05 Dec 2025 22:34:13 GMT

We recently added the ready-made Auto-fetch execution plans workflow to our Dynatrace Workflows.

However, even though it's executing as expected, when in the Databases app, I'm not seeing any Execution plans marked as Available.

I thought the whole point to adding this workflow was so we didn't have to manually fetch execution plans?

Re: Dynatrace Workflow Auto-Fetch Execution Plan Returning Null Output

ChrisRFonz — Sun, 01 Mar 2026 20:48:44 GMT

Is there any update on this? We are seeing the same issue.