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 >