SCOM 2022 error: Partitioning and grooming has not completed recently

Question

I am encountering an issue with SCOM 2022 where I receive the error message "Partitioning and grooming has not completed recently". I have tried searching for solutions online but have not found anything that solves my problem. Can someone provide some guidance on how to resolve this issue? Thank you.

Answer 1

Hi,

I’m sorry to hear you’re having trouble with SCOM 2022. The “Partitioning and grooming has not completed recently” error can be frustrating.

Here are some steps you can take to resolve this issue:

1. Verify SQL Server Access:
   • Confirm that the SQL Server hosting the operational database is accessible and that there are no connectivity issues.
   • Ensure that the account running the grooming process has sufficient permissions.
2. Check SQL Transaction Log Space:
   • The grooming process requires space in the SQL transaction log. Make sure there is enough space available.
3. Manually Trigger Grooming:
   • You can manually trigger the grooming process by executing the stored procedure p_PartitioningAndGrooming in SQL Server Management Studio.
   • After running the procedure, check the job status by executing SELECT * FROM InternalJobHistory ORDER BY InternalJobHistoryId to ensure it completed successfully.
4. Adjust Grooming Settings:
   • You can configure the grooming settings in the Operations Manager console. Go to Administration > Settings > Database Grooming and adjust the settings as needed.

If these steps don’t resolve the issue, you might want to check the event logs for any additional errors or warnings that could provide more insight into the problem.

Feel free to ask if you need further assistance!