
AlekseyM
Established Members-
Posts
8 -
Joined
-
Last visited
Everything posted by AlekseyM
-
Update Error SCCM to 1906
AlekseyM replied to AlekseyM's topic in System Center Configuration Manager (Current Branch)
On which the error is only Primary. The second Primary has 3 secondary and one DP. -
Update Error SCCM to 1906
AlekseyM replied to AlekseyM's topic in System Center Configuration Manager (Current Branch)
The error is the same. On other primary site SEP is also installed, but it was updated without problems. -
Update Error SCCM to 1906
AlekseyM replied to AlekseyM's topic in System Center Configuration Manager (Current Branch)
I disabled the antivirus and tried to reinstall, but failed with the same error -
Update Error SCCM to 1906
AlekseyM replied to AlekseyM's topic in System Center Configuration Manager (Current Branch)
We have Symantec Endpoint Protection. Upgrade was performed the same account. -
Update Error SCCM to 1906
AlekseyM replied to AlekseyM's topic in System Center Configuration Manager (Current Branch)
Hi! File attached. CMUpdate.log -
Update Error SCCM to 1906
AlekseyM replied to AlekseyM's topic in System Center Configuration Manager (Current Branch)
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