Thursday, 31 August 2017

Solr queries errors related to Sitecore Social

Last time I saw that there is a a number of Solr error logs on my Sitecore instances:



ManagedPoolThread #2 2017:08:06 16:45:50 ERROR Solr Error : ["undefined field 0001-01-01T00"] - Query attempted: [((posted_date_tdt:(0001-01-01T00:00:00Z) AND (final_workflow_state_b:(True) OR workflow_state_s:(00000000000000000000000000000000))) AND (_template:(d7851f00e8694f9381f5b5338eff58a9) OR _template:(06751e29d91b423ca2e1e54afd4f8f0b) OR _template:(e28734ca89eb4530b0e4b81f6645a372)))]


Quick look at the query and it seems like dates are no escaped before putting them inside. This issue is connected with Sitecore Social, as the template ids are coming from that place. I have raised a bug in Sitecore Support and here it goes, patch that solves this issue:

https://sitecore.box.com/s/ux7m0wkkgobxndf0ihqjgawhnlhcacp1

It's reference number in Sitecore bug tracking system is 173890. After applying, no more unnecessary error log entries!

Share it:

Radosław Kozłowski - Senior Sitecore Developer Radoslaw Kozlowski

Author & Editor

Sitecore MVP, passionate Sitecore & .NET developer and architect. Sitecore Community evangelist.

0 comments:

Post a Comment