NEW SCCM Group Discovery Errors

[JamesBowtell]

Hi,

We recently had issues where content wouldn't due to lack of storage on the SCCM SQL server. We expanded the storage and content flowed again.

Now we are experiencing issues with System Group discoveries. Where collections assigned to Active Directory groups will not populate. I ran a group discovery and went over to adsgdis.log and was confronted by lots of red errors.

Can anyone advise what I can do to fix?

SCCM 2006
SCCM SQL on separate server
MS Server 2016

*** [42000][3971][Microsoft][SQL Server Native Client 11.0][SQL Server]The server failed to resume the transaction. Desc:1730000346e. SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT 22/01/2021 16:39:11 9912 (0x26B8)
*** [01000][3926][Microsoft][SQL Server Native Client 11.0][SQL Server]The transaction active in this session has been committed or aborted by another session. SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT 22/01/2021 16:39:11 9912 (0x26B8)
INFO: Processing discovered group object with ADsPath = 'LDAP://DC.local/CN=PCC_WM Labeltrace and Printer,OU=Groups,OU=WM - Health Centre,OU=W95033 - Bargoed Hall Family Health Centre,OU=EMIS,OU=GP Practices,OU=Primary Care (PCC),OU=Organisations,DC=TEST,DC=ORG,DC=UK' SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT 22/01/2021 16:39:11 9912 (0x26B8)
INFO: DDR was written for group 'TEST\PCC_WM Labeltrace and Printer' - D:\SCCM\inboxes\auth\ddm.box\userddrsonly\asg1lf6k.DDR at 1/22/2021 11:40:1. SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT 22/01/2021 16:39:11 9912 (0x26B8)
*** [42000][3971][Microsoft][SQL Server Native Client 11.0][SQL Server]The server failed to resume the transaction. Desc:1730000346e. SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT 22/01/2021 16:39:11 9912 (0x26B8)
ERROR: CADSource::UpdateMembershipTablesForSecurityGroupEx - Failed to insert group name. SQL: IF NOT EXISTS(select TOP 1 ObjectGUID from ActiveDirectoryObjectInfo where ObjectGUID = 0xDC74C58F096651499D9CADF88A9E296D AND SiteCode = N'ABC') ~ INSERT INTO ActiveDirectoryObjectInfo (ObjectGUID, SiteCode, Name, CName, LastRefreshTime) VALUES (0xDC74C58F096651499D9CADF88A9E296D, N'ABC', N'TEST\PCC_WM Labeltrace and Printer', N'TEST\PCC_WM Labeltrace and Printer', N'01/22/2021 11:40:01') ~ELSE ~ UPDATE ActiveDirectoryObjectInfo SET Name = N'TEST\PCC_WM Labeltrace and Printer', CName = N'TEST\PCC_WM Labeltrace and Printer', LastRefreshTime = N'01/22/2021 11:40:01' WHERE ObjectGUID = 0xDC74C58F096651499D9CADF88A9E296D AND SiteCode = N'ABC' SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT 22/01/2021 16:39:11 9912 (0x26B8)
*** [42000][3971][Microsoft][SQL Server Native Client 11.0][SQL Server]The server failed to resume the transaction. Desc:1730000346e. SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT 22/01/2021 16:39:11 9912 (0x26B8)
*** [01000][3926][Microsoft][SQL Server Native Client 11.0][SQL Server]The transaction active in this session has been committed or aborted by another session. SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT 22/01/2021 16:39:11 9912 (0x26B8)
*** Error rolling back transaction, tries left: 4 SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT 22/01/2021 16:39:11 9912 (0x26B8)

 

[JamesBowtell]

Issue was related to VM snapshots taking all space. Removed snapshot space was freed, sccm was happy again.

Asked Storage team to reconfigure storage to avoid this happening again