Symptoms
The Recommended pilot devices tile of the Office 365 Pilot and Health dashboard may not show any devices, even if there are eligible devices in the environment.
If this occcurs, the SMS_STATE_SYSTEM component will also show a status value of Critical in the Component Status monitoring node under System Status. An error resembling the following is shown in the Configuration Manager console.
Error Code 620
Microsoft SQL Server returned SQL message 547, severity level 16: 23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The MERGE statement conflicts with the FOREIGN KEY restriction "OfficeReadiness_MachineIdGroupXRef_FK". The conflict occurred in the CM_{SiteCode} database, table "dbo.MachineIdGroupXRef".
The statesys.log on the site server also contains errors resembling the following.
Started task 'Office Readiness Calculation Task'
*** exec spOfficeReadinessCalculationTask NULL, ...
*** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The MERGE statement conflicted with the FOREIGN KEY constraint "OfficeReadiness_MachineIdGroupXRef_FK". The conflict occurred in database "CM_{SiteCode}", table "dbo.MachineIdGroupXRef", column 'MachineID'. : spOfficeReadinessCalculation
*** exec spOfficeReadinessCalculationTask NULL, ...
*** [01003][8153][Microsoft][SQL Server Native Client 11.0][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation. : spOfficeReadinessCalculation
*** exec spOfficeReadinessCalculationTask NULL, ...
*** [HY007][0][Microsoft][SQL Server Native Client 11.0]Associated statement is not prepared
Task 'Office Readiness Calculation Task' failed after running for 60 seconds.
Update information for Microsoft Endpoint Configuration Manager current branch, version 1910
This update is applicable to early update or globally available installations of Configuration Manager current branch, version 1910.
How to obtain the hotfix
Microsoft Download Center
The following hotfix to resolve this problem is available for download from the Microsoft Download Center:
After you download the hotfix, see the following documentation for installation instructions:
Use the Update Registration Tool to import hotfixes to Configuration Manager
Microsoft scanned this file for viruses, using the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to it.
Prerequisites
To apply this hotfix, you must have Microsoft Endpoint Configuration Manager, version 1910 installed by using one of the package GUIDs that are mentioned in the "Update information" section.
Restart information
You don't have to restart the computer after you apply this hotfix.
Hotfix replacement information
This hotfix does not replace any previously released hotfix.
File information
The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
File name |
File version |
File size |
Date |
Time |
Platform |
---|---|---|---|---|---|
cm1910-kb4550373.update.sql |
Not Applicable |
4538 |
17-Jan-2020 |
02:50 |
Not Applicable |
References
Updates and servicing for Configuration Manager
Learn about the terminology Microsoft uses to describe software updates.