"YourLinqIsTooStrongException" error can be thrown in Experience Profile when trying to filter contacts by channel

  • The exception below can appear in log file when trying to filter contact in Experience Profile application with the selected Channel checkbox and leaving the From Date and To Date fields empty.

    ERROR [Sitecore Services]: HTTP POST
    URL http://sc920.sc/sitecore/api/ao/v1/contacts/search?pageSize=20&pageNumber=1&sort=visitCount desc&Match=*&FromDate=null&ToDate=null
    
    Exception System.AggregateException: One or more errors occurred. ---> Sitecore.XConnect.Search.YourLinqIsTooStrongException: Unsupported query: (VisitMethodCall): PartialEvalException (InvalidOperationException ("Nullable object must have a value."), Convert(null)).ToUniversalTime()
  • To resolve the issue, apply the following steps:

    1. Open \sitecore\shell\client\Applications\ExperienceProfile\Search\Search.js file.
    2. Uncomment the following line:
      var searchText = decodeURIComponent(cintelUtil.getQueryParam(textProperty));
      self.SearchTextBox.set(textProperty, searchText);
      self.setDefaultDate();
      self.toggleFiltersVisibility();
      self.findContacts();

Applies to:

CMS 9.1 Initial Release+

March 16, 2020
March 16, 2020

Reference number:

379906