AnsweredAssumed Answered

Elasticsearch java.lang.NumberFormatException: For input string: "2016-08-02 00:00:00"

Question asked by Gary Smart on Aug 1, 2016
Latest reply on Aug 2, 2016 by Gary Smart

Hi,

I'm stuck on an ElasticSearch problem. It all appears to index successfully (via the scheduler), however when a user performs a "Quick Search" SugarCRM fails with a "HTTP: 500 Internal Server Error".

 

 

The Elastic logs show:

[3], node[gd5BvX1SQ2OUxyt4sgoQmg], [P], s[STARTED]: Failed to execute [org.elasticsearch.action.search.SearchRequest@cd4b5] lastShard [true]
java.lang.NumberFormatException: For input string: "2016-08-02 00:00:00"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043)
at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110)
....

There are no errors in sugarcrm.log


We're using SugarCRM 7.7.0 with Elasticsearch 1.4.4 (configured as per the Sugar installation guide).

Any tips or suggestions would be greatly appreciated!

 

Thanks

Gary.

Outcomes