mountainss Cloud and Datacenter Management Blog

Microsoft SystemCenter blogsite about virtualization on-premises and Cloud

#Microsoft System Center 2012 R2 Rollup Update 2 and #SCVMM #sysctr

Leave a comment


SC2012R2 RollUpdate2

Here you can download the System Center 2012 R2 Roll-Updates

Today I started with System Center 2012 R2 Virtual Machine Manager :

Virtual Machine Manager (KB2932926)

There are 30 Virtual Machine Manager issues fixed in Update Rollup 2 for System Center 2012 R2. There are three download packages. The first package is for Virtual Machine Manager Consoles, the second is for Virtual Machine Manager Servers, and the third package is for Virtual Machine Manager Guest Agents. See the following Microsoft Knowledge Base article for details about these fixes and installation instructions:

2932926

System Center 2012 Virtual Machine Manager R2 Update Rollup 2

Update Rollup 2 for System Center 2012 R2 Virtual Machine Manager resolves the following issues:

  • Files cannot be found on a network-attached storage device that uses NetApp storage and Server Message Block version 3 (SMBv3) protocol.
  • After an account’s password is changed, the Scale-Out File Server provider goes into a “not responding” state.
  • VMM wipes the System Access Control List (SACL) configurations on ports.
  • When an uplink profile’s name contains the “or” string, VMM console cannot show its details when it adds the uplink profile to a logical switch.
  • Dynamic disks cannot be used as pass-through disks.
  • When you create a standard virtual switch on a host without selecting the Allow management operating system to share this network adapter check box, the virtual switch is created. However, the virtual switch still binds to the host unexpectedly.
  • Network address translation (NAT) uses port number 49152 or a larger number, which Windows prohibits from being used by NAT.
  • When a virtual machine IP address type is static Out-of-Band and there is no IP address pool that is associated with the virtual machine network or the logical network, migration is complete with multiple errors.
  • If a highly available virtual machine is migrated from one node to another node by using Failover Cluster Manager, you receive an error message that indicates the absence of VHD files.
  • Some performance issues in VMM.
  • Connection with Operations Manager fails in a non-English environment.
  • After you upgrade VMM from System Center 2012 Service Pack 1 (SP1) to System Center 2012 R2, VLAN settings disappear and cannot be saved in the virtual machine.
  • Virtualization gateway could not be discovered by management packs.
  • The New-SCPhysicalComputerProfile Windows PowerShell cmdlet fails with a NullReferenceException exception.
  • Assume that you put a host into maintenance mode. When any highly available virtual machines cannot evacuate successfully, they are put into a saved state instead of into task failures.
  • Assume that you have a computer that is running VMware ESX Server to host virtual machines. Additionally, assume that cumulative progress for many applications, scripts or actions (that is reported by guest agent) becomes large. In this situation, all deployments time out, as the guest agent cannot communicate to the server successfully.
  • You cannot deploy a service template to VMware ESX 5.1 hosts. Additionally, you receive an error 22042 and a TimeoutWhileWaitingForVmToBootException (609) exception.
  • When you migrate a virtual machine together with Out-of-Band checkpoints, database corruption occurs.
  • Pass-through disks are not updated correctly in the database after they are refreshed from an Out-of-Band migration.
  • Assume that hosts establish a Common Information Model (CIM) session that can send policies to the host after the Hyper-V Network Virtualization initialization. Additionally, assume that a policy-sending activity is initiated before the CIM session creation is completed. In this situation, policies are stuck in the sending queue, and the host does not receive any Hyper-V Network Virtualization policies.
  • Communication is broken in Hyper-V Network Virtualization.
  • When you use a same user name for Run As Accounts in guest customization, a conflict occurs.
  • You cannot use a parameter together with .sql scripts for a Run As Account during a service installation.
  • You deploy a template that uses empty classification to a cloud. However, the template does not respect storage classifications that are set on the cloud.
  • When Windows Server fast file copy cannot deploy files successfully, the Background Intelligent Transfer Service (BITS) fallback task continues using the fast file copy credentials.

After you installed System Center 2012 R2 Virtual Machine Manager Roll Update 2 :

SCVMM 2012 R2 Rollup2

You have to run a SQL Script on the Virtual Machine Database :

Rollupdate 2 SCVMM 2012 R2 Script execute

Here you see that the script is successfully

You can download the SQL Script for SCVMM Roll Update 2 here

“The following SQL script on your Virtual Machine Manager Microsoft SQL Server database for Update Rollup 2 to function correctly”

/* script starts here */
ALTER Procedure [dbo].[prc_RBS_UserRoleSharedObjectRelation_Insert]
(
        @ID uniqueidentifier,
        @ObjectID uniqueidentifier,
        @ObjectType int,
        @RoleID uniqueidentifier,
        @UserOrGroup varbinary (85),
        @ForeignAccount nvarchar (256),
        @IsADGroup bit,
        @ExistingID uniqueidentifier = NULL OUTPUT
)
AS
SET NOCOUNT ON
     SELECT @ExistingID = [ID] FROM [dbo].[tbl_RBS_UserRoleSharedObjectRelation]
     WHERE [ObjectID] = @ObjectID AND [RoleID] = @RoleID 
  AND
  -- Select owner OR Select all which matches ForeignAccount or UserOrGroup OR
  -- both ForeignAccount and UserOrGroup is NULL  
  (([UserOrGroup] = @UserOrGroup OR [ForeignAccount] = @ForeignAccount) OR
  ([UserOrGroup] IS NULL AND @UserOrGroup IS NULL AND [ForeignAccount] IS NULL AND @ForeignAccount IS NULL))
      /* Ignore duplicate entries */
      IF (@ExistingID IS NULL)
      BEGIN
     INSERT [dbo].[tbl_RBS_UserRoleSharedObjectRelation]
               ([ID]
               ,[ObjectID]
               ,[ObjectType]
               ,[RoleID]
               ,[UserOrGroup]
               ,[ForeignAccount]
               ,[IsADGroup]
               ,[IsOwner]
               )
    VALUES
    (
            @ID,
            @ObjectID,
            @ObjectType,
            @RoleID,                        
            @UserOrGroup,
            @ForeignAccount,
            @IsADGroup,
            0
    )
      END
SET NOCOUNT OFF
RETURN @@ERROR
GO
 
 
ALTER PROCEDURE [dbo].[prc_WLC_IsVHDSharedByAnotherVmOnHost]
    @HostId [uniqueidentifier],
        @VHDId [uniqueidentifier],
    @VMId [uniqueidentifier]
AS
BEGIN
    DECLARE @error int
    SET @error = 0
 
    SET NOCOUNT ON;
        
    SELECT TOP 1 1 FROM dbo.[fn_WLC_GetParentChildRelationForVHD](@VHDId) vcr
        JOIN dbo.tbl_WLC_VDrive vd ON
                vcr.VHDId = vd.VHDId
        JOIN dbo.tbl_WLC_VObject vo ON
                vo.ObjectId = vd.ParentId
        JOIN dbo.tbl_WLC_VMInstance vi ON
                vo.ObjectId = vi.VMInstanceId   
        WHERE           
                vo.HostId = @HostId
        AND 
                vo.ObjectId <> @VMId            
        AND
                vi.RootVMInstanceId <> @VMId            
 
    SET @error = @@ERROR
    SET NOCOUNT OFF
    RETURN @error
END
GO
 
 
IF EXISTS (SELECT * FROM dbo.sysobjects
           WHERE id = OBJECT_ID(N'prc_ADHC_HostDisk_GetByClusterDiskIdAndHostId')
           AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE dbo.prc_ADHC_HostDisk_GetByClusterDiskIdAndHostId
GO
 
CREATE PROCEDURE dbo.prc_ADHC_HostDisk_GetByClusterDiskIdAndHostId
(
  @ClusterDiskID guid,
  @HostID guid
)
AS
 
DECLARE @error int
SET @error = 0
 
SET NOCOUNT ON
 
SELECT
 [DiskID],
 [Signature],
 [UniqueID],
 [HostID],
 [LibraryServerID],
 [StArrayID],
 [LastUpdatedDateTime],
 [DeviceID],
 [Index],
 [Capacity],
 [IsPassThroughCapable],
 [IsSanAttached],
 [ClusterDiskID],
 [Location],
 [StorageLUNID],
 [SMLunId],
 [SMLunIdFormat],
 [SMLunIdNamespace],
 [SANType],
 [Bus],
 [Lun],
 [Target],
 [Port],
 [IsVHD],
 [StClassificationId]
FROM dbo.tbl_ADHC_HostDisk
WHERE 
[HostID] = @HostID
AND
[ClusterDiskID] = @ClusterDiskID
 
SELECT @error = @@ERROR
 
SET NOCOUNT OFF
 
RETURN @error
GO
/* script ends here */

 

Advertisements

Author: James van den Berg

I'm Microsoft Architect and ICT Specialist and Microsoft MVP System Center Cloud and Datacenter Management

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s