# Script field .. shards failed

**URL:** <https://discuss.elastic.co/t/script-field-shards-failed/280290>\
**Category:** Kibana\
**Created:** [August 3, 2021, 9:05am UTC](https://discuss.elastic.co/t/script-field-shards-failed/280290 "2021-08-03T09:05:45Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![djikon](https://avatars.discourse-cdn.com/v4/letter/d/a183cd/32.png) [@djikon](https://discuss.elastic.co/u/djikon)\
**Post date:** [August 3, 2021, 9:05am UTC](https://discuss.elastic.co/t/script-field-shards-failed/280290/1 "2021-08-03T09:05:45Z")

</div>

Hi,  
I create a script field and i have a lot of shards failed.

my script field is just :

doc['evenement.@timestamp'].value.getMillis() - doc['debutSejour'].value.getMillis()

shards failed exist too fort :

if(doc['evenement.categorieMouvement'].value.contains("Exit") && !doc['evenement.@timestamp'].empty) { return (doc['evenement.@timestamp'].value - doc['debutSejour'].value) } else { return null; }

my version is 6.5.4

help me please !  
thank you

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [August 3, 2021, 7:11pm UTC](https://discuss.elastic.co/t/script-field-shards-failed/280290/2 "2021-08-03T19:11:13Z")

</div>

is your time field actually "evenement.@timestamp"? If that is correct you might have to add a check in the scripted field for the field existing in the document if not all documents contain all those fields.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 3, 2021, 11:29pm UTC](https://discuss.elastic.co/t/script-field-shards-failed/280290/3 "2021-08-03T23:29:41Z")

</div>

Welcome to our community! 😃

I just wanted to pop in and make mention that 6.5 has been [EOL](https://www.elastic.co/support/eol) for over a year now, please upgrade ASAP.

---

<div class="post-metadata">

**Author:** ![djikon](https://avatars.discourse-cdn.com/v4/letter/d/a183cd/32.png) [@djikon](https://discuss.elastic.co/u/djikon)\
**Post date:** [August 4, 2021, 8:53am UTC](https://discuss.elastic.co/t/script-field-shards-failed/280290/4 "2021-08-04T08:53:33Z")

</div>

Hi,  
"evenement.@timestamp" is my time field for 1 event and i confirm this field is not present in all documents.  
my new script \>

`if (doc.containsKey('evenement.@timestamp') || doc.containsKey('debutSejour')) { return doc['evenement.@timestamp'].value - doc['debutSejour'].value } else { return null }`

dev tools return \>

{  
"took" : 62,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 353,  
"successful" : 353,  
"skipped" : 0,  
"failed" : 0  
},  
"hits" : {  
"total" : 2544886,  
"max\_score" : 1.0,

but allways shards failed =(

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [August 4, 2021, 9:57am UTC](https://discuss.elastic.co/t/script-field-shards-failed/280290/5 "2021-08-04T09:57:57Z")

</div>

You need an "AND" instead of the "OR" here:  
`if (doc.containsKey('evenement.@timestamp') || doc.containsKey('debutSejour')) `

---

<div class="post-metadata">

**Author:** ![djikon](https://avatars.discourse-cdn.com/v4/letter/d/a183cd/32.png) [@djikon](https://discuss.elastic.co/u/djikon)\
**Post date:** [August 4, 2021, 10:14am UTC](https://discuss.elastic.co/t/script-field-shards-failed/280290/6 "2021-08-04T10:14:54Z")

</div>

`if (doc.containsKey('evenement.@timestamp') && doc.containsKey('debutSejour')) { return doc['evenement.@timestamp'].value - doc['debutSejour'].value } else { return null }`

same result :

{  
"took" : 82,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 353,  
"successful" : 353,  
"skipped" : 0,  
"failed" : 0  
},

preview result \>

[  
{  
"\_id": "6DFq0XkBjzvHLYjgrDwS",  
"Duree du sejour": [  
null  
]  
},

---

<div class="post-metadata">

**Author:** ![djikon](https://avatars.discourse-cdn.com/v4/letter/d/a183cd/32.png) [@djikon](https://discuss.elastic.co/u/djikon)\
**Post date:** [August 9, 2021, 7:26am UTC](https://discuss.elastic.co/t/script-field-shards-failed/280290/7 "2021-08-09T07:26:24Z")

</div>

hi i have resolved my problem.  
thank you

---

<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:** [September 6, 2021, 7:26am UTC](https://discuss.elastic.co/t/script-field-shards-failed/280290/8 "2021-09-06T07:26:41Z")

</div>

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