locked
TestDB upgrade Error on CM_XXX.dbo.RBAC_CategoryMemberships Table RRS feed

  • Question

  • Hi Team,

    I am running TestDB upgrade for my site server . Want to go to SCCM 2016. Getting the below Error:-

    ==================

    

    *** 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 Setup	11/11/2016 2:44:30 PM	5080 (0x13D8)
    *** [23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'ObjectKey', table 'CM_EUR.dbo.RBAC_CategoryMemberships'; column does not allow nulls. INSERT fails.	Configuration Manager Setup	11/11/2016 2:44:30 PM	5080 (0x13D8)
    ERROR: SQL Server error: [23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'ObjectKey', table 'CM_EUR.dbo.RBAC_CategoryMemberships'; column does not allow nulls. INSERT fails.	Configuration Manager Setup	11/11/2016 2:44:30 PM	5080 (0x13D8)
    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 Setup	11/11/2016 2:44:30 PM	5080 (0x13D8)
    ERROR: Failed to execute SQL Server command, SQL Server error <>	Configuration Manager Setup	11/11/2016 2:44:30 PM	5080 (0x13D8)
    ERROR: Failed to assign default objects to default security scope(FinalSqlOperations).	Configuration Manager Setup	11/11/2016 2:44:30 PM	5080 (0x13D8)
    <11-11-2016 14:44:40> Failed to create process of SetupWpf.exe. return value 1	 	1/1/1601 12:00:00 AM	2005225467 (0x77854FFB)
    

    It is failing here.

    Please assist!!

    Friday, November 11, 2016 9:26 AM

All replies

  • First, there is no such thing as SCCM 2016. The latest version of ConfigMgr is Current Branch, version 1606.

    Next, are you running the above on a copy of the database that was restored on an alternate SQL instance?

    And, does the account you are running it with have sysadm permissions in this SQL instance?


    Jason | http://blog.configmgrftw.com | @jasonsandys

    Friday, November 11, 2016 4:34 PM
  • Yes the database restored on alternate SQL and also permissions are ok as I was able to test with 3 other primary sites database only 1 site is giving me this error
    Monday, November 14, 2016 8:06 AM
  • Then you'll need to open a support case as this is some data related or DB related integrity issue that can only be handled by Microsoft support.

    Jason | http://blog.configmgrftw.com | @jasonsandys

    Monday, November 14, 2016 6:53 PM