Modern Dashboard throwing 'T3 is already defined' when filters added

Morning Thwacksters,

I'm developing a Modern Dashboard to show all the component output of the 'Azure Blob Services Az' SAM app (which I had to take apart to understand how/why it didn't work then fix it). The dashboard is put together with filtering in mind, so its default SWQL query will grab all instances of this application:

SELECT n.CustomProperties.STORAGE_ACCOUNT_ID as [StorageAccount]
, apma.Components.Name as [Component]
, apma.Components.DetailsUrl as [URL]
, apma.Components.MultipleStatisticData.NumericData as [Value]
FROM Orion.Nodes n
inner join Orion.APM.Application apma on apma.Name = CONCAT('Azure Blob Storage Account Az - ',n.CustomProperties.STORAGE_ACCOUNT_ID)

This works fine. However, if I add a filter to the URL to only show a particular NodeID:

https://www.notarealurl.com/apps/platform/dashboard/67?filters=0_Orion.Nodes_NodeID:eq:1212

It fails with 'T3 already defined' and I can't see where adding the filter might produce a duplicate of an already declared variable:

The 'details' are suitably uninformative, it would be nice if they showed the actual generated SQL query so I could dig deeper.

Any clues?

Cheers
Adrian

Find more posts tagged with

Accepted answers

All comments

fop

Aaah wait, you can expand the fault box AND copy the error to the clipboard, this may help.

fop

...or not.

I've discovered that the issue is the 'apma.Components.MultipleStatisticData.NumericData' line so now I need to work out why that's seen as a Bad Thing. I get the same fault if I link into apma.Components.CurrentStatistics.ComponentStatisticData as well. I can get the same data if I go straight to orion.APM.Application but then I can't filter on NodeID for the rest of the dashboard.