Troubleshooting Tip: How to resolve domain sync failed after upgrading EMS to v7.2.8 with the error 'fk_Forticlient_Users_Users_machine_user_id'

[jie]

Description	This article explains how to resolve the domain sync failed after upgrading EMS to v7.2.8 with the error 'fk_Forticlient_Users_Users_machine_user_id'.
Scope	EMS v7.2.
Solution	After EMS is successfully upgraded to v7.2.8, when doing domain sync failed and see the below error in EMS log: "failed to update database sync object tables: error loop forticlient users from spUpdateDomainUsers output: mssql: The DELETE statement conflicted with the REFERENCE constraint "fk_Forticlient_Users_Users_machine_user_id". The conflict occurred in database! Use the attached hotfix and follow the below steps to fix this issue. Extract the contents of the zip file. Open powershell as admin, navigate to the 'hotfix_1116781_728_2' folder. Run 'Set-ExecutionPolicy Bypass -Scope'. Run 'powershell.exe -noprofile -executionpolicy bypass -file .\hotfix_1116781.ps1'. Once the hotfix is applied successfully then go to EMS -> Administration -> Authentication Servers -> Ad -> Edit -> Test -> Save and EMS -> Endpoints -> Manage Domains -> Select the Domain -> Sync and the issue should be resolved.