EXTERNAL_OBJECT_EXCEPTION when querying PlatformEventUsageMetric

[Matej Mercina]

Attempting to run the following query

SELECT Name, StartDate, EndDate, Value FROM PlatformEventUsageMetric

in the IC2 SOQL window throws an exception

org.apache.cxf.binding.soap.SoapFault: EXTERNAL_OBJECT_EXCEPTION: The "Id" field is of type number, but the value from the external system is "5.12.2020 0:00". Contact your administrator for help.

This is a sample query from the platform event usage monitoring documentation, here https://developer.salesforce.com/docs/atlas.en-us.platform_events.meta/platform_events/platform_events_monitor_usage.htm

This exact same query runs fine in the Developer Console.

[Scott Wells]

Are you working against a Spring '21 org? If so, this could be because IC2 is currently communicating with the org using Winter '21 / API v50.0 and this query is only supported in Spring '21 / API v51.0. If so, this will be resolved when the Spring '21 IC2 update is release (see #1816).

[Matej Mercina]

Hi Scott,

no, the org in question is still in Winter '21 - based on the docs - “PlatformEventUsageMetric is available in API version 50.0 and later.”

[Scott Wells]

Aha. I see what it is. It's IC2's query row count validation query that's executed first, and COUNT() isn't valid for PlatformEventUsageMetric. I have some ways to work around that heuristically, but the error being returned here doesn't fall under that heuristic. I'll include a fix in the next build so that row count validation isn't performed for this particular object.

[Scott Wells]

Fix committed for inclusion in the next build.

[Scott Wells]

Delivered in 2.1.6.1.