Could you provide the full stack trace containing "Invalid Date
String" and the full request that causes it?
Are you using any custom code/plugins in Solr?
-Yonik
On Mon, Feb 12, 2018 at 4:55 PM, Antelmo Aguilar <aagui...@nd.edu> wrote:
> Hi,
>
> I was using the following part of a query to get facet buckets so that I
> can use the information in the buckets for some post-processing:
>
> "json":
> "{\"filter\":[\"bundle:pop_sample\",\"has_abundance_data_b:true\",\"has_geodata:true\",\"${project}\"],\"facet\":{\"term\":{\"type\":\"terms\",\"limit\":-1,\"field\":\"${term:species_category}\",\"facet\":{\"collection_dates\":{\"type\":\"terms\",\"limit\":-1,\"field\":\"collection_date\",\"facet\":{\"collection\":
> {\"type\":\"terms\",\"field\":\"collection_assay_id_s\",\"facet\":{\"abnd\":\"sum(div(sample_size_i,
> collection_duration_days_i))\"}}}}}}}}"
>
> Sorry if it is hard to read. Basically what is was doing was getting the
> following buckets:
>
> First bucket will be categorized by "Species category" by default unless we
> pass in the request the "term" parameter which we will categories the first
> bucket by whatever "term" is set to. Then inside this first bucket, we
> create another buckets of the "Collection date" category. Then inside the
> "Collection date" category buckets, we would use some functions to do some
> calculations and return those calculations inside the "Collection date"
> category buckets.
>
> This query is working fine in Solr 6.2, but I upgraded our instance of Solr
> 6.2 to the latest 6.6 version. However it seems that upgrading to Solr 6.6
> broke the above query. Now it complains when trying to create the buckets
> of the "Collection date" category. I get the following error:
>
> Invalid Date String:'Fri Aug 01 00:00:00 UTC 2014'
>
> It seems that when creating the buckets of a date field, it does some
> conversion of the way the date is stored and causes the error to appear.
> Does anyone have an idea as to why this error is happening? I would really
> appreciate any help. Hopefully I was able to explain my issue well.
>
> Thanks,
> Antelmo
