<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: &amp;quot;DateParserVerbose - Failed to parse timestamp&amp;quot; Error: Can TIME_FORMAT accept multiple formats? in Getting Data In</title>
    <link>https://community.splunk.com/t5/Getting-Data-In/quot-DateParserVerbose-Failed-to-parse-timestamp-quot-Error-Can/m-p/173970#M35008</link>
    <description>&lt;P&gt;I have also had the same problem. Using the information found here, I was able to figure it out &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;/P&gt;

&lt;P&gt;&lt;A href="http://www.function1.com/2013/01/oh-no-splunking-log-files-with-multiple-formats-no-problem"&gt;http://www.function1.com/2013/01/oh-no-splunking-log-files-with-multiple-formats-no-problem&lt;/A&gt;&lt;/P&gt;</description>
    <pubDate>Thu, 23 Oct 2014 01:38:19 GMT</pubDate>
    <dc:creator>ShaneNewman</dc:creator>
    <dc:date>2014-10-23T01:38:19Z</dc:date>
    <item>
      <title>"DateParserVerbose - Failed to parse timestamp" Error: Can TIME_FORMAT accept multiple formats?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/quot-DateParserVerbose-Failed-to-parse-timestamp-quot-Error-Can/m-p/173969#M35007</link>
      <description>&lt;P&gt;I am getting these errors, even though i think i have the timestamp parsed correctly based on other splunk answers.&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;2014 22:22:16.138 +0000 WARN  DateParserVerbose - Failed to parse timestamp. Defaulting to timestamp of previous event (Wed Oct 22 22:22:14 2014). Context: source::/app/logs/ocspresponder/ocspresponder.log|host::rat3be-d1-ap|ocsp_app|3549
10-22-2014 22:22:16.138 +0000 WARN  DateParserVerbose - Failed to parse timestamp. Defaulting to timestamp of previous event (Wed Oct 22 22:22:14 2014). Context: source::/app/logs/ocspresponder/ocspresponder.log|host::rat3be-d1-ap|ocsp_app|3549
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;Some sample data i am working with is as follows.&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;2014-10-21 22:01:07,348 [http-bio-8080-exec-1895] INFO  [c.s.s.o.c.OcspController]  GET IP: 24.222.89.103, 10.246.43.228, 72.246.43.217, 207.14.2.74  SN:  10c9cc  CA:  10923  SUCC  
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;Here's my props.conf that i am using&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;[ocsp_app]
MAX_TIMESTAMP_LOOKAHEAD = 24
SHOULD_LINEMERGE = false
TIME_FORMAT = %Y-%m-%d %H:%M:%S,%3N
TZ=UTC
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;I did notice sometimes data comes in with period or a comma for the milliseconds portion.&lt;BR /&gt;
so&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;2014-10-21 22:01:07,348
 2014-10-21 22:01:07.348
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;Can TIME_FORMAT accept regexs?&lt;BR /&gt;
This does not seem to work for me as i still get occasional DateParserVerbose errors with it enabled.&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;TIME_FORMAT = %Y-%m-%d %H:%M:%S(,|.)%3N
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;Also it seems like Splunk recognizes the timestamp by default using data preview but i still see the dateparserverbose errors on the ocsp_app sourcetype.&lt;/P&gt;</description>
      <pubDate>Wed, 22 Oct 2014 22:39:01 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/quot-DateParserVerbose-Failed-to-parse-timestamp-quot-Error-Can/m-p/173969#M35007</guid>
      <dc:creator>sonicZ</dc:creator>
      <dc:date>2014-10-22T22:39:01Z</dc:date>
    </item>
    <item>
      <title>Re: "DateParserVerbose - Failed to parse timestamp" Error: Can TIME_FORMAT accept multiple formats?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/quot-DateParserVerbose-Failed-to-parse-timestamp-quot-Error-Can/m-p/173970#M35008</link>
      <description>&lt;P&gt;I have also had the same problem. Using the information found here, I was able to figure it out &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;/P&gt;

&lt;P&gt;&lt;A href="http://www.function1.com/2013/01/oh-no-splunking-log-files-with-multiple-formats-no-problem"&gt;http://www.function1.com/2013/01/oh-no-splunking-log-files-with-multiple-formats-no-problem&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 23 Oct 2014 01:38:19 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/quot-DateParserVerbose-Failed-to-parse-timestamp-quot-Error-Can/m-p/173970#M35008</guid>
      <dc:creator>ShaneNewman</dc:creator>
      <dc:date>2014-10-23T01:38:19Z</dc:date>
    </item>
  </channel>
</rss>

