Search Engine: Elastic

Article ID: 132157, created on Jan 30, 2018, last review on Jan 31, 2018

  • Applies to:
  • Operations Automation 7.0

Symptoms

Office 365 synchronization fails:

{ "code": 500, "message": "Error: '_.Name.ToLowerInvariant()' cannot be converted to SQL.", "additionalNonlocalizableMessage": "" }

sitelog error:

DEBUG sync        : Save the actual license assignment for the users...
ERROR flow        : Unable to prepare data for customer e29f28b7-...-f19f6aae7ee3
LinqToDB.Linq.LinqException: '_.Name.ToLowerInvariant()' cannot be converted to SQL.
at LinqToDB.Linq.Builder.ExpressionBuilder.ConvertToSql(IBuildContext context, Expression expression, Boolean unwrap)
at LinqToDB.Linq.Builder.ExpressionBuilder.ConvertExpressions(IBuildContext context, Expression expression, ConvertFlags queryConvertFlag)

Cause

Software-related issue #APSA-19496: "Office 365 synchronization fails: LinqToDB.Linq.LinqException: '_.Name.ToLowerInvariant()' cannot be converted to SQL".

Resolution

The issue is permanently fixed in the Office 365 17.3.1 APS package. It is recommended to update your Office 365 APS application to the latest version.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF