# Kibana 7.4.0 date\_nanos discover view surrounding documents broken

**URL:** https://discuss.elastic.co/t/kibana-7-4-0-date-nanos-discover-view-surrounding-documents-broken/204334
**Category:** Kibana
**Created:** [October 20, 2019, 6:46am UTC](https://discuss.elastic.co/t/kibana-7-4-0-date-nanos-discover-view-surrounding-documents-broken/204334 "2019-10-20T06:46:07Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Alex-St](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex-st/32/53975_2.png) [@Alex-St](https://discuss.elastic.co/u/Alex-St)
#### Post date: [October 20, 2019, 6:46am UTC](https://discuss.elastic.co/t/kibana-7-4-0-date-nanos-discover-view-surrounding-documents-broken/204334/1 "2019-10-20T06:46:07Z")

</div>

In discover view, I click view surrounding document: I can see the document I clicked on, but nothing around it. I believe this is related to date\_nanos field type in kibana

Getting the error on the right pane as shown below:

Request to Elasticsearch failed: {  
"error": {  
"root\_cause": [{  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana)."  
}, {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana)."  
}, {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana)."  
}, {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana)."  
}, {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana)."  
}, {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana)."  
}, {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana)."  
}  
],  
"type": "search\_phase\_execution\_exception",  
"reason": "all shards failed",  
"phase": "query",  
"grouped": true,  
"failed\_shards": [{  
"shard": 0,  
"index": "someindex-000001",  
"node": "cRSDEuywTT-6J9sR39\_cMQ",  
"reason": {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana).",  
"caused\_by": {  
"type": "number\_format\_exception",  
"reason": "For input string: "1571512375601432-07""  
}  
}  
}, {  
"shard": 0,  
"index": "someindex2-000001",  
"node": "cRSDEuywTT-6J9sR39\_cMQ",  
"reason": {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana).",  
"caused\_by": {  
"type": "number\_format\_exception",  
"reason": "For input string: "1571512375601432-07""  
}  
}  
}, {  
"shard": 0,  
"index": "someindex3-000002",  
"node": "cRSDEuywTT-6J9sR39\_cMQ",  
"reason": {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana).",  
"caused\_by": {  
"type": "number\_format\_exception",  
"reason": "For input string: "1571512375601432-07""  
}  
}  
}, {  
"shard": 0,  
"index": "someindex4-000001",  
"node": "cRSDEuywTT-6J9sR39\_cMQ",  
"reason": {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana).",  
"caused\_by": {  
"type": "number\_format\_exception",  
"reason": "For input string: "1571512375601432-07""  
}  
}  
}, {  
"shard": 0,  
"index": "someindex6-000002",  
"node": "cRSDEuywTT-6J9sR39\_cMQ",  
"reason": {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana).",  
"caused\_by": {  
"type": "number\_format\_exception",  
"reason": "For input string: "1571512375601432-07""  
}  
}  
}, {  
"shard": 0,  
"index": "someindex5-000001",  
"node": "cRSDEuywTT-6J9sR39\_cMQ",  
"reason": {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana).",  
"caused\_by": {  
"type": "number\_format\_exception",  
"reason": "For input string: "1571512375601432-07""  
}  
}  
}, {  
"shard": 0,  
"index": "someindex7-000002",  
"node": "cRSDEuywTT-6J9sR39\_cMQ",  
"reason": {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana).",  
"caused\_by": {  
"type": "number\_format\_exception",  
"reason": "For input string: "1571512375601432-07""  
}  
}  
}  
],  
"caused\_by": {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana).",  
"caused\_by": {  
"type": "illegal\_argument\_exception",  
"reason": "Failed to parse search\_after value for field [SourceTime](http://somehost:5601/app/kibana).",  
"caused\_by": {  
"type": "number\_format\_exception",  
"reason": "For input string: "1571512375601432-07""  
}  
}  
}  
},  
"status": 400  
}

A new notification appears

---

<div class="post-metadata">

### Author: ![matw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matw/32/13913_2.png) [@matw](https://discuss.elastic.co/u/matw)
#### Post date: [October 21, 2019, 8:42pm UTC](https://discuss.elastic.co/t/kibana-7-4-0-date-nanos-discover-view-surrounding-documents-broken/204334/2 "2019-10-21T20:42:38Z")

</div>

Hi, thanks for reporting this.  
Could you provide a raw JSON ES document? Would be interested how the date\_nanos timestamp was stored. Many thx!

---

<div class="post-metadata">

### Author: ![Alex-St](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex-st/32/53975_2.png) [@Alex-St](https://discuss.elastic.co/u/Alex-St)
#### Post date: [October 23, 2019, 8:40pm UTC](https://discuss.elastic.co/t/kibana-7-4-0-date-nanos-discover-view-surrounding-documents-broken/204334/3 "2019-10-23T20:40:16Z")

</div>

{  
"\_index": "someindex-000002",  
"\_type": "\_doc",  
"\_id": "5JRX-m0Bc5kyokWuOSYf",  
"\_version": 1,  
"\_score": null,  
"\_source": {  
"LogServerTime": "2019-10-23T13:38:02.520874-07:00",  
"SourceTime": "2019-10-23T13:38:02.696874-07:00",  
"Microseconds": 1892782937874,  
"ThreadId": 1,  
"Message": "TID 0x0001 Exiting LogMessagesCallback after 0 ms",  
"DeviceName": "RS-AMTEST-GUI.Nova.OperatorInterface.",  
"TypeName": "EntryExit",  
"ModuleName": "OIClient",  
"FunctionName": "STARTUP",  
"FormatName": "Format1",  
"ToolName": "RV-AMTEST",  
"PackageType": "rcp",  
"FunctionId": 1,  
"DeviceId": 15,  
"FormatId": 1  
},  
"fields": {  
"LogServerTime": [  
"2019-10-23T20:38:02.520874Z"  
],  
"SourceTime": [  
"2019-10-23T20:38:02.696874Z"  
]  
},  
"sort": [  
1571863082696874000,  
46354198  
],  
"$$\_isAnchor": true  
}

---

<div class="post-metadata">

### Author: ![Alex-St](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex-st/32/53975_2.png) [@Alex-St](https://discuss.elastic.co/u/Alex-St)
#### Post date: [October 23, 2019, 9:02pm UTC](https://discuss.elastic.co/t/kibana-7-4-0-date-nanos-discover-view-surrounding-documents-broken/204334/4 "2019-10-23T21:02:36Z")

</div>

@matw  
Also what may be related to this problem is my colleagues in India (time zone and OS regional settings) can see everything in Kibana if timestamp is in standard date format. However, discover view shows no documents if we used date\_nanos field. Looks ![date_nanos_regional_problem](https://us1.discourse-cdn.com/elastic/original/3X/f/4/f4293cec3e1952a0a0f2e6a0dc2415d9a26dce02.png) like the date/time picker somehow resolves to year 1945, which is outside of epoch. They tried using relative and absolute date selection - still can't see any documents.

---

<div class="post-metadata">

### Author: ![matw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matw/32/13913_2.png) [@matw](https://discuss.elastic.co/u/matw)
#### Post date: [October 24, 2019, 10:24am UTC](https://discuss.elastic.co/t/kibana-7-4-0-date-nanos-discover-view-surrounding-documents-broken/204334/5 "2019-10-24T10:24:34Z")

</div>

Thanks for you feedback, I'll investigate the issue

---

<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: [November 21, 2019, 10:24am UTC](https://discuss.elastic.co/t/kibana-7-4-0-date-nanos-discover-view-surrounding-documents-broken/204334/6 "2019-11-21T10:24:35Z")

</div>

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