Dear SOLR Team,
I am using SOLR 6.6.0 version for indexing data stored in the POSTGRESQL
database. I am facing an issue and needs your help
Below is the snapshot of the table i am trying to index: -
Steps followed for indexing DATETIMELOG field in above table: -
1) First i created field of type "text" and indexed DATETIMELOG in it.
All goes OK and search is possible though it is treated as text which is
natural.
2) Change field type to "date" and re-index all database again without
restarting the SOLR. All goes OK and search is possible and in SOLR
browse interface date is shown in UTC format which is fine
After this i restarted SOLR and tried to re-index again but now i get
below warning and SOLR documents are not getting created.
*org.apache.solr.common.SolrException: Invalid Date String:'2017-12-28
18:50:04.6'*
I tried searching for this problem on internet but not able to find any
solution.
I request you to please help me with this (may be some more
configuration is required which i am not aware of) and let me know in
case any other information is required from side.
Thanks and Regards
Neha Gupta