# Could not index event to Elasticsearch

**URL:** <https://discuss.elastic.co/t/could-not-index-event-to-elasticsearch/371385>\
**Category:** Elasticsearch\
**Created:** [December 3, 2024, 1:15pm UTC](https://discuss.elastic.co/t/could-not-index-event-to-elasticsearch/371385 "2024-12-03T13:15:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![deepika\_raghav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/deepika_raghav/32/139659_2.png) [@deepika\_raghav](https://discuss.elastic.co/u/deepika_raghav)\
**Post date:** [December 3, 2024, 1:15pm UTC](https://discuss.elastic.co/t/could-not-index-event-to-elasticsearch/371385/1 "2024-12-03T13:15:58Z")

</div>

hi I am facing issues while trying to create an index by querying microsoft sql server and the error I am facing as follows  
Could not index event to Elasticsearch. {:status=\>400, :action=\>["index", {:\_id=\>nil, :\_index=\>"index\_name", :routing=\>nil}, {"@version"=\>"1", "column\_name"=\>000000000000.0, "@timestamp"=\>2024-12-03T12:29:53.637323178Z}], :response=\>{"index"=\>{"\_index"=\>"index\_name", "\_id"=\>nil, "status"=\>400, "error"=\>{"type"=\>"illegal\_argument\_exception", "reason"=\>"Validation Failed: 1: this action would add [2] shards, but this cluster currently has [4999]/[5000] maximum normal shards open;"}}}}

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [December 3, 2024, 1:23pm UTC](https://discuss.elastic.co/t/could-not-index-event-to-elasticsearch/371385/2 "2024-12-03T13:23:00Z")

</div>

It looks like you have hit the built-in limit on the number of shards each data node can hold, which is 1000. I therefore assume you have 5 data nodes. Why do you have this many shards? What is the average shard size?

Which version of Elasticsearch are you using?

---

<div class="post-metadata">

**Author:** ![deepika\_raghav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/deepika_raghav/32/139659_2.png) [@deepika\_raghav](https://discuss.elastic.co/u/deepika_raghav)\
**Post date:** [December 4, 2024, 11:52am UTC](https://discuss.elastic.co/t/could-not-index-event-to-elasticsearch/371385/3 "2024-12-04T11:52:06Z")

</div>

> [@Christian\_Dahlqvist](#):
>
> It looks like you have hit the built-in limit on the number of shards each data node can hold, which is 1000. I therefore assume you have 5 data nodes. Why do you have this many shards? What is the average shard size?

hi , I am using the 8.6.1 version