I happened to see this, Ritesh, so let me offer that this issue (#178247) is addressed in the Sitecore 9 version: https://dev.sitecore.net/Downloads/Sitecore%20Experience%20Platform/90/Sitecore%20Experience%20Platform%2090%20Update2/Release%20Notes. That fix, however, resolves the issue ONLY for Sitecore specific DateTime fields (__smallcreateddate, __smallupdateddate). Apparently, an additional patch is necessary to address other DateTime fields with Solr. This patch linked here may resolve the issue: https://sitecore.box.com/s/y4oct5rpf1022hrez3n4gb5fdkc7obyp. Otherwise, open a support ticket with Sitecore and they'll get you squared away.
Thanks, Grant -----Original Message----- From: Ritesh Kumar (Avanade) <v-kur...@microsoft.com.INVALID> Sent: Tuesday, August 20, 2019 7:39 PM To: solr-user@lucene.apache.org Subject: RE: Invalid Date in Date Math String Thanks Eric for the response! Regards Ritesh -----Original Message----- From: Erick Erickson <erickerick...@gmail.com> Sent: Tuesday, August 20, 2019 4:34 PM To: solr-user@lucene.apache.org Subject: Re: Invalid Date in Date Math String You probably need to talk to the SiteCore people. The Apache project doesn’t have much insight into Sitecore, nor does it maintain the .net version of a Solr client… Best, Erick > On Aug 20, 2019, at 7:16 PM, Ritesh Kumar (Avanade) > <v-kur...@microsoft.com.INVALID> wrote: > > Hello, > > We have been using solr 6.6.3 with Sitecore 9, however currently we seem to > be observing the below issue while rebuilding the index "Invalid Date in Date > Math String" > We already applied the patch located at the below location but it did not fix > the issue: > https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgith > ub.com%2FSitecoreSupport%2FSitecore.Support.178247%2Freleases%2Ftag%2F > 8.2.2.0&data=02%7C01%7Cv-kurite%40microsoft.com%7Cf8ba7751ef5b413c > c3de08d725c6da9f%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C63701940 > 8314524415&sdata=Y6rsPNdcpjIvgPFAGVsLYFJqW01fjkcGsxUqKloyvYc%3D&am > p;reserved=0 > > Please let me know if anyone was able to fix this issue with any other > method. (Note: I have updated my Sitecore support ticket as well with > the same details) > > 5980 22:10:20 WARN [Index=xxxxxxx _index] Crawler : AddRecursive > DoItemAdd failed - {F8057A68-6A5A-43ED-8781-BFA36D4DF3EE} > Exception: SolrNet.Exceptions.SolrConnectionException > Message: <?xml version="1.0" encoding="UTF-8"?> <response> <lst > name="responseHeader"><int name="status">400</int><int > name="QTime">325</int></lst><lst name="error"><lst name="metadata"><str > name="error-class">org.apache.solr.common.SolrException</str><str > name="root-error-class">java.time.format.DateTimeParseException</str><str > name="error-class">org.apache.solr.common.SolrException</str><str > name="root-error-class">java.time.format.DateTimeParseException</str><str > name="error-class">org.apache.solr.common.SolrException</str><str > name="root-error-class">java.time.format.DateTimeParseException</str><str > name="error-class">org.apache.solr.common.SolrException</str><str > name="root-error-class">java.time.format.DateTimeParseException</str><str > name="error-class">org.apache.solr.common.SolrException</str><str > name="root-error-class">java.time.format.DateTimeParseException</str><str > name="error-class">org.apache.solr.common.SolrException</str><str > name="root-error-class">java.time.format.DateTimeParseException</str><str > name="error-class">org.apache.solr.common.SolrException</str><str > name="root-error-class">java.time.format.DateTimeParseException</str><str > name="error-class">org.apache.solr.update.processor.DistributedUpdateProcessor$DistributedUpdatesAsyncException</str><str > > name="root-error-class">org.apache.solr.update.processor.DistributedUpdateProcessor$DistributedUpdatesAsyncException</str></lst><str > name="msg">7 Async exceptions during distributed update: > Error from server at x.x.x.x:8983/solr/xxxxxxxx_index_shard2_replica2: > Bad Request > > request: > x.x.x.x:8983/solr/xxxxxxxx_index_shard2_replica2/update?update.distrib > =TOLEADER&distrib.from=https%3A%2F%2F40.113.227.147%3A8983%2Fsolr% > xxxxxxxx_index_shard1_replica3%2F&wt=javabin&version=2 > Remote error message: Invalid Date in Date Math String:'20180730T164926Z' > Error from server at > x.x.x.x:8983/solr/xxxxxxxxx_index_shard1_replica2: Bad Request > > request: > x.x.x.x:8983/solr/xxxxxxx_index_shard1_replica2/update?update.distrib= > TOLEADER&distrib.from=https%3A%2F%2F40.113.227.147%3A8983%2Fsolr%2 > Fxxxxxxx_index_shard1_replica3%2F&wt=javabin&version=2 > Remote error message: Invalid Date in Date Math String:'20170901T183400Z' > Error from server at x.x.x.x:8983/solr/xxxxxxx_index_shard2_replica2: > Bad Request > > request: > x.x.x.x:8983/solr/xxxxxxx_index_shard2_replica2/update?update.distrib= > TOLEADER&distrib.from=https%3A%2F%2F40.113.227.147%3A8983%2Fsolr%2 > Fxxxxxxx_index_shard1_replica3%2F&wt=javabin&version=2 > Remote error message: Invalid Date in Date Math String:'20171026T181027Z' > Error from server at x.x.x.x:8983/solr/xxxxxxx_index_shard2_replica2: > Bad Request > > request: > x.x.x.x:8983/solr/xxxxxxx_index_shard2_replica2/update?update.distrib= > TOLEADER&distrib.from=https%3A%2F%2F40.113.227.147%3A8983%2Fsolr%2 > Fxxxxxxx_index_shard1_replica3%2F&wt=javabin&version=2 > Remote error message: Invalid Date in Date Math String:'20171028T070000Z' > Error from server at x.x.x.x:8983/solr/xxxxxxx_index_shard1_replica2: > Bad Request > > request: > x.x.x.x:8983/solr/xxxxxxx_index_shard1_replica2/update?update.distrib= > TOLEADER&distrib.from=https%3A%2F%2F40.113.227.147%3A8983%2Fsolr%2 > Fxxxxxxx_index_shard1_replica3%2F&wt=javabin&version=2 > Remote error message: Invalid Date in Date Math String:'20171004T070000Z' > Error from server at x.x.x.x:8983/solr/xxxxxxx_index_shard2_replica2: > Bad Request > > request: > x.x.x.x:8983/solr/xxxxxxx_index_shard2_replica2/update?update.distrib= > TOLEADER&distrib.from=https%3A%2F%2F40.113.227.147%3A8983%2Fsolr%2 > Fxxxxxxx_index_shard1_replica3%2F&wt=javabin&version=2 > Remote error message: Invalid Date in Date Math String:'20170314T000000Z' > Error from server at x.x.x.x:8983/solr/xxxxxxx_index_shard1_replica2: > Bad Request > > request: > x.x.x.x:8983/solr/xxxxxxx_index_shard1_replica2/update?update.distrib= > TOLEADER&distrib.from=https%3A%2F%2F40.113.227.147%3A8983%2Fsolr%2 > Fxxxxxxx_index_shard1_replica3%2F&wt=javabin&version=2 > Remote error message: Invalid Date in Date Math > String:'20170626T000000Z'</str><int name="code">400</int></lst> > </response> > > Source: SolrNet > at SolrNet.Impl.SolrConnection.PostStream(String relativeUrl, String > contentType, Stream content, IEnumerable`1 parameters) > at SolrNet.Impl.SolrConnection.Post(String relativeUrl, String s) > at SolrNet.Impl.SolrBasicServer`1.SendAndParseHeader(ISolrCommand cmd) > at > Sitecore.ContentSearch.SolrProvider.SolrBatchUpdateContext.AddRange(IEnumerable`1 > group, Int32 groupSize) at > Sitecore.ContentSearch.SolrProvider.SolrBatchUpdateContext.AddDocument(Object > itemToAdd, IExecutionContext[] executionContexts) > at > Sitecore.ContentSearch.SolrProvider.SolrIndexOperations.ApplyPermissionsThenIndex(IProviderUpdateContext > context, IIndexable version) > at Sitecore.ContentSearch.SitecoreItemCrawler.DoAdd(IProviderUpdateContext > context, SitecoreIndexableItem indexable) > at Sitecore.ContentSearch.HierarchicalDataCrawler`1.CrawlItem(T > indexable, IProviderUpdateContext context, CrawlState`1 state) > > Nested Exception > > Exception: System.Net.WebException > Message: The remote server returned an error: (400) Bad Request. > Source: System > at System.Net.HttpWebRequest.GetResponse() > at HttpWebAdapters.Adapters.HttpWebRequestAdapter.GetResponse() > at SolrNet.Impl.SolrConnection.GetResponse(IHttpWebRequest request) > at SolrNet.Impl.SolrConnection.PostStream(String relativeUrl, String > contentType, Stream content, IEnumerable`1 parameters) > > Thanks > Ritesh > This message and its attachments are for the designated recipient only and may contain proprietary or otherwise confidential information. If you have received this message in error, please notify the sender immediately and delete the original. Any other sharing, copying or use of this message by you is strictly prohibited.
