Microsoft Configuration Manager
An integrated solution for for managing large groups of personal computers and servers.
4,087 questions
Cloud Management Summary Task failing - SQL error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 89%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Cat
1
Reputation point
Hi all,
I have recently installed the CMG Connection Point role in our environment after having set up the CMG etc according to the docs. I'm using Azure hybrid join for client auth and have a standalone primary site.
The role install reports to be successful and my initial test client seems fine.
However, I'm seeing an error in the statesys log referring to the Cloud Management Summary Task failing:
Started task 'Cloud Management Summary Task' SMS_STATE_SYSTEM 01/12/2021 12:22:14 7040 (0x1B80)
total chunks loaded (1) SMS_STATE_SYSTEM 01/12/2021 12:22:14 5300 (0x14B4)
State message processing processed invalid records or files in the last processing cycle. SMS_STATE_SYSTEM 01/12/2021 12:22:14 7040 (0x1B80)
STATMSG: ID=6105 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_STATE_SYSTEM" SYS=SITESERVER SITE=SITE PID=2944 TID=7040 GMTDATE=Wed Dec 01 12:22:14.897 2021 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 LE=0X0 SMS_STATE_SYSTEM 01/12/2021 12:22:14 7040 (0x1B80)
total chunks loaded (0) SMS_STATE_SYSTEM 01/12/2021 12:22:15 5300 (0x14B4)
Thread "State Message Processing Thread #0" id:5300 terminated normally SMS_STATE_SYSTEM 01/12/2021 12:22:15 5300 (0x14B4)
CThreadMgr::ThreadTerminating - All threads have stopped running SMS_STATE_SYSTEM 01/12/2021 12:22:15 5300 (0x14B4)
Found new state messages to process, starting processing thread SMS_STATE_SYSTEM 01/12/2021 12:22:29 7040 (0x1B80)
exec spTaskCloudManagementSummary NULL, 0x0000000000000000 SMS_STATE_SYSTEM 01/12/2021 12:22:29 7040 (0x1B80)
[23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The INSERT statement conflicted with the CHECK constraint "Proxy_SiteStatistics_ID_Partition_CK". The conflict occurred in database "CM_SITE*", table "dbo.Proxy_SiteStatistics", column 'ID'. : spTaskCloudManagementSummary SMS_STATE_SYSTEM 01/12/2021 12:22:29 7040 (0x1B80)
*
exec spTaskCloudManagementSummary NULL, 0x0000000000000000 SMS_STATE_SYSTEM 01/12/2021 12:22:29 7040 (0x1B80)
** [HY007][0][Microsoft][SQL Server Native Client 11.0]Associated statement is not prepared SMS_STATE_SYSTEM 01/12/2021 12:22:29 7040 (0x1B80)
Task 'Cloud Management Summary Task' failed after running for 15 seconds. SMS_STATE_SYSTEM 01/12/2021 12:22:29 7040 (0x1B80)
The State System component flags the same error:
Microsoft SQL Server reported SQL message 547, severity 16: [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The INSERT statement conflicted with the CHECK constraint "Proxy_SiteStatistics_ID_Partition_CK". The conflict occurred in database "CM_SITE", table "dbo.Proxy_SiteStatistics", column 'ID'.
I've already tried uninstalling and reinstalling the role to no avail.
Has anyone come across this or have any ideas as to the cause?
Thanks