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

Question

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.

Gary Smart · Accepted Answer

Gary,

I have seen a similar issue where performing a re-index (along with deleting the existing index) resolved the issue. You can do this by going to Admin > Search > Schedule System Index > Click OK > Check the checkbox for "Delete existing data when index is performed" > Click Index.

Hope this helps,

Lori