Details about this thread
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 319 subscribers
  • Views 2338 views
  • Users 0 members are here

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

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.

  • 0 Sugar Employee Badge

    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

  • 0 in reply to Lori F

    Thanks! That solved it.

    I never saw that option way down the bottom of the "Schedule System Index" popup. - I was looking for something similar in "Repair".

    Thanks again,

    Gary.