newrelic / newrelic-salesforce-exporter

New Relic integration for Salesforce logs.
Apache License 2.0
10 stars 14 forks source link

Salesforce and new relic connection error #7

Closed rajkumarmuthusamy closed 7 months ago

rajkumarmuthusamy commented 1 year ago

Trying to connect newrelic with salesforce and getting below error only in salesforce production , the same code is used in non-prod/sandboxes are working as expected.

Relevant Logs / Console output

python src/main.py

using program arguments []

Running query SELECT+Id,+EventType,+CreatedDate,+LogDate,+Interval,+LogFile,+Sequence+From+EventLogFile+Where+LogDate>=2023-05-31T13:43:51.957Z+AND+LogDate<2023-05-31T14:43:52.127Z+AND+Interval='Hourly'

Traceback (most recent call last):

File "/home/ec2-user/newrelic-logs-salesforce-eventlogfile-main/src/main.py", line 102, in

main()

File "/home/ec2-user/newrelic-logs-salesforce-eventlogfile-main/src/main.py", line 79, in main

integration.run()

File "/home/ec2-user/newrelic-logs-salesforce-eventlogfile-main/src/newrelic_logging/integration.py", line 56, in run

logs = client.fetch_logs(sfdc_session)

File "/home/ec2-user/newrelic-logs-salesforce-eventlogfile-main/src/newrelic_logging/salesforce.py", line 287, in fetch_logs

csv_rows = self.parse_csv(download_response, record_id, record_event_type, cached_messages)

File "/home/ec2-user/newrelic-logs-salesforce-eventlogfile-main/src/newrelic_logging/salesforce.py", line 240, in parse_csv

for row in reader:

File "/usr/lib64/python3.9/csv.py", line 111, in next

row = next(self.reader)

_csv.Error: line contains NUL

Your Environment

[TIP]: # Salesforce PROD

rajkumarmuthusamy commented 1 year ago

Any guidance on this issue ?

asllop commented 9 months ago

Hi @rajkumarmuthusamy ! Is this still happening? I've been trying to reproduce but I couldn't. To me, looks like a corrupt CSV file that contains null bytes.

asllop commented 7 months ago

@rajkumarmuthusamy we released v1.0.0 last week. Could you test it and check if the issue is still there?

asllop commented 7 months ago

Closing due to inactivity.