This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(172.8, 34%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Hi All,
We installed SCOM 2022 UR1 and all were running as expected, until all of sudden, the daily and hourly performance & state aggregations are not happening. Events 31552 & 31553 keeps getting logged on all Management servers' event viewer. No errors related to performance or permission are noticed on Management Servers or SQL Server
The weird thing is that when we disable the rule "Standard Data Warehouse Data Set Maintenance Rule" and run the Stored Procedure (Exec StandardDataSetMaintenance) , the aggregation gets processed successfully and we can get the performance data back in reports/dashboards. But when we enable the rule back (which should be enabled by default), aggregation does not work.
Any ideas please on what to check?
Thanks,
![](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(22.400000000000002, 54%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN2%3C/text%3E%3C/svg%3E)
mark to follow
![](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(115.19999999999999, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
Hi Alaa
I am experiencing the exact same issue and also started out of nowhere on a random Saturday evening. Have you managed to resolve this?
There is basically no info on the web related to this issue. It would be great if Microsoft can provide their input on this matter as well.
I'm running SCOM 2022 ur2 with SQL 2022 CU13.
All standard dataset maintenance tasks fail. looking at the standard dataset table under DW, I found that the last optimized attempt is up to date, but the last successful optimization is completely stuck.
This make me think that maintenance is started but does not successfully complete.
My workaround for now is to stop the dataset maintenance rule on SCOM, manually running the standard dataset maintenance per DatasetID (this succeeds and update the last successful optimization field) then running manual aggregation and once updated re-enable the maintenance rule again.
@Microsoft: Any ideas?
Thanks
![](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(278.4, 36%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Same isssue we run into also.
SCOM 2022 UR2 + MSSQL2022 CU13
All the sympthoms are the same.
About Kurt Bowden's advice
Will check and then notice here about.
Add all info I collected about our SCOM evironment
No events 31552 and31553 at all.
Accordingly to the Kurt's letter -
But the problem persists.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more