Jump to content


Recommended Posts

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

Share this post


Link to post
Share on other sites


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

Share this post


Link to post
Share on other sites
On 13.09.2019 at 17:56, anyweb said:

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

Hi! File attached.

CMUpdate.log

Share this post


Link to post
Share on other sites

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 ?

 

Share this post


Link to post
Share on other sites

uninstall Symantec, reboot, then try the upgrade again

Share this post


Link to post
Share on other sites

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 ?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...