# There was an error on my Kibana dashboard, what should I do?

**URL:** <https://openvidu.discourse.group/t/there-was-an-error-on-my-kibana-dashboard-what-should-i-do/1454>\
**Category:** Issues with deployment\
**Tags:** v2\
**Created:** [July 13, 2020, 8:45am UTC](https://openvidu.discourse.group/t/there-was-an-error-on-my-kibana-dashboard-what-should-i-do/1454 "2020-07-13T08:45:50Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![caffelattenonsugar](https://yyz2.discourse-cdn.com/free1/user_avatar/openvidu.discourse.group/caffelattenonsugar/32/733_2.png) [@caffelattenonsugar](https://openvidu.discourse.group/u/caffelattenonsugar)\
**Post date:** [July 13, 2020, 8:45am UTC](https://openvidu.discourse.group/t/there-was-an-error-on-my-kibana-dashboard-what-should-i-do/1454/1 "2020-07-13T08:45:50Z")

</div>

I am currently trying OpenVidu Pro in an aws environment using cloudformation with a 15-day free trial.  
Since 2.15.0 was recently released, I attempted to upgrade from 2.14.0.  
The OpenVidu server is working fine, and I can make video calls.

However, accessing OpenVidu Sessions (/kibana/app/kibana#/dashboard/2f3fd320-4964-11e9-9bb9-8ff7364e31cb) on the kibana dashboard screen resulted in the attached error.

 ![スクリーンショット 2020-07-13 14.23.56](https://global.discourse-cdn.com/free1/uploads/openvidu/original/1X/0ea40a6ba1d986c3482e47fce35f75db52349b45.png)  
I checked the response from elasticsearch in chrome’s developper tools and found

/kibana/internal/search/es

In response to the request to

{“statusCode”:400, “error”: “Bad Request”," message":"[query\_shard\_exception] failed to create query: For input string: For input string: 2020-07-12T15: 00:00.000Z"", “attributes”:{“error”:{“type “: “query\_shard\_exception”, “reason”: “failed to create query: For input string: For input string: 2020-07-12T 15:00:00.000Z””, “index\_uuid”: “rKlk1m8 tSIKEuIdw0pO1PQ”, “index”: “openvidu”, “caused \_by”:{“type”: “number\_format\_exception”,” reason": "For input string: "For input string: “2020-07-12T15:00: 00.000Z\” }}}}%

I seemed to be getting an error response of I’m trying it out by setting the query parameters for the timestamp field to a string of dates to unix timestamp, and then made a curl request for The response was returned successfully.

Is there any way to prevent this error from occurring in the dashboard?

---

<div class="post-metadata">

**Author:** ![cruizba](https://yyz2.discourse-cdn.com/free1/user_avatar/openvidu.discourse.group/cruizba/32/18_2.png) [@cruizba](https://openvidu.discourse.group/u/cruizba)\
**Post date:** [July 13, 2020, 8:46am UTC](https://openvidu.discourse.group/t/there-was-an-error-on-my-kibana-dashboard-what-should-i-do/1454/2 "2020-07-13T08:46:51Z")

</div>

Hi, there was a problem in version 2.15.0 with ELK. Try to patch it to version 2.15.1. You have instructions [here](https://openvidu.discourse.group/t/openvidu-pro-2-15-1-release/1433)

---

<div class="post-metadata">

**Author:** ![jcdmacleod](https://yyz2.discourse-cdn.com/free1/user_avatar/openvidu.discourse.group/jcdmacleod/32/149_2.png) [@jcdmacleod](https://openvidu.discourse.group/u/jcdmacleod)\
**Post date:** [July 13, 2020, 5:09pm UTC](https://openvidu.discourse.group/t/there-was-an-error-on-my-kibana-dashboard-what-should-i-do/1454/3 "2020-07-13T17:09:51Z")

</div>

Same error for us here. 2.14.0 updated to 2.15.0 produced this error for us. 2.15.0 to 2.15.1 update and error still present. Kibana unusable at this point.

Suggestions?

---

<div class="post-metadata">

**Author:** ![jcdmacleod](https://yyz2.discourse-cdn.com/free1/user_avatar/openvidu.discourse.group/jcdmacleod/32/149_2.png) [@jcdmacleod](https://openvidu.discourse.group/u/jcdmacleod)\
**Post date:** [July 13, 2020, 5:14pm UTC](https://openvidu.discourse.group/t/there-was-an-error-on-my-kibana-dashboard-what-should-i-do/1454/4 "2020-07-13T17:14:49Z")

</div>

We get this error on the following dashboards:

OpenVidu Recordings  
OpenVidu Sessions

OpenVidu Clustering works without any errors.

---

<div class="post-metadata">

**Author:** ![caffelattenonsugar](https://yyz2.discourse-cdn.com/free1/user_avatar/openvidu.discourse.group/caffelattenonsugar/32/733_2.png) [@caffelattenonsugar](https://openvidu.discourse.group/u/caffelattenonsugar)\
**Post date:** [July 14, 2020, 12:54am UTC](https://openvidu.discourse.group/t/there-was-an-error-on-my-kibana-dashboard-what-should-i-do/1454/5 "2020-07-14T00:54:03Z")

</div>

Hello. Thank you for your reply.

I was able to upgrade to 2.15.1 using the method you gave me.

```
ubuntu@ip-172-31-17-56:~$ sudo docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
119bc205bf7d openvidu/openvidu-server-pro:2.15.1 "/bin/bash -c 'expor…" 10 minutes ago Up 10 minutes openvidu_openvidu-server_1
bdb4d168e4ac docker.elastic.co/elasticsearch/elasticsearch:7.8.0 "/tini -- /usr/local…" 10 minutes ago Up 10 minutes 0.0.0.0:9200->9200/tcp, 9300/tcp openvidu_elasticsearch_1
3ac61e905a16 openvidu/openvidu-coturn:1.0.0 "/bin/sh -c /usr/loc…" 10 minutes ago Up 10 minutes openvidu_coturn_1
24b1848a5610 docker.elastic.co/beats/filebeat:7.8.0 "/usr/local/bin/dock…" 10 minutes ago Up 10 minutes openvidu_filebeat_1
233175df08b4 openvidu/openvidu-proxy:3.0.0 "/bin/sh -c 'htpassw…" 10 minutes ago Up 10 minutes openvidu_nginx_1
1d2a6cf03eb1 docker.elastic.co/kibana/kibana:7.8.0 "/usr/local/bin/dumb…" 10 minutes ago Up 10 minutes 0.0.0.0:5601->5601/tcp openvidu_kibana_1
0ac3ab1225fb openvidu/openvidu-redis:1.0.0 "docker-entrypoint.s…" 10 minutes ago Up 10 minutes openvidu_redis_1

```

After restarting the OpenVidu server, I went to Kibana’s OpenVidu Sessions’ I looked at the dashboard. However, the same error as yesterday was occurring.

I checked the network tab of the developer tools in chrome and found that the error occurred with the following request.

```
request:
POST /kibana/internal/search/es
{"params":{"ignoreThrottled":true,"preference":1594687260739,"index":"openvidu","body":{"aggs":{"1":{"avg":{"field":"msSinceEndpointCreation"}}},"size":0,"stored_fields":["*"],"script_fields":{"sizeFormatted":{"script":{"source":"if (doc.containsKey('size')) {\n if (doc['size'].size()==0) {\n return '';\n } else {\n return doc['size'].value;\n }\n} else {\n return '';\n}","lang":"painless"}}},"docvalue_fields":[{"field":"createdAt","format":"date_time"},{"field":"destroyedAt","format":"date_time"},{"field":"startTime","format":"date_time"},{"field":"timestamp","format":"date_time"}],"_source":{"excludes":[]},"query":{"bool":{"must":[{"match_all":{}}],"filter":[{"match_phrase":{"elastic_type.keyword":{"query":"kms"}}},{"match_phrase":{"type.keyword":{"query":"MediaFlowOutStateChange"}}},{"match_phrase":{"state.keyword":{"query":"FLOWING"}}},{"range":{"timestamp":{"gte":"2020-07-13T15:00:00.000Z","lte":"2020-07-14T14:59:59.999Z","format":"strict_date_optional_time"}}}],"should":[],"must_not":[]}}},"rest_total_hits_as_int":true,"ignore_unavailable":true,"ignore_throttled":true,"timeout":"30000ms"},"serverStrategy":"es"}

response:
{
  "statusCode": 400,
  "error": "Bad Request",
  "message": "[query_shard_exception] failed to create query: For input string: \"2020-07-13T15:00:00.000Z\"",
  "attributes": {
    "error": {
      "type": "query_shard_exception",
      "reason": "failed to create query: For input string: \"2020-07-13T15:00:00.000Z\"",
      "index_uuid": "rKlk1m8tSIKEuIdw0pO1PQ",
      "index": "openvidu",
      "caused_by": {
        "type": "number_format_exception",
        "reason": "For input string: \"2020-07-13T15:00:00.000Z\""
      }
    }
  }
}

```

This error response is the same as yesterday.

---

<div class="post-metadata">

**Author:** ![cruizba](https://yyz2.discourse-cdn.com/free1/user_avatar/openvidu.discourse.group/cruizba/32/18_2.png) [@cruizba](https://openvidu.discourse.group/u/cruizba)\
**Post date:** [July 14, 2020, 6:24pm UTC](https://openvidu.discourse.group/t/there-was-an-error-on-my-kibana-dashboard-what-should-i-do/1454/6 "2020-07-14T18:24:11Z")

</div>

Hi @caffelattenonsugar @jcdmacleod:

Unfortunately, your deployment was affected by the bug, and openvidu index was removed from elasticsearch. Data can’t be recovered, but you can fix the stack by doing the following:  
1). Stop OpenVidu:  
In `/opt/openvidu`

```bash
./openvidu stop

```

2). Remove corrupted previous data:

```bash
rm -rf /opt/openvidu/elasticsearch

```

3). Recreate elasticsearch directory:

```bash
mkdir /opt/openvidu/elasticsearch && chown 1000:1000 /opt/openvidu/elasticsearch

```

4). Start OpenVidu:  
In `/opt/openvidu`

```auto
./openvidu start

```

---

<div class="post-metadata">

**Author:** ![caffelattenonsugar](https://yyz2.discourse-cdn.com/free1/user_avatar/openvidu.discourse.group/caffelattenonsugar/32/733_2.png) [@caffelattenonsugar](https://openvidu.discourse.group/u/caffelattenonsugar)\
**Post date:** [July 15, 2020, 1:08am UTC](https://openvidu.discourse.group/t/there-was-an-error-on-my-kibana-dashboard-what-should-i-do/1454/7 "2020-07-15T01:08:53Z")

</div>

Hi @cruizba

I ran the command you gave me and it works fine. Thank you!