Symptoms

Office365 synchronization fails for a user:

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

Cause

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".

Resolution

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

Internal content