Search Engine: Elastic

Article ID: 131543, created on Oct 2, 2017, last review on Jul 14, 2018

  • Applies to:
  • Operations Automation 7.0
  • Operations Automation 7.1
  • Operations Automation 7.2
  • Operations Automation 6.0


Office365 synchronization fails for a user:

Failed to add 1 user(s):
- (String or binary data would be truncated. The statement has been terminated.)


Some user property value length exceeds corresponding column size in the Endpoint database.

For example, Job title of a user is 76 chars-sized on the Microsoft side while Title column size is limited by 64 chars.

This behavior is reported to Odin Development team as request #APSA-18988: "Office365: "String or binary data would be truncated." error on attempt to sync a user with "Job title" field length > 64 symbols".


Upgrade Office 365 application to version 17.2 or higher. Full list of avaliable Office 365 version can be found here.

0871c0b47b3b86ae3b1af4c2942cd0ce caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 1941880841f714e458ae4dc3d9f3062d 8c199f0ee4305da1a577740620df4a51 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0 31987597efff5a3a9ce779cc203bbe5e

Email subscription for changes to this article
Save as PDF