No data is displayed in NewRelic SFDC Overview dashboard

[adrianioana]

Hi team, I have just finished setting up the SFDC Overview dashboard following the steps shared in this repository - see the config.yml below:

integration_name: com.newrelic.labs.sfdc.eventlogfiles run_as_service: False cron_interval_minutes: 60 service_schedule: { "hour": "*", "minute": "30" } instances:

• name: sfdc-logs arguments: token_url: https://test.salesforce.com/services/oauth2/token auth: { "grant_type": "password", "client_id": "myAppClientID", "client_secret": "myAppClientSecret", "username": "mySalesforceUsername", "password": "mySalesforcePassword" } cache_enabled: False redis: { "host": "", "port": "", "db_number": 0, "password": "" } date_field: "LogDate" generation_interval: "Hourly" time_lag_minutes: 300 labels: environment: production newrelic: data_format: "logs" api_endpoint: "EU" account_id: "myNewRelicAccountID" license_key: "newRelicLicenseKey"

As far as I can see that the command python3 src/main.py runs successfully and the authentication in Salesforce is working just fine, via the app created earlier, as suggested in the documentation.

using program arguments [] Running query SELECT+Id,+EventType,+CreatedDate,+LogDate,+Interval,+LogFile,+Sequence+From+EventLogFile+Where+LogDate>=2022-09-28T00:17:23.129Z+AND+LogDate<2022-09-28T01:17:24.770Z+AND+Interval='Hourly' sent 10 log messages from log file ApexExecution/IDMWA0 sent 1 log messages from log file ApexSoap/IDNWA0 sent 8 log messages from log file ApexTrigger/IDOWA0 sent 67 log messages from log file API/IDPWA0 sent 22 log messages from log file ApiTotalUsage/IDQWA0 sent 28 log messages from log file BulkApi2/IDRWA0 sent 1 log messages from log file BulkApi/IDSWA0 sent 2 log messages from log file LightningInteraction/IDTWA0 sent 9 log messages from log file LightningPerformance/IDUWA0 sent 4 log messages from log file LoginAs/IDVWA0 sent 9 log messages from log file Login/IDWWA0 sent 103 log messages from log file RestApi/IDXWA0 sent 4 log messages from log file Sites/IDYWA0 sent 224 log messages from log file URI/IDZWA0 sent 3 log messages from log file VisualforceRequest/IDaWAK sent 4 log messages from log file ApexExecution/IDQWAS sent 5 log messages from log file ApexTrigger/IDRWAS sent 43 log messages from log file API/IDSWAS sent 13 log messages from log file ApiTotalUsage/IDTWAS sent 2 log messages from log file AuraRequest/IDUWAS sent 20 log messages from log file BulkApi2/IDVWAS sent 2 log messages from log file BulkApi/IDWWAS sent 1 log messages from log file FlowExecution/IDXWAS sent 1 log messages from log file LightningInteraction/IDYWAS sent 4 log messages from log file LightningPerformance/IDZWAS sent 2 log messages from log file LoginAs/IDaWAC sent 8 log messages from log file Login/IDbWAC sent 3 log messages from log file Logout/IDcWAC sent 79 log messages from log file RestApi/IDdWAC sent 140 log messages from log file URI/IDeWAC sent 1 log messages from log file VisualforceRequest/IDfWAC

Unfortunately, even though the command runs successfully, there is no data ingested in NewRelic.

Is there anything I am missing throughout the process ? I have to mention that this is my first contact with NewRelic.

Thanks in advance.

LaterEdit: If I am changing the data format to events I am getting the following:

using program arguments [] Running query SELECT+Id,+EventType,+CreatedDate,+LogDate,+Interval,+LogFile,+Sequence+From+EventLogFile+Where+LogDate>=2022-09-28T00:29:41.390Z+AND+LogDate<2022-09-28T01:29:42.869Z+AND+Interval='Hourly' newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404 newrelic events api returned code- 404

[shahramk]

hello @adrianioana

I suspect that the salesforce events might be more than 24 hours old, and any event older than 24 hours won't get added to your New Relic account.

please try to generate new events and set your time_lag_minutes in config.yml file to a smaller time. then try again.

For the EU issue, please update your local repo with this updated version

[adrianioana]

Thanks a lot @shahramk, works just fine now. Regards, Adrian