Search Engine: Elastic

Article ID: 131438, created on Sep 8, 2017, last review on Sep 21, 2017

  • Applies to:
  • Operations Automation


Office 365 synchronization fails with:

 ERROR: insert or update on table "Users" violates foreign key constraint "Users_CountryID" DETAIL: Key (CountryID)=(un) is not present in table "Country".


The cause is a software-related issue #APSA-18910.


Please contact your Technical Account Manager or Pooled Team Associate( to schedule Office 365 upgrade to version 17.1.2

In order to workaround the issue, please do the following steps:

  1. Go to the Microsoft Online Portal > Admin Center > Users
  2. Choose the affected user
  3. Next to Display name and Office phone click Edit
  4. Scroll to the end of the page and set up an empty country code
  5. Re-run the synchronization.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF