AnsweredAssumed Answered

Errors when indexing dates in Solr

Question asked by anghelutar on Feb 4, 2013
Hello,

I am trying to index an Alfresco property which has type d_date as a proper date field in Solr.
For this, I have added the date type and the field in schema.xml:

>fieldType name="tdate" class="solr.TrieDateField" omitNorms="true" positionIncrementGap="0" /<
>field name="@{http://....example/model/0.1}purchase_date" type="tdate" indexed="true" stored="true" <

However, they are not indexed and the messages in the log are:

org.apache.solr.common.SolrException: Invalid Date String:'2013-02-01T19:26:54.000+01:00'
        at org.apache.solr.schema.DateField.parseMath(DateField.java:163)
        at org.apache.solr.schema.TrieDateField.createField(TrieDateField.java:171)
        at org.apache.solr.schema.SchemaField.createField(SchemaField.java:94)
        at org.alfresco.solr.tracker.CoreTracker.toDocument(CoreTracker.java:3458)
        at org.alfresco.solr.tracker.CoreTracker.indexNode(CoreTracker.java:2344)
        at org.alfresco.solr.tracker.MultiThreadedCoreTracker$NodeIndexWorkerRunnable.doWork(MultiThreadedCoreTracker.java:806)
        at org.alfresco.solr.tracker.MultiThreadedCoreTracker$AbstractWorkerRunnable.run(MultiThreadedCoreTracker.java:747)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)

I think this is because Solr only understands UTC dates.
Is there any way to convert Alfresco's dates to UTC?

Thanks,
roxana

Outcomes