# Date Column has some rows with NULL - strict\_date\_optional\_time causes Exception

**URL:** <https://discuss.elastic.co/t/date-column-has-some-rows-with-null-strict-date-optional-time-causes-exception/350164>\
**Category:** Elasticsearch\
**Created:** [December 31, 2023, 8:14pm UTC](https://discuss.elastic.co/t/date-column-has-some-rows-with-null-strict-date-optional-time-causes-exception/350164 "2023-12-31T20:14:27Z")\
**Posts on this page:** 5\
**Page:** 2

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [January 1, 2024, 4:48pm UTC](https://discuss.elastic.co/t/date-column-has-some-rows-with-null-strict-date-optional-time-causes-exception/350164/21 "2024-01-01T16:48:55Z")

</div>

> [@Ethan777100](#):
>
> How did extra rows appear in my Index?

A mystery for you to solve!

You could try real quick with filebeat see if you get the same.

---

<div class="post-metadata">

**Author:** ![Ethan777100](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ethan777100/32/70366_2.png) [@Ethan777100](https://discuss.elastic.co/u/Ethan777100)\
**Post date:** [January 1, 2024, 4:54pm UTC](https://discuss.elastic.co/t/date-column-has-some-rows-with-null-strict-date-optional-time-causes-exception/350164/22 "2024-01-01T16:54:42Z")

</div>

A new docker container to host filebeat?

Venturing into smth new just to experiment.

Is this the only config file I need?

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [January 1, 2024, 5:00pm UTC](https://discuss.elastic.co/t/date-column-has-some-rows-with-null-strict-date-optional-time-causes-exception/350164/23 "2024-01-01T17:00:09Z")

</div>

That was just a suggestion

I wouldn't bother with docker. ...I would just download the filebeat .zip and try from the command line I gave you the filebeat.yml above you just need to adjust a bit

> [@Ethan777100](#):
>
> ```auto
> filter {
> mutate {
> gsub => ["message", "\r", ""]
> }
> }
> 
> ```

I wonder if you are having trouble with the newlines?

I am just giving suggestions....

You gotta figure it out...

---

<div class="post-metadata">

**Author:** ![Ethan777100](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ethan777100/32/70366_2.png) [@Ethan777100](https://discuss.elastic.co/u/Ethan777100)\
**Post date:** [January 1, 2024, 5:11pm UTC](https://discuss.elastic.co/t/date-column-has-some-rows-with-null-strict-date-optional-time-causes-exception/350164/24 "2024-01-01T17:11:46Z")

</div>

I don't even know where to start looking for the new lines issue 😂

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/2/12a64cb70fb9002da002bfd510232eac3e371087.png)

But I just managed to get 2 big csv files ingested for this data category.

I think I will continue data analysis first as per smooth-business. From more intimate usage, i might see any flaws in quality to hinder my work.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 29, 2024, 5:12pm UTC](https://discuss.elastic.co/t/date-column-has-some-rows-with-null-strict-date-optional-time-causes-exception/350164/25 "2024-01-29T17:12:38Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

[Previous page](https://discuss.elastic.co/t/date-column-has-some-rows-with-null-strict-date-optional-time-causes-exception/350164.md?page=1)