Symptoms
The co-management dashboard may fail to load correctly in the Configuraton Manager console, instead showing a combination of empty tiles and text resembling the following:
{{getString(‘EligibleDevices’)}} {{getString(‘Scheduled’)}} {{getString(‘Enrolling’)}} {{getString(‘Enrolled’)}}
The smsprov.log file will also contain an entry resembling the following. Note this entry is truncated for readability.
*** EXEC spDashboardsGetChartData @chartGuid=N'{guid}', @chartConfigData=N'<ChartConfigData><WorkloadFlag>16</WorkloadFlag></ChartConfigData>', @userSids=N'{SID}' *** [22003][248][Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of the nvarchar value '4294967295' overflowed an int column. : spGetMDMWorkloadEnabledCount ~*~*~[22003][248][Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of the nvarchar value '4294967295' overflowed an int column. : spGetMDMWorkloadEnabledCount ThreadID : 14112 , DbError: 248 , Sev: 16~*~*~
This issue occurs in environments using 3rd party mobile device management (MDM) coexistence with Configuration Manager current branch, version 1902 and KB 4500571installed.
Update information for System Center Configuration Manager, version 1902
Microsoft Download Center
The following hotfix to resolve this problem is available for download from the Microsoft Download Center:
After you download this hotfix, see the following Microsoft Learn webpage for installation instructions:
Use the Update Registration Tool to import hotfixes to System Center Configuration Manager
For information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to obtain Microsoft support files from online services
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
You must have System Center Configuration Manager, version 1902 and the following update installed to apply this update.4500571 Update rollup for System Center Configuration Manager current branch, version 1902
Restart information
You do not have to restart the computer after you apply this update.
Update replacement information
This update does not replace any previously released update.
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.
For System Center Configuration Manager current branch, version 1902
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
Update.sql |
Not applicable |
152850 |
28-Apr-2019 |
01:05 |
Not applicable |
References
Third-party MDM coexistence with Configuration Manager
Install in-console updates for Configuration Manager
Learn about the terminology Microsoft uses to describe software updates.
