AlekseyM

On which the error is only Primary. The second Primary has 3 secondary and one DP.

The error is the same. On other primary site SEP is also installed, but it was updated without problems.

I disabled the antivirus and tried to reinstall, but failed with the same error

We have Symantec Endpoint Protection. Upgrade was performed the same account.

Hi! File attached. CMUpdate.log

Hello! Yes, CAS and two Primary. One of Primary was updated without problems, the second with an error. CMUpdate.log

Hello! Can help me? I have the following situation. There was a problem updating on one of the primary SCCM sites. Error: 0x87d20b15. The problem begins here: *** declare @t table (ObjectKey nvarchar(512) , ObjectTypeID int) insert into @t (ObjectKey, ObjectTypeID) select distinct ID, TypeID from vRBAC_AllItemsID where TypeID IN (select ObjectTypeID from RBAC_ObjectOperations where OperationName=N'Set Security Scope'); insert into RBAC_CategoryMemberships (CategoryID, ObjectKey, ObjectTypeID) select N'SMS00UNA', ra.ObjectKey, ra.ObjectTypeID from @t ra left join (select distinct ObjectKey, ObjectTypeID from RBAC_CategoryMemberships ) rcm on ra.ObjectKey=rcm.ObjectKey and ra.ObjectTypeID=rcm.ObjectTypeID where rcm.ObjectKey IS NULL; CONFIGURATION_MANAGER_UPDATE 13.09.2019 10:35:50 13204 (0x3394) *** [23000][515][Microsoft] [SQL Server]Cannot insert the value NULL into column 'ObjectKey', table 'XXX.dbo.RBAC_CategoryMemberships'; column does not allow nulls. INSERT fails. CONFIGURATION_MANAGER_UPDATE 13.09.2019 10:35:50 13204 (0x3394) INFO: Executing SQL Server command: <declare @t table (ObjectKey nvarchar(512) , ObjectTypeID int) insert into @t (ObjectKey, ObjectTypeID) select distinct ID, TypeID from vRBAC_AllItemsID where TypeID IN (select ObjectTypeID from RBAC_ObjectOperations where OperationName=N'Set Security Scope'); insert into RBAC_CategoryMemberships (CategoryID, ObjectKey, ObjectTypeID) select N'SMS00UNA', ra.ObjectKey, ra.ObjectTypeID from @t ra left join (select distinct ObjectKey, ObjectTypeID from RBAC_CategoryMemberships ) rcm on ra.ObjectKey=rcm.ObjectKey and ra.ObjectTypeID=rcm.ObjectTypeID where rcm.ObjectKey IS NULL; > CONFIGURATION_MANAGER_UPDATE 13.09.2019 10:35:50 13204 (0x3394) ERROR: Failed to execute SQL Server command, SQL Server error <> CONFIGURATION_MANAGER_UPDATE 13.09.2019 10:35:50 13204 (0x3394) *** [HY007][0][Microsoft][SQL Server Native Client 11.0]Associated statement is not prepared CONFIGURATION_MANAGER_UPDATE 13.09.2019 10:35:50 13204 (0x3394) ERROR: Failed to assign default objects to default security scope(FinalSqlOperations). CONFIGURATION_MANAGER_UPDATE 13.09.2019 10:35:50 13204 (0x3394) Failed to update database. CONFIGURATION_MANAGER_UPDATE 13.09.2019 10:35:50 13204 (0x3394) hope for your help

Hi All! I'm asking for Your help. The following SCCM infrastructure is available: CAS and two Primary sites. When upgrading from version 1802 to 1902, there were problems on one of the Primary site. The ConfMgr database cannot be upgraded. Primary site configurations are identical. CmUpdate file attached. Forgot to say that the Primary website on which the problem has three Secondary site. Replication between them takes place in the normal mode. I hope for Your help. CMUpdate.log