topic Solr cannot index dates in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/solr-cannot-index-dates/m-p/274348#M227478 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am trying to index the fields which have type d_datetime as proper date fields (type "date" or "tdate") in Solr. For this, I have added the type and the field in schema.xml:</SPAN><BR /><BR /><BR /><SPAN>fieldType name="date" class="solr.DateField" sortMissingLast="true" omitNorms="true"</SPAN><BR /><SPAN>….</SPAN><BR /><SPAN>field name="@{</SPAN><A href="http://www.xenit.eu/fred/example/model/0.1}purchase_date" rel="nofollow noopener noreferrer">http://www.xenit.eu/fred/example/model/0.1}purchase_date</A><SPAN>" type="tdate" indexed="true" stored="true"</SPAN><BR /><BR /><SPAN>However, they are not indexed and the message in the log are:</SPAN><BR /><BR /><BR /><SPAN>WARNING: Node index failed and skipped for 861 in Tx 46</SPAN><BR /><SPAN>org.apache.solr.common.SolrException: Invalid Date String:'2013-02-01T19:26:54.000+01:00'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.solr.schema.DateField.parseMath(DateField.java:163)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.solr.schema.TrieDateField.createField(TrieDateField.java:171)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.solr.schema.SchemaField.createField(SchemaField.java:94)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.solr.tracker.CoreTracker.toDocument(CoreTracker.java:3458)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.solr.tracker.CoreTracker.indexNode(CoreTracker.java:2344)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.solr.tracker.MultiThreadedCoreTracker$NodeIndexWorkerRunnable.doWork(MultiThreadedCoreTracker.java:806)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.solr.tracker.MultiThreadedCoreTracker$AbstractWorkerRunnable.run(MultiThreadedCoreTracker.java:747)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:662)</SPAN><BR /><BR /><SPAN>I think this is because Solr only understands UTC dates. Is there any way to convert Alfresco's dates to UTC?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>roxana</SPAN></BODY></HTML> Mon, 04 Feb 2013 18:54:48 GMT anghelutar 2013-02-04T18:54:48Z Solr cannot index dates https://connect.hyland.com/t5/alfresco-archive/solr-cannot-index-dates/m-p/274348#M227478 Hello,I am trying to index the fields which have type d_datetime as proper date fields (type "date" or "tdate") in Solr. For this, I have added the type and the field in schema.xml:fieldType name="date" class="solr.DateField" sortMissingLast="true" omitNorms="true"….field name="@{http://www.xenit.eu Mon, 04 Feb 2013 18:54:48 GMT https://connect.hyland.com/t5/alfresco-archive/solr-cannot-index-dates/m-p/274348#M227478 anghelutar 2013-02-04T18:54:48Z Re: Solr cannot index dates https://connect.hyland.com/t5/alfresco-archive/solr-cannot-index-dates/m-p/274349#M227479 <HTML><HEAD></HEAD><BODY><SPAN>Hi roxana,</SPAN><BR /><BR /><SPAN>why not using the built-in support of Alfresco for date fields in SOLR? </SPAN><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Jens</SPAN></BODY></HTML> Sun, 17 Feb 2013 21:23:28 GMT https://connect.hyland.com/t5/alfresco-archive/solr-cannot-index-dates/m-p/274349#M227479 jego 2013-02-17T21:23:28Z