# SQL Query on ElasticSearch fails to parse a message, throws illegal\_argument\_exception **URL:** \ **Category:** Elasticsearch\ **Tags:** elastic-stack-sql\ **Created:** [March 3, 2023, 11:36am UTC](https://discuss.elastic.co/t/sql-query-on-elasticsearch-fails-to-parse-a-message-throws-illegal-argument-exception/326931 "2023-03-03T11:36:00Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![pedrodantas](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@pedrodantas](https://discuss.elastic.co/u/pedrodantas)\ **Post date:** [March 3, 2023, 11:36am UTC](https://discuss.elastic.co/t/sql-query-on-elasticsearch-fails-to-parse-a-message-throws-illegal-argument-exception/326931/1 "2023-03-03T11:36:00Z")
Hello, I am trying to query my Elasticsearch environment using a Canvas dashboard on the Kibana App. I am getting a weird error when making a simple SQL query. ![query_1](https://us1.discourse-cdn.com/elastic/original/3X/4/1/4117940535ee88d1525a7c4cae41c9dd701afb6e.png) The illegal\_argument\_exception says that it failed trying to parse a date field. However, message.details.message is not a date, it is received in Elasticsearch as text format so I don't know what could be causing this. ![query_2](https://us1.discourse-cdn.com/elastic/original/3X/4/b/4b7886af40851b9702179e3bac50234cfeea8c3d.png) ![query_3](https://us1.discourse-cdn.com/elastic/original/3X/9/c/9c3b8bc866a588cda5e3b6a0a8c6ab294e777440.png) Can anyone help me? Thank you! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 31, 2023, 11:36am UTC](https://discuss.elastic.co/t/sql-query-on-elasticsearch-fails-to-parse-a-message-throws-illegal-argument-exception/326931/2 "2023-03-31T11:36:17Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.