Dynatrace Workflow Auto-Fetch Execution Plan Returning Null Output

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

@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

Hello @p_devulapalli 
We are trying this for Oracle DB.

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?

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