Update Error SCCM to 1906

[AlekseyM]

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

[anyweb]

hi is this primary under a CAS ? can you attach the cmupdate.log please...

[AlekseyM]

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

CMUpdate.log

[AlekseyM]

On 13.09.2019 at 17:56, anyweb said:

привет это основной под CAS? Можете ли вы прикрепить cmupdate.log, пожалуйста ...

Hi! File attached.

CMUpdate.log

[anyweb]

i see these messages

SQL MESSAGE:  - Found UpgradeViewMapping exists, previous upgrade may have failed. Try to revert some of the objects related to DVIEW  $$<CONFIGURATION_MANAGER_UPDATE><09-13-2019 12:12:33.914-180><thread=4296 (0x10C8)>

followed by...

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><09-13-2019 12:24:26.852-180><thread=4296 (0x10C8)>
ERROR: Failed to execute SQL Server command, SQL Server error <>~  $$<CONFIGURATION_MANAGER_UPDATE><09-13-2019 12:24:26.852-180><thread=4296 (0x10C8)>
*** [HY007][0][Microsoft]

Associated statement is not prepared  $$<CONFIGURATION_MANAGER_UPDATE><09-13-2019 12:24:26.853-180><thread=4296 (0x10C8)>

	ERROR: Failed to assign default objects to default security scope(FinalSqlOperations).  $$<CONFIGURATION_MANAGER_UPDATE><09-13-2019 12:24:26.853-180><thread=4296 (0x10C8)>

	Failed to update database.  $$<CONFIGURATION_MANAGER_UPDATE><09-13-2019 12:24:26.854-180><thread=4296 (0x10C8)>



	 



	is there any third party antivirus software installed on this server ? are you doing the upgrade as the same user as on the other primary ?



	 

[AlekseyM]

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

[AlekseyM]

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

[anyweb]

uninstall Symantec, reboot, then try the upgrade again

[AlekseyM]

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

[anyweb]

I've seen upgrades fail when SEP is installed, disabling it was not enough we had to uninstall it, reboot and try again

 

is there anything different about this site versus the other ?