26 Mar 2025 03:40 AM - edited 26 Mar 2025 03:51 AM
Hello,
We are trying to POC the Salesforce insights extension however we are finding this is failing when retrieving the Event LogFile (Capture log files contents from the EventLogFile API) because it's trying to query for a field that is only available with the Event Monitoring license.
The Event Log File is part of the ootb features, but when the Event Monitoring add-on is enabled, it adds some extra fields to that file and this is what DynatraceSF extension is trying to retrieve.
Logs downloaded from Activegate :
Exception: Received a bad response: GET https://{name_removed}--int.sandbox.my.salesforce.com/services/data/v59.0/query: <Response [400]>: b'[{"message":"\\n Interval,\\n ^\\nERROR at Row:7:Column:21\\nNo such column \'Interval\' on entity \'EventLogFile\'. If you are attempting to use a custom field, be sure to append the \'__c\' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.","errorCode":"INVALID_FIELD"}]'
[65ca0375-8c8e-3c1c-b011-bb42ca0e2c70][-1619890644281460250][195839][err]2025-03-21 01:28:19,071 [ERROR] (ThreadPoolExecutor-0_0): LogFileAgent - error processing logs: Received a bad response: GET https://{name_removed}--int.sandbox.my.salesforce.com/services/data/v59.0/query: <Response [400]>: b'[{"message":"\\n Interval,\\n ^\\nERROR at Row:7:Column:21\\nNo such column \'Interval\' on entity \'EventLogFile\'. If you are attempting to use a custom field, be sure to append the \'__c\' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.","errorCode":"INVALID_FIELD"}]'
From the Activegate logs the error appears to query for a field on the EventLogFile object that is only available on orgs that have the SF Event Monitoring add-on. Event Log files are generated in all Salesforce orgs even if they don't have the Event Monitoring add-on, however some fields on that object are only available when the Event Monitoring add-on is purchased. My understanding is that Dynatrace should be able to consume Event Log Files regardless of acquisition of the add-on. Am I right assuming that? or should Dynatrace only work when the Event Monitoring add-on is available?