topic Re: ES Security App: Multi-line header is missing matching quotation, or could not parse CSV header in Splunk Enterprise Security

ES Security App: Multi-line header is missing matching quotation, or could not parse CSV header

neelamsantosh — Wed, 06 Apr 2016 09:50:15 GMT

I have recurring warnings in splunkd logs with
multi-line header is missing matching quotation, or could not parse CSV header
Though i have replaced the headers with default value of .csv file.

Re: ES Security App: Multi-line header is missing matching quotation, or could not parse CSV header

woodcock — Wed, 06 Apr 2016 13:33:54 GMT

Do this:

https://answers.splunk.com/answers/306569/corrupt-csv-header-how-to-find-the-corrupted-csv.html#answer-306586

Re: ES Security App: Multi-line header is missing matching quotation, or could not parse CSV header

neelamsantosh — Mon, 18 Apr 2016 07:57:40 GMT

Thanks Woodcock,
That didn't help me.

Re: ES Security App: Multi-line header is missing matching quotation, or could not parse CSV header

dshpritz — Mon, 18 Apr 2016 16:16:53 GMT

This is a bug in ES/Core where the lookup searches/scripts that output the various threat intel lookups do not output headers if there are no results for the lookup in question. The other option is that these messages should only occur at DEBUG, not WARN. I believe it is listed as SPL-114701.

Edit: Some additional info. You can replace the empty versions of these files with their .default counterparts, but be aware that there is a good chance that they will be replaced with empty versions again on the next run.

Re: ES Security App: Multi-line header is missing matching quotation, or could not parse CSV header

jwelch_splunk — Tue, 19 Apr 2016 19:58:46 GMT

This is a bug with outputlookup. When no results are found it overwrites the csv with nothing, which in turns overwrites the header of the csv. This is being addressed.

To eliminate this spam

cd /opt/splunk/etc/
create a file called log-local.cfg
add this line:
category.SearchResults=ERROR

I would restart splunk to be safe, but this will eliminate those Spam messages.